Skip to content

Instantly share code, notes, and snippets.

@amccarty

amccarty/gist:8e6d0a724ea6113d8bfbf7e452ff9de8

Created December 14, 2016 14:01
Show Gist options
  • Save amccarty/8e6d0a724ea6113d8bfbf7e452ff9de8 to your computer and use it in GitHub Desktop.
Save amccarty/8e6d0a724ea6113d8bfbf7e452ff9de8 to your computer and use it in GitHub Desktop.
Download ZIP
Check postgres DB size on disk
Raw
gistfile1.txt
SELECT pg_database.datname,
pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment