BetaThis is a live doc! Anyone with edit access can make updates in real time without having to publish.
Edited Mar 13
By Bryan
In progress
select
database_name,
pg_size_pretty(subquery.size0) as size
from
(
select
pg_database.datname as database_name,
pg_database_size(pg_database.datname) as size0
from
pg_database
) as subquery
order by
subquery.size0 desc;