Updated on 2024-06-03 GMT+08:00

GLOBAL_STAT_DATABASE_CONFLICTS

Displays statistics about the conflict status of each database node. It is used on CNs and the status information of each database node is not summed up, as described in Table 1.

Table 1 GLOBAL_STAT_DATABASE_CONFLICTS columns

Name

Type

Description

node_name

name

Node name.

datid

oid

Database ID.

datname

name

Database name.

confl_tablespace

bigint

Number of conflicting tablespaces.

confl_lock

bigint

Number of conflicting locks.

confl_snapshot

bigint

Number of conflicting snapshots.

confl_bufferpin

bigint

Number of conflicting buffers.

confl_deadlock

bigint

Number of conflicting deadlocks.