Hi all,
Can you please provide me a Query that tells me how much space is a Schema
in my DB?
I'm using one but don't think it's right....
>
> SELECT schema_name,
> pg_size_pretty(sum(table_size)::bigint),
> (sum(table_size) / pg_database_size(current_database())) * 100 as a
> 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