select
schemaname
,relname as "Table"
,pg_size_pretty(pg_total_relation_size(relid)) as "size"
,pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "external size"
,now()
from pg_catalog.pg_statio_user_tables
where 1=1
order by schemaname,pg_total_relation_size(relid) desc;
'DataBase > Postgresql' 카테고리의 다른 글
postgresql default role (0) | 2019.08.23 |
---|---|
role에 속한 계정 조회 (0) | 2019.08.13 |
테이블단위 autovacuum 끄기 (0) | 2019.08.13 |
Postgresql 테이블 정보, 컬럼 정보 조회 (0) | 2017.11.23 |
postgresql 한글정렬 (0) | 2017.10.12 |