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

GLOBAL_TRANSACTIONS_PREPARED_XACTS

GLOBAL_TRANSACTIONS_PREPARED_XACTS displays information about the transactions that are currently prepared for two-phase commit on each node.

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 that executes the transaction

database

name

Name of the database in which the transaction is executed