Skip to content

Instantly share code, notes, and snippets.

@a1anw2

a1anw2/Postgres get database size

Created February 18, 2022 14:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save a1anw2/62d410fa6faf3f7bc07fefdc45260619 to your computer and use it in GitHub Desktop.
Save a1anw2/62d410fa6faf3f7bc07fefdc45260619 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Postgres get database size
select
t1.datname AS db_name,
pg_size_pretty(pg_database_size(t1.datname)) as db_size
from
pg_database t1
order by
pg_database_size(t1.datname) desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment