System Catalogs / Statistics views
pg_stat_database_conflicts
Read the PG 18 manualThe 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.
Reading PG 18current·documented in 17 of 24 versions, 9.1 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 8
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 8
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
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 |
Column history across versions
Version history 6
Definition snapshot: english-manuals:a808e5e2061914a4a796a508c51… · English manual source