Para listar as maiores tabelas do seu banco de dados, utilize a consulta abaixo:
WITH table_stats AS ( | |
SELECT | |
schemaname, | |
tablename, | |
pg_relation_size(schemaname || '.'|| tablename) as table_size, | |
(pg_total_relation_size(schemaname || '.'|| tablename) - pg_relation_size(schemaname || '.'|| tablename)) as index_size, | |
pg_total_relation_size(schemaname || '.'|| tablename) as total_size | |
FROM | |
pg_tables | |
) | |
SELECT | |
table_stats.schemaname, | |
table_stats.tablename, | |
pg_size_pretty(table_stats.table_size) as table_size, | |
pg_size_pretty(table_stats.index_size) as index_size, | |
pg_size_pretty(table_stats.total_size) as total_size | |
FROM | |
table_stats | |
WHERE | |
-- ajuste o filtro conforme sua necessidade! | |
table_stats.schemaname = 'public' | |
ORDER BY | |
table_stats.total_size desc, | |
table_stats.index_size desc, | |
table_stats.table_size desc | |
LIMIT 10; |