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.
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
- statistics
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- datid, datname, confl_tablespace, confl_lock, confl_snapshot, confl_bufferpin, confl_deadlock, confl_active_logicalslot
- runtime verified
- false
- source
- english-manual
Definition PG 18
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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| datid | oid | Nullable | OID of a database |
| datname | name | Nullable | Name of this database |
| confl_tablespace | bigint | Nullable | Number of queries in this database that have been canceled due to dropped tablespaces |
| confl_lock | bigint | Nullable | Number of queries in this database that have been canceled due to lock timeouts |
| confl_snapshot | bigint | Nullable | Number of queries in this database that have been canceled due to old snapshots |
| confl_bufferpin | bigint | Nullable | Number of queries in this database that have been canceled due to pinned buffers |
| confl_deadlock | bigint | Nullable | Number of queries in this database that have been canceled due to deadlocks |
| confl_active_logicalslot | bigint | Nullable | 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 |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:87a6bbaff8e894066d6eb03436331bc6139e95ecc56c100dd5c683f97ef9f2a2
Text language: en · catalog-bilingual-repair:87a6bbaff8e894066d6eb03436331bc6139e95ecc56c100dd5c683f97ef9f2a2