RDBMS Information - PostgreSQL - Listing size disk consumption per schemas

Purpose

This page lists size disk consumption per schemas.

RDBMS

Release	Yes/No
CSS3
CSS2
CSS1

Details

The query lists schemas with their size on disk order by size description.

select S.table_schema, pg_size_pretty (S.schema_size )
  from (select table_schema, CAST (sum(pg_total_relation_size(table_schema || '.' || table_name ) )as bigint) as schema_size
          from information_schema.tables
        group by table_schema
        order by 2 desc    ) S

Notes / Comments

Related Pages