PostgreSQL Veritabanı Boyutları ve Temp Dosya Kullanımı

SELECT d.datname,
       pg_size_pretty(pg_database_size(d.datname)) AS size,
       s.xact_commit, s.xact_rollback, s.deadlocks,
       s.temp_files, pg_size_pretty(s.temp_bytes) AS temp_size
FROM pg_database d
JOIN pg_stat_database s ON s.datname = d.datname
WHERE NOT d.datistemplate
ORDER BY pg_database_size(d.datname) DESC;