&nbsp;<div style="background-color:#1e1f22;color:#bcbec4;"><pre style="font-family:'JetBrains Mono',monospace;font-size:9.8pt;">-- 테이블 용량 체크할 스키마로 변경 SET search_path TO motolies; -- 용량 체크(where 조건에 스키마명 변경) SELECT relname AS table_name , pg_size_pretty(pg_total_relation_size(quote_ident(relname)::regclass)) AS "Size" , pg_total_relation_size(quote_ident(relname)::regclass) AS total_size , pg_total_relation_size(quote_ident(relname)::regclass) / pg_total_relation_size('pg_class'::regclass) AS total_size_ratio , reltuples::bigint AS row_count FROM pg_class WHERE relnamespace = (SELECT oid FROM pg_namespace WHERE nspname = 'motolies') AND relkind = 'r' -- 'r' denotes a table ORDER BY pg_total_relation_size(quote_ident(relname)::regclass) DESC;</pre></div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

[PostgreSQL] 데이터베이스 사이즈 확인하기