postgresql

1. 테이블 용량확인

select pg_size_pretty(pg_total_relation_size('테이블명'));

 

2. 스키마의 테이블 별 용량확인

SELECT 
	nspname || '.' || relname AS "relation",
	pg_size_pretty(pg_relation_size(C.oid)) AS "size",
	pg_size_pretty(pg_total_relation_size(C.oid)) AS "total_size"
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE 1=1
	AND nspname IN ('스키마명') 
	AND C.relkind <> 'i'
	AND nspname !~ '^pg_toast'
ORDER BY pg_total_relation_size(C.oid) desc;