Help Center/
Data Warehouse Service /
Standard Data Warehouse (9.1.0.x)/
DWS System Catalogs and Views/
System Views/
PG_TOTAL_SCHEMA_INFO
Updated on 2025-10-09 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
