Skip to content

Instantly share code, notes, and snippets.

@Megaprog

Megaprog/schema_size.sql

Created January 24, 2022 11:23
Show Gist options
  • Save Megaprog/3f0c5618d64d5a2ac197b1907ad064d0 to your computer and use it in GitHub Desktop.
Save Megaprog/3f0c5618d64d5a2ac197b1907ad064d0 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
schema_size.sql
SELECT schema_name,
pg_size_pretty(sum(table_size)::bigint),
(sum(table_size) / pg_database_size(current_database())) * 100
FROM (
SELECT pg_catalog.pg_namespace.nspname as schema_name,
pg_relation_size(pg_catalog.pg_class.oid) as table_size
FROM pg_catalog.pg_class
JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid
) t
GROUP BY schema_name
ORDER BY schema_name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment