如何查看表、索引、表空间、数据库大小
查询一个索引大小
1
select pg_size_pretty(pg_relation_size(‘indexname))
查看一张表和它的索引总大小
1
select pg_size_pretty(pg_total_relation_size(‘tablename’));
知足常乐,顺其自然
1
select pg_size_pretty(pg_relation_size(‘indexname))
1
select pg_size_pretty(pg_total_relation_size(‘tablename’));