Volumetria em todos os schema/bancos de dados e tabelas postgresql

volumetria.sql

SELECT datname, pg_size_pretty(pg_database_size(datname))
FROM pg_database;

--Tamanho de todas as tabelas.
SELECT 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"
FROM pg_catalog.pg_stat_all_tables ORDER BY
pg_total_relation_size(relid) DESC;