-
Notifications
You must be signed in to change notification settings - Fork 42
/
930-pgbouncer_stat.yml
111 lines (109 loc) · 3.67 KB
/
930-pgbouncer_stat.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
105
106
107
108
109
110
##
# SYNOPSIS
# pgbouncer_stat_*
#
# DESCRIPTION
# Pgbouncer stats per database
#
# OPTIONS
# Tags [pgbouncer]
# TTL 10
# Priority 0
# Timeout 100ms
# Fatal false
# Version 10800 ~ higher
# Source 930-pgbouncer_stat.yml
#
# METRICS
# database (LABEL)
# Name of database
# total_xact_count (GAUGE)
# Total number of SQL transactions pooled by pgbouncer
# total_query_count (GAUGE)
# Total number of SQL queries pooled by pgbouncer
# total_received (COUNTER)
# Total volume in bytes of network traffic received by pgbouncer
# total_sent (COUNTER)
# Total volume in bytes of network traffic sent by pgbouncer
# total_xact_time (COUNTER)
# Total number of seconds spent when in a transaction
# total_query_time (COUNTER)
# Total number of seconds spent when executing queries
# total_wait_time (COUNTER)
# Time spent by clients waiting for a server, in seconds
# avg_xact_count (GAUGE)
# Average transactions per second in last stat period
# avg_query_count (GAUGE)
# Average queries per second in last stat period
# avg_recv (GAUGE)
# Average received (from clients) bytes per second
# avg_sent (GAUGE)
# Average sent (to clients) bytes per second
# avg_xact_time (GAUGE)
# Average transaction duration, in seconds
# avg_query_time (GAUGE)
# Average query duration, in seconds
# avg_wait_time (GAUGE)
# Time spent by clients waiting for a server, in seconds (average per second).
#
pgbouncer_stat:
name: pgbouncer_stat
desc: Pgbouncer stats per database # http://www.pgbouncer.org/usage.html#show-stats
query: SHOW STATS;
ttl: 10
min_version: 10800
tags:
- pgbouncer
metrics:
- database:
usage: LABEL
rename: datname
description: Name of database
- total_xact_count:
usage: GAUGE
description: Total number of SQL transactions pooled by pgbouncer
- total_query_count:
usage: GAUGE
description: Total number of SQL queries pooled by pgbouncer
- total_received:
usage: COUNTER
description: Total volume in bytes of network traffic received by pgbouncer
- total_sent:
usage: COUNTER
description: Total volume in bytes of network traffic sent by pgbouncer
- total_xact_time:
usage: COUNTER
scale: 1e-6
description: Total number of seconds spent when in a transaction
- total_query_time:
usage: COUNTER
scale: 1e-6
description: Total number of seconds spent when executing queries
- total_wait_time:
usage: COUNTER
scale: 1e-6
description: Time spent by clients waiting for a server, in seconds
- avg_xact_count:
usage: GAUGE
description: Average transactions per second in last stat period
- avg_query_count:
usage: GAUGE
description: Average queries per second in last stat period
- avg_recv:
usage: GAUGE
description: Average received (from clients) bytes per second
- avg_sent:
usage: GAUGE
description: Average sent (to clients) bytes per second
- avg_xact_time:
usage: GAUGE
scale: 1e-6
description: Average transaction duration, in seconds
- avg_query_time:
usage: GAUGE
scale: 1e-6
description: Average query duration, in seconds
- avg_wait_time:
usage: GAUGE
scale: 1e-6
description: Time spent by clients waiting for a server, in seconds (average per second).