If you have production DB servers, chances are you're running variant of these queries: SELECT sum(pg_relation_size(oid)) from pg_class where relkind = 'i' SELECT sum(pg_relation_size(oid)) from pg_class where relkind = 'r' To get summarized size of tables and/or indexes in your database (for example ...
February 2nd, 2010 by depesz | Tags: administration, pg85, pg90, pg_indexes_size, pg_relation_size, pg_table_size, pg_total_relation_size, postgresql, size | Comments Off on Waiting for 9.0 – table and index sizes
On 19th of January Tom Lane committed really brilliant patch: Log Message: ----------- Add pg_table_size() and pg_indexes_size() to provide more user-friendly wrappers around the pg_relation_size() function. Bernd Helmle, reviewed by Greg Smith