Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Views/ PGXC_TOTAL_SCHEMA_INFO
Updated on 2025-06-12 GMT+08:00
PGXC_TOTAL_SCHEMA_INFO
PGXC_TOTAL_SCHEMA_INFO displays the schema space information of all instances in the cluster, providing visibility into the schema space usage of each instance. This view can be queried only on CNs.
| Column | Type | Description |
|---|---|---|
| schemaname | Text | Schema name. |
| schemaid | OID | Schema OID. |
| databasename | Text | Database name. |
| databaseid | OID | Database OID. |
| nodename | Text | Instance name. |
| nodegroup | Text | Node group name. |
| usedspace | Bigint | Used space size. |
| permspace | Bigint | Space upper limit. |
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.
