Help Center/
Data Warehouse Service /
Standard Data Warehouse (9.1.0.x)/
DWS System Catalogs and Views/
System Views/
PGXC_TOTAL_SCHEMA_INFO
Updated on 2025-10-09 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.
