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
