Updated on 2023-10-23 GMT+08:00

PG_STAT_DATABASE_CONFLICTS

PG_STAT_DATABASE_CONFLICTS displays statistics about database conflicts.

Table 1 PG_STAT_DATABASE_CONFLICTS columns

Name

Type

Description

datid

oid

ID of a database

datname

name

Database name

confl_tablespace

bigint

Number of conflicting tablespaces

confl_lock

bigint

Number of conflicting locks

confl_snapshot

bigint

Number conflicting snapshots

confl_bufferpin

bigint

Number of conflicting buffers

confl_deadlock

bigint

Number of conflicting deadlocks