PGXC_VARIABLE_INFO
PGXC_VARIABLE_INFO displays information about XIDs and OIDs of all nodes in a cluster.
Column |
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.