PostgreSQLで各テーブルごとのサイズを確認するクエリ

SELECT 
    tablename AS "Table",
    pg_size_pretty(pg_total_relation_size(tablename::regclass)) AS "Total Size"
FROM 
    pg_tables
WHERE 
    schemaname NOT IN ('pg_catalog', 'information_schema')
ORDER BY 
    pg_total_relation_size(tablename::regclass) DESC;
``