PG_PREPARED_XACTS

PG_PREPARED_XACTS displays information about transactions that are currently prepared for two-phase commit.

**Table 1** PG_PREPARED_XACTS columns
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

Parent Topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.