Updated on 2025-03-13 GMT+08:00

PG_VARIABLE_INFO

PG_VARIABLE_INFO records information about transaction IDs and OIDs of the current node in a cluster.

Table 1 PG_VARIABLE_INFO columns

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 commission or rollback.

startup_max_xid

xid

Last transaction ID before the node is powered off.