--查询一个索引大小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
posted @ 2013-10-19 23:38 立春了 Views(2320) Comments(0) Diggs(0) Edit