Skip to content

Instantly share code, notes, and snippets.

@ponceta

ponceta/select_pg_schema_size.sql

Created April 1, 2025 07:55
Show Gist options
  • Save ponceta/4b98c4db4cf033aa482dbd267048b6e1 to your computer and use it in GitHub Desktop.
Save ponceta/4b98c4db4cf033aa482dbd267048b6e1 to your computer and use it in GitHub Desktop.
Download ZIP
SELECT PG SCHEMA SIZE
Raw
select_pg_schema_size.sql
SELECT nspname AS schema_name,
pg_size_pretty(sum(pg_total_relation_size(pg_class.oid))) AS total_size
FROM pg_class
JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid
GROUP BY nspname
ORDER BY sum(pg_total_relation_size(pg_class.oid)) DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment