GLOBAL_TRANSACTIONS_PREPARED_XACTS
GLOBAL_TRANSACTIONS_PREPARED_XACTS displays information about 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
|