테이블 사이즈 확인

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;