Postgresql. DataBase / Table size 확인

Postgresql DataBase size 확인

SELECT datname, pg_size_pretty(pg_database_size('DB명')) from pg_database;

 

 

Postgresql Table size 확인

 

SELECT tablename pg_size_pretty(pg_relation_size('테이블명')) from pg_table;