PGXC_VARIABLE_INFO

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	Next OID to be generated under this node.
nextXid	xid	Next transaction OID to be generated under this node.
oldestXid	xid	Oldest transaction ID for a node
xidVacLimit	xid	Critical point for forcing autovacuum.
oldestXidDB	oid	Database OID with the minimum datafrozenxid under this node.
lastExtendCSNLogpage	integer	Page number of the last extension of csnlog.
startExtendCSNLogpage	integer	Starting page number of the csnlog extension.
nextCommitSeqNo	integer	Next CSN to be generated under this node.
latestCompletedXid	xid	Latest transaction ID on the node after commit or rollback.
startupMaxXid	xid	Last transaction ID before the node shutdown.