/
620-pg_db_conf.yml
67 lines (63 loc) · 2.17 KB
/
620-pg_db_conf.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
##
# SYNOPSIS
# pg_db_confl_*
#
# DESCRIPTION
# PostgreSQL database conflicts metrics (only available on replica)
#
# OPTIONS
# Tags [cluster, replica]
# TTL 10
# Priority 0
# Timeout 100ms
# Fatal false
# Version 90100 ~ higher
# Source 620-pg_db_conf.yml
#
# METRICS
# datid (DISCARD)
# N/A
# datname (LABEL)
# Name of this database
# confl_tablespace (COUNTER)
# Number of queries in this database that have been canceled due to dropped tablespaces
# confl_lock (COUNTER)
# Number of queries in this database that have been canceled due to lock timeouts
# confl_snapshot (COUNTER)
# Number of queries in this database that have been canceled due to old snapshots
# confl_bufferpin (COUNTER)
# Number of queries in this database that have been canceled due to pinned buffers
# confl_deadlock (COUNTER)
# Number of queries in this database that have been canceled due to deadlocks
#
pg_db_confl:
name: pg_db_confl
desc: PostgreSQL database conflicts metrics (only available on replica)
# https://pgpedia.info/p/pg_stat_database_conflicts.html
query: SELECT * FROM pg_stat_database_conflicts;
ttl: 10
min_version: 90100
tags:
- cluster
- replica
metrics:
- datid:
usage: DISCARD
- datname:
usage: LABEL
description: Name of this database
- confl_tablespace:
usage: COUNTER
description: Number of queries in this database that have been canceled due to dropped tablespaces
- confl_lock:
usage: COUNTER
description: Number of queries in this database that have been canceled due to lock timeouts
- confl_snapshot:
usage: COUNTER
description: Number of queries in this database that have been canceled due to old snapshots
- confl_bufferpin:
usage: COUNTER
description: Number of queries in this database that have been canceled due to pinned buffers
- confl_deadlock:
usage: COUNTER
description: Number of queries in this database that have been canceled due to deadlocks