PG_VARIABLE_INFO
PGXC_VARIABLE_INFO records information about transaction IDs and OIDs of the current node in a cluster.
Name |
Type |
Description |
---|---|---|
node_name |
text |
Node name. |
next_oid |
oid |
OID generated next time on the node. |
next_xid |
xid |
Transaction ID generated next time on the node. |
oldest_xid |
xid |
Oldest transaction ID on the node. |
xid_vac_limit |
xid |
Critical point (transaction ID) that triggers forcible autovacuum. |
oldest_xid_db |
oid |
OID of the database that has the minimum datafrozenxid on the node. |
last_extend_csn_logpage |
xid |
Number of the last extended CSNlog page. |
start_extend_csn_logpage |
xid |
Number of the page from which CSNlog extending starts. |
next_commit_seqno |
xid |
CSN generated next time on the node. |
latest_completed_xid |
xid |
Latest transaction ID on the node after the transaction commit or rollback. |
startup_max_xid |
xid |
Last transaction ID before the 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.