Lu, Huayi a24ca60074 DWS DEVELOPER 811 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2023-01-19 13:37:49 +00:00

7.9 KiB

Raw Permalink Blame History

PGXC_VARIABLE_INFO

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

Parent topic: System Views

7.9 KiB Raw Permalink Blame History

PGXC_VARIABLE_INFO

7.9 KiB

Raw Permalink Blame History