Check a size of all databases in PostgreSQL - MUMT-IT/mis2018 GitHub Wiki

SELECT 
    d.datname AS database_name,
    pg_size_pretty(pg_database_size(d.datname)) AS database_size
FROM 
    pg_database d
ORDER BY 
    pg_database_size(d.datname) DESC;