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

PGXC_VARIABLE_INFO

Updated at: Jul 15, 2020 GMT+08:00

PGXC_VARIABLE_INFO displays information about transaction IDs and OIDs of all nodes in a cluster.

Table 1 PGXC_VARIABLE_INFO columns

Name

Type

Description

node_name

text

Node name

nextOid

oid

OID generated next time for a node

nextXid

xid

Transaction ID generated next time for a node

oldestXid

xid

Oldest transaction ID on a node

xidVacLimit

xid

Critical point (transaction ID) that triggers forcible autovacuum

oldestXidDB

oid

OID of the database that has the minimum datafrozenxid on a node

lastExtendCSNLogpage

integer

Number of the last extended csnlog page

startExtendCSNLogpage

integer

Number of the page from which the csnlog extending starts

nextCommitSeqNo

integer

CSN generated next time for a node

latestCompletedXid

xid

Latest transaction ID on a node after the transaction commission or rollback

startupMaxXid

xid

Last transaction ID before a node is powered off

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