SELECT 	datname as "database", 
	pg_database_size(datname) as "database_size_bytes",
	pg_size_pretty(pg_database_size(datname)) as "database_size"
FROM 	pg_database
WHERE 	datistemplate = false
order by "database"