查看表空间的大小
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_databaseorder 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;