--查询一个索引大小select pg_size_pretty(pg_relation_size('indexname))--查看一张表及此它上的索引总大小select pg_size_pretty(pg_total_relation_size('tablename'));--查看所有 schema里面索引大小,大到小的顺序排列:select indexrelname,pg_size_pretty( pg_relation_size(relid))from pg_stat_user_indexes where schemaname = 'schemaname Read More