Updated on 2022-07-15 GMT+08:00

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.