• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_RUNNING_XACTS

PG_RUNNING_XACTS

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