Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

PGXC_VARIABLE_INFO

Updated on 2024-12-19 GMT+08:00

PGXC_VARIABLE_INFO displays information about transaction IDs and OIDs of all nodes in a cluster.

Table 1 PGXC_VARIABLE_INFO columns

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

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback