通过SQL查询查看pg_tables中每个表的大小（包括数据和索引）

jiawang

SELECT
    tablename,
    pg_size_pretty(pg_total_relation_size(quote_ident(schemaname) || '.' || quote_ident(tablename))) AS total_size
FROM
    pg_tables
WHERE
    schemaname NOT IN ('pg_catalog', 'information_schema')
ORDER BY
    pg_total_relation_size(quote_ident(schemaname) || '.' || quote_ident(tablename)) DESC;

登录/注册后可看大图