PostgreSQL查看数据库对象大小

PostgreSQL查看数据库对象大小

1、查看某个数据库大小

select pg_size_pretty(pg_database_size('tzqdb'));

2、查看多个数据库大小

select pg_database.datname,pg_size_pretty (pg_database_size(pg_database.datname)) AS sizefrom pg_databaseorder by pg_database_size(pg_database.datname) desc;

3、按顺序查看索引大小

select indexrelname,pg_size_pretty(pg_relation_size(relid)) from pg_stat_user_indexes where 1=1-- and schemaname='public' order by pg_relation_size(relid) desc;

4、查看所有对象的大小

select relname,pg_size_pretty(pg_relation_size(relid))from pg_stat_user_tableswhere 1=1-- and schemaname='public'order by pg_relation_size(relid) desc;