=== Grösse der DB ===

<code>
SELECT pg_size_pretty(pg_database_size('<dbname>')); 
</code>
=== Platzbedarf der Tabellen ===

<code>
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;
</code>

=== Platzbedarf der Indizes ===

<code>
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>

=== Verhältnis Tables zu indices ===
<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;
</code>