Skip to content

Instantly share code, notes, and snippets.

@mcorsen

mcorsen/database_sizes.sql

Created June 6, 2014 16:27
Show Gist options
  • Save mcorsen/5522647841f8157f826f to your computer and use it in GitHub Desktop.
Save mcorsen/5522647841f8157f826f to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql 9.1 query to list database sizes
Raw
database_sizes.sql
SELECT pg_database.datname,
pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database
ORDER BY pg_database_size(pg_database.datname) DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment