Lu, Huayi
e6fa411af0
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
7.9 KiB
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 |