Find out how many pages and tuples are used by a table
select relname as "table", reltuples as "number of tuples", relpages as "number of 8kb pages" from pg_class where relname = 'my_table';
select relname as "table", reltuples as "number of tuples", relpages as "number of 8kb pages" from pg_class where relname = 'my_table';