Help Center > > Developer Guide> System Catalogs and System Views> System Views> PGXC_TOTAL_SCHEMA_INFO

PGXC_TOTAL_SCHEMA_INFO

Updated at: Sep 17, 2021 GMT+08:00

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

Name of the node group

usedspace

bigint

Size of used space

permspace

bigint

Upper limit of the space

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel