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;