PG_PREPARED_XACTS¶
PG_PREPARED_XACTS displays information about transactions that are currently prepared for two-phase commit.
Column | Type | Reference | Description |
|---|---|---|---|
transaction | Xid | N/A | Numeric transaction identifier of the prepared transaction |
gid | Text | N/A | Global transaction identifier that was assigned to the transaction |
prepared | Timestamp with time zone | N/A | Time at which the transaction is prepared for commit |
owner | Name | PG_AUTHID.rolname | Name of the user that executes the transaction |
database | Name | PG_DATABASE.datname | Name of the database in which the transaction is executed |