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 size
  from pg_database
 order 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_tables
 where 1=1
   -- and schemaname='public'
 order by pg_relation_size(relid) desc;