Postgres 数据库、schema、table 大小获取方式

00.sql

-- 数据库大小
select pg_size_pretty(pg_database_size(current_database()));

-- 只计算table size
select schemaname, pg_size_pretty(sum(pg_relation_size(schemaname || '.' || tablename))) from pg_tables group by schemaname;