Help Center > > Developer Guide> System Catalogs and System Views> System Views> PGXC_RUNNING_XACTS

PGXC_RUNNING_XACTS

Updated at: Jul 15, 2020 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 by 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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel