-
Notifications
You must be signed in to change notification settings - Fork 46
/
Copy path620-pg_db_confl.yml
106 lines (98 loc) · 3.53 KB
/
620-pg_db_confl.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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
##
# 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_16:
name: pg_db_confl
desc: PostgreSQL database conflicts metrics (PG16+, only available on replica)
# https://pgpedia.info/p/pg_stat_database_conflicts.html
query: SELECT * FROM pg_stat_database_conflicts;
ttl: 10
min_version: 160000
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
- confl_active_logicalslot:
usage: COUNTER
description: 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
pg_db_confl_15:
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
max_version: 160000
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