Skip to content

Instantly share code, notes, and snippets.

@ajepe

ajepe/database.sql

Created October 16, 2019 06:49
Show Gist options
  • Save ajepe/be9db0378759973da752c2802d08586d to your computer and use it in GitHub Desktop.
Save ajepe/be9db0378759973da752c2802d08586d to your computer and use it in GitHub Desktop.
Download ZIP
Get database size
Raw
database.sql
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