Check size of PostgreSQL databases

Minimal Examples

A minimal example on how to check size of all databases in a PostgreSQL server.

select 
t1.datname AS db_name,  
pg_size_pretty(pg_database_size(t1.datname)) as db_size
from pg_database t1
order by pg_database_size(t1.datname) desc;