pg数据库 查询数据库 表 索引大小

1、查询数据库大小

select pg_size_pretty(pg_database_size('mastadb')) as size;

2、查询表的大小

select pg_size_pretty(pg_total_relation_size('track')) as size;

3、查询所有表的大小

select relname, pg_size_pretty(pg_total_relation_size(relid)) from pg_stat_user_tables where schemaname='masta' order by pg_relation_size(relid) desc;

3、查询表的索引大小

select pg_size_pretty(pg_indexes_size('track')) as size;