Page History

DROP TABLE IF EXISTS abc;
CREATE TABLE abc (x int PRIMARY KEY, y int);
CREATE INDEX ON abc (y);
INSERT INTO abc
SELECT x, x % 16378
FROM generate_series(1,1000000) x;
 
DROP TABLE IF EXISTS abc;
CREATE TABLE abc (x int PRIMARY KEY, y int);
CREATE INDEX ON abc (y);
INSERT INTO abc
SELECT x, x % 16378
FROM generate_series(1,1000000) x;
 
SELECT pg_size_pretty(pg_relation_size('abc_y_idx')); -- Get the size of index
 
EXPLAIN ANALYZE
SELECT count(*)
FROM abc
WHERE y = 50;
 
DROP INDEX abc_y_idx;
ANALYZE abc;
 
EXPLAIN ANALYZE
SELECT *
FROM abc
WHERE x % 13 = 0
ORDER BY x, y DESC
LIMIT 13;