Скрипт для отображения размеров баз данных в PostgreSQL

SELECT 
    datname AS database_name,
    pg_size_pretty(pg_database_size(datname)) AS human_readable_size,
    pg_database_size(datname) AS size_in_bytes
FROM 
    pg_database
ORDER BY 
    pg_database_size(datname) DESC;