psql 查询所有表的大小

您可以使用以下命令查询所有表的大小：

SELECT table_name, pg_size_pretty(pg_total_relation_size('"' || table_name || '"')) AS size
FROM information_schema.tables
WHERE table_schema = 'public'
ORDER BY pg_total_relation_size('"' || table_name || '"') DESC;