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). pg_prepared_xacts contains one row per prepared transaction. An entry is removed when the transaction is committed or rolled back.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- transaction, gid, prepared, owner, database
- runtime verified
- false
- source
- english-manual
Definition PG 18
The view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details). pg_prepared_xacts contains one row per prepared transaction. An entry is removed when the transaction is committed or rolled back.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| transaction | xid | Nullable | Numeric transaction identifier of the prepared transaction |
| gid | text | Nullable | Global transaction identifier that was assigned to the transaction |
| prepared | timestamptz | Nullable | Time at which the transaction was prepared for commit |
| owner | name | Nullable | Name of the user that executed the transaction |
| database | name | Nullable | Name of the database in which the transaction was executed |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:d1211754a934eaea9470d259c9b4c4759c445a583da8706e1e91198e1656f9fd
Text language: en · catalog-bilingual-repair:d1211754a934eaea9470d259c9b4c4759c445a583da8706e1e91198e1656f9fd