Use this:

SELECT pg_database.datname as "database_name", pg_database_size(pg_database.datname)/1024/1024 AS size_in_mb FROM pg_database ORDER by size_in_mb DESC;

Opscomplete powered by

Save money by migrating from AWS to our fully managed hosting in Germany.

Trusted by over 100 customers
Ready to use with Ruby, Node.js, PHP
Proactive management by operations experts

PostgreSQL: Show size of all databases

Opscomplete powered by