Updated on 2024-06-03 GMT+08:00

GET_GLOBAL_PREPARED_XACTS

GET_GLOBAL_PREPARED_XACTS displays prepared transactions on all nodes globally.

Table 1 GET_GLOBAL_PREPARED_XACTS columns

Name

Type

Description

transaction

xid

XID of a prepared transaction

gid

text

GID of the prepared transaction

prepared

timestamp with time zone

Prepared time of the prepared transaction.

owner

name

Owner of the prepared transaction.

database

name

Database to which the prepared transaction belongs.

node_name

text

Name of the node where the prepared transaction resides