Qual o tamanho ocupado por cada tabela no PostgreSQL?

RT.DB.FAQ-16975

O tamanho das tabelas no PG (table size) com e sem os indices pode ser obtido atrav�s da seguinte consulta:

   SELECT nspname || '.' || relname AS "Tabela"
   , c.reltuples::integer AS "Registros"
   , pg_size_pretty(pg_relation_size(c.oid)) AS "Dados"
   , pg_size_pretty(pg_total_relation_size(c.oid)) AS "Dados e Indices"
   FROM pg_class c
   LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
   WHERE nspname NOT IN ('pg_catalog', 'information_schema')
   AND c.relkind <> 'i'
   AND nspname !~ '^pg_toast'
   ORDER BY pg_relation_size(C.oid) DESC;