Updated on 2024-09-30 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.

Table 1 PGXC_TOTAL_SCHEMA_INFO columns

Name

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.