PostgreSQL 19 ← 18
← Catalog atlas / pg_stat_database_conflicts
STATISTICS VIEW · Statistics view
pg_stat_database_conflicts
The pg_stat_database_conflicts view will contain one row per database, showing database-wide statistics about query cancels occurring due to conflicts with recovery on standby servers. This view will only contain information on standby servers, since conflicts do not occur on primary servers.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_stat_database_conflictsPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
datid |
oid |
OID of a database |
datname |
name |
Name of this database |
confl_tablespace |
bigint |
Number of queries in this database that have been canceled due to dropped tablespaces |
confl_lock |
bigint |
Number of queries in this database that have been canceled due to lock timeouts |
confl_snapshot |
bigint |
Number of queries in this database that have been canceled due to old snapshots |
confl_bufferpin |
bigint |
Number of queries in this database that have been canceled due to pinned buffers |
confl_deadlock |
bigint |
Number of queries in this database that have been canceled due to deadlocks |
confl_active_logicalslot |
bigint |
Number of uses of logical slots in this database that have been canceled due to old snapshots or too low a wal_level on the primary |
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 typePresentAdded / type or attribute changeRemoved
9.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 majorsPostgreSQL 16 ← 15
PostgreSQL 14 ← 13
PostgreSQL 13 ← 12
PostgreSQL 12 ← 11
PostgreSQL 10 ← 9.6
PostgreSQL 9.6 ← 9.5
PostgreSQL 9.5 ← 9.4
PostgreSQL 9.4 ← 9.3
PostgreSQL 9.2 ← 9.1
PostgreSQL 9.1 ← 9.0Catalog added
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.