PGXC_VARIABLE_INFO
PGXC_VARIABLE_INFO displays information about transaction IDs and OIDs of all nodes in a cluster.
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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot