1.查询单个表的大小
select pg_size_pretty(pg_relation_size(‘表名’));
2.列出所有表的大小
SELECT table_schema || ‘.’ || table_name AS table_full_name, pg_size_pretty(pg_total_relation_size(’"’ || table_schema || ‘"."’ || table_name || ‘"’)) AS size
FROM information_schema.tables
ORDER BY
pg_total_relation_size(’"’ || table_schema || ‘"."’ || table_name || ‘"’) DESC limit 20
3. 查询数据库的大小
select pg_size_pretty(pg_database_size(‘数据库名’));