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.

Kind: Statistics views
Columns in this snapshot: 8
Definition source: English manual

Columns 8

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

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`datid`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`datname`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`confl_tablespace`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`confl_lock`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`confl_snapshot`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`confl_bufferpin`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`confl_deadlock`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`confl_active_logicalslot`	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●	●	●	●
`stats_reset`	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	·	●	●

Version history 11

Definition snapshot: english-manuals:a5f6ec9b63ef9454f256689d6a9… · English manual source