postgresql查看数据库物理大小

1.查看数据库总大小 select pg_size_pretty(pg_database_size('incidentdispatch')); 2.查看数据库oid SELECT oid from pg_database where datname='incidentdispatch'; 3.查看指定模式下每个表的大小 SELECT table_name, pg_size_pretty(total_bytes) AS total_size FROM ( SELECT...