Skip to content

Instantly share code, notes, and snippets.

@AndreyStekov

AndreyStekov/pg_schema_size.sql

Created April 6, 2015 09:58
Show Gist options
  • Save AndreyStekov/ea09951a120f1400921e to your computer and use it in GitHub Desktop.
Save AndreyStekov/ea09951a120f1400921e to your computer and use it in GitHub Desktop.
Download ZIP
Get schema size (postgres).
Raw
pg_schema_size.sql
SELECT pg_size_pretty(sum(pg_relation_size(quote_ident(schemaname) || '.' || quote_ident(tablename)))::bigint) FROM pg_tables
WHERE schemaname = 'yourschema'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment