System Catalogs / System views
pg_prepared_xacts
Read the PG 18 manualThe view pg_prepared_xacts displays information about transactions that are currently prepared for two-phase commit (see PREPARE TRANSACTION for details).
Reading PG 18current·documented in 22 of 24 versions, 8.1 to 20
- Kind
- System views
- Columns in this snapshot
- 5
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 5
As listed in the PostgreSQL 18 manual.
| 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
Version history 1
- 8.0 → 8.1 added
Definition snapshot: english-manuals:afaad40723b598fc06742ac3382… · English manual source