Notice
Recent Posts
Recent Comments
Link
아미(아름다운미소)
Postgres: Show Schema Sizes in a Database 본문
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: 데이터베이스의 스키마 크기 표시
'데이타베이스' 카테고리의 다른 글
Postgresql timezone 변경 (0) | 2021.12.18 |
---|---|
[SQL] SQLGate 키보드 단축키 (0) | 2018.03.09 |
0 Comments