PGXC_TOTAL_SCHEMA_INFO_ANALYZE

PGXC_TOTAL_SCHEMA_INFO_ANALYZE displays the overall schema space information of the cluster, including the total cluster space, average space of instances, skew ratio, maximum space of a single instance, minimum space of a single instance, and names of the instances with the maximum space and minimum space. It provides visibility into the schema space usage of the entire cluster. This view can be queried only on CNs.

**Table 1** PGXC_TOTAL_SCHEMA_INFO_ANALYZE columns
Name	Type	Description
schemaname	text	Schema name.
databasename	text	Database name.
nodegroup	text	Node group name.
total_value	bigint	Total cluster space in this schema.
avg_value	bigint	Average space per instance in this schema.
skew_percent	integer	Skew ratio.
extend_info	text	The extended information includes the maximum and minimum space values for a single instance, as well as the names of the instances with the maximum and minimum space values.