PostgreSQL查询表和index占用空间大小 PostgreSQL表和index占用空间大小信息存储在 information_schema.tables中 通过SQL可以查询到相应的统计数据 –查出单个表的大小 select pg_size_pretty(pg_relation_size(‘TABLENAME’)); 查出表大小按大小含Index — 查出表大小按大小含Index SELECT “table_name”, pg_size_pretty(table_size) AS table_size, pg_size_pretty(indexes_size) AS indexes_size, pg_size_pretty(total_size) AS total_size FROM ( SELECT table_name, SUBSTRING(“table_name”,1,10) as short_name, pg_table_size(table_name) AS table_size, pg_indexes_size(table_name) AS indexes_size, pg_total_relation_size(table_name) AS total_size FROM ( SELECT (‘”‘ || table_schema || ‘”.”‘ || table_name || ‘”‘) AS table_name FROM information_schema.tables ) AS …