SYSTEM VIEW · System view
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.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_prepared_xacts| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
transaction |
xid |
Numeric transaction identifier of the prepared transaction |
gid |
text |
Global transaction identifier that was assigned to the transaction |
prepared |
timestamp with time zoneDocumented as:timestamptz |
Time at which the transaction was prepared for commit |
owner |
name |
Name of the user that executed the transactionReferences:pg_authid.rolname |
database |
name |
Name of the database in which the transaction was executedReferences:pg_database.datname |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column type9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsNo column-structure or description change between the covered versions.
Compare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.