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 |
Last Article: PGXC_TOTAL_MEMORY_DETAIL
Next Article: PGXC_WLM_OPERATOR_HISTORY
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.