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
