Postgres Spazio Disco

SELECT pg_size_pretty(pg_database_size(current_database()));

SELECT datname AS "Database",pg_size_pretty(pg_database_size(datname)) AS "Dimensione" FROM pg_database;

Tabelle

SELECT relname AS "Tabella",
      pg_size_pretty(pg_total_relation_size(relid)) AS "Dimensione Totale",
      pg_size_pretty(pg_relation_size(relid)) AS "Dimensione Dati"
FROM pg_catalog.pg_statio_user_tables
ORDER BY pg_total_relation_size(relid) DESC;