lboka/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_04_0789.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

4.7 KiB
Raw Permalink Blame History

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.
Parent topic: System Views