-
Notifications
You must be signed in to change notification settings - Fork 56
Expand file tree
/
Copy path0930-pgbouncer_stat.yml
More file actions
89 lines (85 loc) · 8.4 KB
/
0930-pgbouncer_stat.yml
File metadata and controls
89 lines (85 loc) · 8.4 KB
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
#==============================================================#
# 0930 pgbouncer_stat
#==============================================================#
# http://www.pgbouncer.org/usage.html#show-stats
pgbouncer_stat_124:
name: pgbouncer_stat
desc: Pgbouncer stats per database (since 1.24)
query: SHOW STATS;
ttl: 10
min_version: 12400
tags: [ pgbouncer ]
metrics:
- database: { usage: LABEL ,rename: datname ,description: "Name of database" }
- total_xact_count: { usage: COUNTER ,description: "Total number of SQL transactions pooled by pgbouncer" }
- total_query_count: { usage: COUNTER ,description: "Total number of SQL queries pooled by pgbouncer" }
- total_server_assignment_count: { usage: COUNTER ,description: "Total times a server was assigned to a client" }
- 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" }
- total_client_parse_count: { usage: COUNTER ,description: "Total number of prepared statements created by clients" }
- total_server_parse_count: { usage: COUNTER ,description: "Total number of prepared statements created on a server." }
- total_bind_count: { usage: COUNTER ,description: "Total number of prepared statements readied for execution by clients and forwarded to postgres" }
- 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_server_assignment_count: { usage: GAUGE ,description: "Average number of times a server as assigned to a client per second in the 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)." }
- avg_client_parse_count: { usage: GAUGE ,description: "Average number of prepared statements created by clients" }
- avg_server_parse_count: { usage: GAUGE ,description: "Average number of prepared statements created on a server." }
- avg_bind_count: { usage: GAUGE ,description: "Average number of prepared statements readied for execution by clients and forwarded to postgres" }
pgbouncer_stat_123:
name: pgbouncer_stat
desc: Pgbouncer stats per database (1.23)
query: SHOW STATS;
ttl: 10
min_version: 12300
max_version: 12400
tags: [ pgbouncer ]
metrics:
- database: { usage: LABEL ,rename: datname ,description: "Name of database" }
- total_xact_count: { usage: COUNTER ,description: "Total number of SQL transactions pooled by pgbouncer" }
- total_query_count: { usage: COUNTER ,description: "Total number of SQL queries pooled by pgbouncer" }
- total_server_assignment_count: { usage: COUNTER ,description: "Total times a server was assigned to a client" }
- 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_server_assignment_count: { usage: GAUGE ,description: "Average number of times a server as assigned to a client per second in the 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)." }
pgbouncer_stat_108:
name: pgbouncer_stat
desc: Pgbouncer stats per database (1.08 - 1.22)
query: SHOW STATS;
ttl: 10
min_version: 10800
max_version: 12300
tags: [ pgbouncer ]
metrics:
- database: { usage: LABEL ,rename: datname ,description: "Name of database" }
- total_xact_count: { usage: COUNTER ,description: "Total number of SQL transactions pooled by pgbouncer" }
- total_query_count: { usage: COUNTER ,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)." }