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_RUNNING_XACTS

Updated on 2023-10-31 GMT+08:00

PGXC_RUNNING_XACTS displays information about running transactions on each node in the cluster. The content is the same as that displayed in PG_RUNNING_XACTS.

Table 1 PGXC_RUNNING_XACTS columns

Name

Type

Description

handle

integer

Handle corresponding to the transaction in GTM

gxid

xid

Transaction ID

state

tinyint

Transaction status (3: prepared or 0: starting)

node

text

Node name

xmin

xid

Minimum transaction ID xmin on the node

vacuum

boolean

Whether the current transaction is lazy vacuum

timeline

bigint

Number of database restart

prepare_xid

xid

Transaction ID in prepared state. If the status is not prepared, the value is 0.

pid

bigint

Thread ID corresponding to the transaction

next_xid

xid

Transaction ID sent from a CN to a DN

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback