Help Center/
GaussDB(DWS)/
Standard Data Warehouse (8.1.3.x)/
System Catalogs and System Views/
System Views/
PG_TOTAL_SCHEMA_INFO
Updated on 2023-10-31 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. |
Parent topic: System Views
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.
