Updated on 2023-10-31 GMT+08:00

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

OID generated next time for a node

nextXid

xid

Transaction ID generated next time for a node

oldestXid

xid

Oldest transaction ID for a node

xidVacLimit

xid

Critical point 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