dokuwiki

SELECT pg_size_pretty(pg_database_size('berlinreg')); 

select tablename, pg_size_pretty(s) from (select tablename, pg_relation_size(tablename::text) s from pg_tables where tableowner = '<username>') as ss order by s desc;

 select indexname, tablename, pg_size_pretty(s) from (select tablename, indexname,  pg_relation_size(indexname::text) s from pg_indexes) as ss order by s desc;

<code> select pg_size_pretty(sumind) “space index”, pg_size_pretty(sumtable) “space table”, round(sumind/sumtable, 3) “quotient” from (select sum(pg_relation_size(indexname::text)) sumind from pg_indexes) ti, (select sum(pg_relation_size(tablename::text)) sumtable from pg_tables where tableowner = '<username>') tt;