Postgres размер таблиц и баз данных

postgres-sizw.md

Размер таблиц:

SELECT 
schemaname||'.'||tablename AS full_tname, 
pg_size_pretty(pg_total_relation_size(schemaname||'.'||tablename)) AS total_usage, 
pg_size_pretty((pg_total_relation_size(schemaname||'.'||tablename) - pg_relation_size(schemaname||'.'||tablename))) AS external_table_usage 
FROM pg_catalog.pg_tables 
ORDER BY pg_total_relation_size(schemaname||'.'||tablename) DESC;

Размер базы:

SELECT pg_size_pretty(SUM(pg_total_relation_size(schemaname||'.'||tablename))::bigint) AS grand_total 
FROM pg_catalog.pg_tables