Postgres 管理

查看表空间的大小

select spcname,pg_size_pretty(pg_tablespace_size(spcname)),pg_tablespace_size(spcname) as size  
from  pg_tablespace order by size desc;

查看所有数据库的大小

select datname,pg_size_pretty(pg_database_size(datname)) ,pg_database_size(datname) as size

from pg_database

order by size desc

查看表的大小

select relname, pg_size_pretty(pg_relation_size(relid)),pg_relation_size(relid) as size
from pg_stat_user_tables order by size desc;