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

PG_RUNNING_XACTS

Updated at: Jul 15, 2020 GMT+08:00

PG_RUNNING_XACTS displays the running transaction information on the current node.

Table 1 PG_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

Specifies the 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 the prepared status. 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