Updated on 2024-08-20 GMT+08:00

GLOBAL_TRANSACTIONS_PREPARED_XACTS

Summarizes the information about the transactions that are ready for two-phase commit on each CN and DN in the cluster, as described in Table 1.

Table 1 GLOBAL_TRANSACTIONS_PREPARED_XACTS columns

Name

Type

Description

transaction

xid

Numeric transaction identifier of the prepared transaction.

gid

text

Global transaction identifier that was assigned to the transaction.

prepared

timestamp with time zone

Time at which the transaction is prepared for commit.

owner

name

Name of the user who executes the transaction

database

name

Name of the database in which the transaction is executed.