postgres 스키마 크기 출력

query

SELECT schema_name,     pg_size_pretty(sum(table_size)::bigint) as "disk space",     (sum(table_size) / pg_database_size(current_database())) * 100         as "percent" FROM (      SELECT pg_catalog.pg_namespace.nspname as schema_name,          pg_relation_size(pg_catalog.pg_class.oid) as table_size      FROM   pg_catalog.pg_class          JOIN pg_catalog.pg_namespace               ON relnamespace = pg_catalog.pg_namespace.oid ) t GROUP BY schema_name ORDER BY schema_name; 

 

출력 결과

 

[출처] Postgres: Show Schema Sizes in a Database