pg_prepared_xacts

The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details).

Kind: System views
Columns in this snapshot: 5
Definition source: English manual

Columns 5

Column	Type	Description / reference
`transaction`	`xid`	Numeric transaction identifier of the prepared transaction
`gid`	`text`	Global transaction identifier that was assigned to the transaction
`prepared`	`timestamptz`	Time at which the transaction was prepared for commit
`owner`	`name`	Name of the user that executed the transaction pg_authid.rolname
`database`	`name`	Name of the database in which the transaction was executed pg_database.datname

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`transaction`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`gid`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`prepared`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`owner`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`database`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Definition snapshot: english-manuals:21f188604dadfb9b68ea0b2d4fd… · English manual source