'Database/Postgres' 카테고리의 글 목록

'Database/Postgres'에 해당되는 글 1건

2017.02.22 postgres 스키마 크기 출력

2017.02.22 17:15

postgres 스키마 크기 출력

2017.02.22 17:15 in Database/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;

출력 결과