bboks.net™

postgres 스키마 크기 출력 본문

Database/Postgres

postgres 스키마 크기 출력

bboks.net 2017. 2. 22. 17:15

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; 
 
출력 결과