PG_TOTAL_SCHEMA_INFO¶
PG_TOTAL_SCHEMA_INFO displays the storage usage of all schemas in each database. This view is valid only if use_workload_manager is set to on.
Column | Type | Description |
---|---|---|
schemaid | oid | Schema OID |
schemaname | text | Schema name |
databaseid | oid | Database OID |
databasename | name | Database name |
usedspace | bigint | Size of the permanent table storage space used by the schema, in bytes. |
permspace | bigint | Upper limit of the permanent table storage space of the schema, in bytes. |