Quelques requetes SQL pour monitorer sa base PostgreSQL

select datname as base,pg_size_pretty(pg_database_size(datname)) as taille from pg_database order by pg_database_size(datname) desc;

select relname as "Table", pg_size_pretty(pg_total_relation_size(relid)) As "Taille"  FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;

SELECT
 relname AS nom,
 relkind AS type,
 reltuples AS lignes, pg_size_pretty(relpages::bigint*8*1024) AS taille
 FROM pg_class
 WHERE relpages >= 8
 ORDER BY relpages DESC;