ncc.zabbix_templates

Yohn Y. 2025-05-15 Parent:308f360346c8

36:bc85d53acc6e Go to Latest

ncc.zabbix_templates/pgBouncer/zbx_export_templates.yaml

. PGBouncer: Изменение работы со статистикой времени

Download raw file
View source Diff to previous Annotate
History
1 zabbix_export:
2 version: '7.0'
3 template_groups:
4 - uuid: 22941f4e01294888a9bed3aae15f6ef9
5 name: Templates/AWNET
6 templates:
7 - uuid: b7daeb1192904504a5eedbddf33be7d1
8 template: PgBouncer
9 name: PgBouncer
10 description: |
11 На основе: https://github.com/Lelik13a/Zabbix-PgBouncer
12 Расположение: https://repo.devel.a0fs.ru/ncc.zabbix_templates/file/tip/pgBouncer
13
14 v1.r202505.1
15 groups:
16 - name: Templates/AWNET
17 items:
18 - uuid: 43308caa0203485ba54520d1277e3848
19 name: 'Общее количество свободных клиентских подключений'
20 type: DEPENDENT
21 key: pgbouncer.lists.free_clients
22 delay: '0'
23 history: 30d
24 trends: 90d
25 preprocessing:
26 - type: REGEX
27 parameters:
28 - 'free_clients\s+\|(.*)'
29 - \1
30 master_item:
31 key: pgbouncer.pool.lists
32 tags:
33 - tag: Application
34 value: PgBouncer
35 - tag: Func
36 value: 'Общая статистика'
37 - uuid: 4c8072b421d14f589e18c9c33cef3ca6
38 name: 'Общее количество свободных серверных подключений'
39 type: DEPENDENT
40 key: pgbouncer.lists.free_servers
41 delay: '0'
42 history: 30d
43 trends: 90d
44 preprocessing:
45 - type: REGEX
46 parameters:
47 - 'free_servers\s+\|(.*)'
48 - \1
49 master_item:
50 key: pgbouncer.pool.lists
51 tags:
52 - tag: Application
53 value: PgBouncer
54 - tag: Func
55 value: 'Общая статистика'
56 - uuid: d09efd07dff342478e47a77b0cad696e
57 name: 'Общее количество соединений в состоянии авторизации'
58 type: DEPENDENT
59 key: pgbouncer.lists.login_clients
60 delay: '0'
61 history: 30d
62 trends: 90d
63 preprocessing:
64 - type: REGEX
65 parameters:
66 - 'login_clients\s+\|(.*)'
67 - \1
68 master_item:
69 key: pgbouncer.pool.lists
70 tags:
71 - tag: Application
72 value: PgBouncer
73 - tag: Func
74 value: 'Общая статистика'
75 - uuid: 8af7e91ff25a4b3f81482affe6c876ab
76 name: 'Количество пулов подключений'
77 type: DEPENDENT
78 key: pgbouncer.lists.pools
79 delay: '0'
80 history: 30d
81 trends: 90d
82 description: 'Count of pools.'
83 preprocessing:
84 - type: REGEX
85 parameters:
86 - 'pools\s+\|(.*)'
87 - \1
88 master_item:
89 key: pgbouncer.pool.lists
90 tags:
91 - tag: Application
92 value: PgBouncer
93 - tag: Func
94 value: 'Общая статистика'
95 - uuid: 4919263e31d14542aeae03e9dc54cbb2
96 name: 'Общее количество подключённых клиентов'
97 type: DEPENDENT
98 key: pgbouncer.lists.used_clients
99 delay: '0'
100 history: 30d
101 trends: 90d
102 preprocessing:
103 - type: REGEX
104 parameters:
105 - 'used_clients\s+\|(.*)'
106 - \1
107 master_item:
108 key: pgbouncer.pool.lists
109 tags:
110 - tag: Application
111 value: PgBouncer
112 - tag: Func
113 value: 'Общая статистика'
114 - uuid: bf97b099778a485f857d1ea590315885
115 name: 'Общее количество задействованных подключений к серверу'
116 type: DEPENDENT
117 key: pgbouncer.lists.used_servers
118 delay: '0'
119 history: 30d
120 trends: 90d
121 description: 'Count of used servers.'
122 preprocessing:
123 - type: REGEX
124 parameters:
125 - 'used_servers\s+\|(.*)'
126 - \1
127 master_item:
128 key: pgbouncer.pool.lists
129 tags:
130 - tag: Application
131 value: PgBouncer
132 - tag: Func
133 value: 'Общая статистика'
134 - uuid: 70e000f4bf0a4d6e9e5addc99e3b4b3a
135 name: 'Количество пользователй'
136 type: DEPENDENT
137 key: pgbouncer.lists.users
138 delay: '0'
139 history: 30d
140 trends: 90d
141 preprocessing:
142 - type: REGEX
143 parameters:
144 - 'users\s+\|(.*)'
145 - \1
146 master_item:
147 key: pgbouncer.pool.lists
148 tags:
149 - tag: Application
150 value: PgBouncer
151 - tag: Func
152 value: 'Общая статистика'
153 - uuid: 2f7e4233cec54abfb2f54b252a89863f
154 name: 'PgBouncer lists raw'
155 key: pgbouncer.pool.lists
156 history: '0'
157 value_type: TEXT
158 trends: '0'
159 tags:
160 - tag: Application
161 value: PgBouncer
162 - uuid: 82bfee5ff67e4830bab212d0052e9725
163 name: 'PgBouncer pools raw'
164 key: pgbouncer.pool.pools
165 history: '0'
166 value_type: TEXT
167 trends: '0'
168 preprocessing:
169 - type: JAVASCRIPT
170 parameters:
171 - |
172 var res = []
173 var list_buf = value.split('\n');
174 var my_trim = function (my_el) {
175 if (my_el != undefined) {
176 return String(my_el).trim()
177 } else {
178 return '';
179 };
180 };
181
182 for (var le in list_buf) {
183 if (list_buf[le].trim().length == 0) continue;
184 var el_buf = list_buf[le].split('|');
185
186 res.push({
187 database: my_trim(el_buf[0]),
188 user: my_trim(el_buf[1]),
189 cl_active: my_trim(el_buf[2]),
190 cl_waiting: my_trim(el_buf[3]),
191 cl_active_cancel_req: my_trim(el_buf[4]),
192 cl_waiting_cancel_req: my_trim(el_buf[5]),
193 sv_active: my_trim(el_buf[6]),
194 sv_active_cancel: my_trim(el_buf[7]),
195 sv_being_canceled: my_trim(el_buf[8]),
196 sv_idle: my_trim(el_buf[9]),
197 sv_used: my_trim(el_buf[10]),
198 sv_tested: my_trim(el_buf[11]),
199 sv_login: my_trim(el_buf[12]),
200 maxwait: my_trim(el_buf[13]),
201 maxwait_us: my_trim(el_buf[14]),
202 pool_mode: my_trim(el_buf[15]),
203 });
204 }
205
206 return JSON.stringify(res);
207 tags:
208 - tag: Application
209 value: PgBouncer
210 - uuid: 5d232829001b4711b9441668e430c0ae
211 name: 'PgBouncer stats raw'
212 key: pgbouncer.pool.stats
213 history: '0'
214 value_type: TEXT
215 trends: '0'
216 preprocessing:
217 - type: JAVASCRIPT
218 parameters:
219 - |2
220 var res = []
221 var list_buf = value.split('\n');
222 var my_trim = function (my_el) {
223 if (my_el != undefined) {
224 return String(my_el).trim()
225 } else {
226 return '';
227 };
228 };
229
230 for (var le in list_buf) {
231 if (list_buf[le].trim().length == 0) continue;
232 var el_buf = list_buf[le].split('|');
233
234 res.push({
235 name: my_trim(el_buf[0]),
236 total_xact_count: my_trim(el_buf[2]),
237 total_query_count: my_trim(el_buf[3]),
238 total_received: my_trim(el_buf[4]),
239 total_sent: my_trim(el_buf[5]),
240 total_xact_time: my_trim(el_buf[6]),
241 total_query_time: my_trim(el_buf[7]),
242 total_wait_time: my_trim(el_buf[8]),
243 avg_xact_count: my_trim(el_buf[10]),
244 avg_query_count: my_trim(el_buf[11]),
245 avg_recv: my_trim(el_buf[12]),
246 avg_sent: my_trim(el_buf[13]),
247 avg_xact_time: my_trim(el_buf[14]),
248 avg_query_time: my_trim(el_buf[15]),
249 avg_wait_time: my_trim(el_buf[16]),
250 });
251 }
252
253 return JSON.stringify(res);
254 tags:
255 - tag: Application
256 value: PgBouncer
257 - uuid: 6523b0c631b54900ad00e2b914bbc7ee
258 name: 'PgBouncer totals raw'
259 key: pgbouncer.pool.totals
260 history: '0'
261 value_type: TEXT
262 trends: '0'
263 tags:
264 - tag: Application
265 value: PgBouncer
266 - uuid: c5d602b4909b40c3a3adf30969a4d854
267 name: 'Среднее количество запросов по всем БД'
268 type: DEPENDENT
269 key: pgbouncer.total.avg_query_count
270 delay: '0'
271 history: 30d
272 trends: 90d
273 preprocessing:
274 - type: REGEX
275 parameters:
276 - ' avg_query_count\s+\|(.*)'
277 - \1
278 master_item:
279 key: pgbouncer.pool.totals
280 tags:
281 - tag: Application
282 value: PgBouncer
283 - tag: Func
284 value: 'Общая статистика'
285 - uuid: e0bd310bb159467ab227b01435267dd5
286 name: 'Среднее время запроса по всем БД'
287 type: DEPENDENT
288 key: pgbouncer.total.avg_query_time
289 delay: '0'
290 history: 30d
291 value_type: FLOAT
292 trends: 90d
293 units: s
294 preprocessing:
295 - type: REGEX
296 parameters:
297 - ' avg_query_time\s+\|(.*)'
298 - \1
299 - type: MULTIPLIER
300 parameters:
301 - '1.0E-6'
302 master_item:
303 key: pgbouncer.pool.totals
304 tags:
305 - tag: Application
306 value: PgBouncer
307 - tag: Func
308 value: 'Общая статистика'
309 - uuid: 69d5830cbb8d49a9a29f8cedd786ca6c
310 name: 'Общее среднее время ожидания клиентом сервера (среднее в секунду)'
311 type: DEPENDENT
312 key: pgbouncer.total.avg_wait_time
313 delay: '0'
314 history: 30d
315 value_type: FLOAT
316 trends: 90d
317 units: s
318 preprocessing:
319 - type: REGEX
320 parameters:
321 - ' avg_wait_time\s+\|(.*)'
322 - \1
323 - type: MULTIPLIER
324 parameters:
325 - '1.0E-6'
326 master_item:
327 key: pgbouncer.pool.totals
328 tags:
329 - tag: Application
330 value: PgBouncer
331 - tag: Func
332 value: 'Общая статистика'
333 - uuid: 7370e257bd5340f1bab9c3b45720e465
334 name: 'Среднее количество транзакций по всем БД'
335 type: DEPENDENT
336 key: pgbouncer.total.avg_xact_count
337 delay: '0'
338 history: 30d
339 trends: 90d
340 preprocessing:
341 - type: REGEX
342 parameters:
343 - ' avg_xact_count\s+\|(.*)'
344 - \1
345 master_item:
346 key: pgbouncer.pool.totals
347 tags:
348 - tag: Application
349 value: PgBouncer
350 - tag: Func
351 value: 'Общая статистика'
352 - uuid: 20aa4eb901d044e69d10d45576f492c0
353 name: 'Средняя продолжительность транзакции по всем БД'
354 type: DEPENDENT
355 key: pgbouncer.total.avg_xact_time
356 delay: '0'
357 history: 30d
358 value_type: FLOAT
359 trends: 90d
360 units: s
361 preprocessing:
362 - type: REGEX
363 parameters:
364 - ' avg_xact_time\s+\|(.*)'
365 - \1
366 - type: MULTIPLIER
367 parameters:
368 - '1.0E-6'
369 master_item:
370 key: pgbouncer.pool.totals
371 tags:
372 - tag: Application
373 value: PgBouncer
374 - tag: Func
375 value: 'Общая статистика'
376 - uuid: ac4adb1e65934dab8b13c9bedd88441e
377 name: 'Общее количество полученных от клиентов данных по всем БД'
378 type: DEPENDENT
379 key: pgbouncer.total.total_client_bytes
380 delay: '0'
381 history: 30d
382 trends: 90d
383 units: Bps
384 preprocessing:
385 - type: REGEX
386 parameters:
387 - ' total_client_bytes\s+\|(.*)'
388 - \1
389 - type: CHANGE_PER_SECOND
390 parameters:
391 - ''
392 master_item:
393 key: pgbouncer.pool.totals
394 tags:
395 - tag: Application
396 value: PgBouncer
397 - tag: Func
398 value: 'Общая статистика'
399 - uuid: c120596534a242889f589adddfb25048
400 name: 'Общее количество запросов по всем БД'
401 type: DEPENDENT
402 key: pgbouncer.total.total_query_count
403 delay: '0'
404 history: 30d
405 trends: 90d
406 units: rps
407 preprocessing:
408 - type: REGEX
409 parameters:
410 - ' total_query_count\s+\|(.*)'
411 - \1
412 - type: CHANGE_PER_SECOND
413 parameters:
414 - ''
415 master_item:
416 key: pgbouncer.pool.totals
417 tags:
418 - tag: Application
419 value: PgBouncer
420 - tag: Func
421 value: 'Общая статистика'
422 - uuid: 73635a0c208547ddac86c5636429a1ce
423 name: 'Обще количество информации отправленное клиентам по всем БД'
424 type: DEPENDENT
425 key: pgbouncer.total.total_server_bytes
426 delay: '0'
427 history: 30d
428 trends: 90d
429 units: Bps
430 preprocessing:
431 - type: REGEX
432 parameters:
433 - ' total_server_bytes\s+\|(.*)'
434 - \1
435 - type: CHANGE_PER_SECOND
436 parameters:
437 - ''
438 master_item:
439 key: pgbouncer.pool.totals
440 tags:
441 - tag: Application
442 value: PgBouncer
443 - tag: Func
444 value: 'Общая статистика'
445 - uuid: f68d255de9c64005ad3b569e10517178
446 name: 'Общее количество транзакций по всем БД в секунду'
447 type: DEPENDENT
448 key: pgbouncer.total.total_xact_count
449 delay: '0'
450 history: 30d
451 trends: 90d
452 units: tps
453 preprocessing:
454 - type: REGEX
455 parameters:
456 - ' total_xact_count\s+\|(.*)'
457 - \1
458 - type: CHANGE_PER_SECOND
459 parameters:
460 - ''
461 master_item:
462 key: pgbouncer.pool.totals
463 tags:
464 - tag: Application
465 value: PgBouncer
466 - tag: Func
467 value: 'Общая статистика'
468 discovery_rules:
469 - uuid: 415d14383e6a45c4ae876618c9b83adc
470 name: 'PgBouncer pools discovery'
471 key: pgbouncer.pool.discover
472 delay: 30m
473 lifetime: 1h
474 enabled_lifetime_type: DISABLE_NEVER
475 item_prototypes:
476 - uuid: cb931dfeada449bf9749d11b0fc506c7
477 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных подключений'
478 type: DEPENDENT
479 key: 'pgbouncer.pools.db.cl_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
480 delay: '0'
481 history: 30d
482 trends: 90d
483 description: 'Client connections that are linked to server connection and can process queries.'
484 preprocessing:
485 - type: JSONPATH
486 parameters:
487 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].cl_active'
488 - type: JSONPATH
489 parameters:
490 - '$[0]'
491 master_item:
492 key: pgbouncer.pool.pools
493 tags:
494 - tag: Application
495 value: PgBouncer
496 - tag: DatabaseName
497 value: '{#PGBOUNCER_DATABASE}'
498 - tag: DatabaseUser
499 value: '{#PGBOUNCER_USER}'
500 - tag: Func
501 value: 'Статистика БД'
502 - uuid: ffa5dd15a6194d3a89b0c4b9b01777dd
503 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных подключений в ожидании'
504 type: DEPENDENT
505 key: 'pgbouncer.pools.db.cl_waiting[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
506 delay: '0'
507 history: 30d
508 trends: 90d
509 preprocessing:
510 - type: JSONPATH
511 parameters:
512 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].cl_waiting'
513 - type: JSONPATH
514 parameters:
515 - '$[0]'
516 master_item:
517 key: pgbouncer.pool.pools
518 tags:
519 - tag: Application
520 value: PgBouncer
521 - tag: DatabaseName
522 value: '{#PGBOUNCER_DATABASE}'
523 - tag: DatabaseUser
524 value: '{#PGBOUNCER_USER}'
525 - tag: Func
526 value: 'Статистика БД'
527 - uuid: d40aa8b10f52435e88ac0d7dcb509c38
528 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Максимальное ожидание'
529 type: DEPENDENT
530 key: 'pgbouncer.pools.db.maxwait[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
531 delay: '0'
532 history: 30d
533 trends: 90d
534 units: s
535 description: 'Показывает как долго находится в очереди ожидания подключения к серверу самый старый запрос. Данный параметр начинает расти при не достаточной производительности сервера при обработке запросов. Если наблюдаем данную ситуацию стоит увеличить размер пула подключений к серверу (pool_size)'
536 preprocessing:
537 - type: JSONPATH
538 parameters:
539 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].maxwait'
540 - type: JSONPATH
541 parameters:
542 - '$[0]'
543 master_item:
544 key: pgbouncer.pool.pools
545 tags:
546 - tag: Application
547 value: PgBouncer
548 - tag: DatabaseName
549 value: '{#PGBOUNCER_DATABASE}'
550 - tag: DatabaseUser
551 value: '{#PGBOUNCER_USER}'
552 - tag: Func
553 value: 'Статистика БД'
554 trigger_prototypes:
555 - uuid: 46dd8a2b9a0e4346a1041b897775d44c
556 expression: 'last(/PgBouncer/pgbouncer.pools.db.maxwait[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}])>1'
557 name: '{#PGBOUNCER_USER}: Максимальное время ожидания клиентом в очереди превысило 1 секунду'
558 opdata: 'Время ожидания: {ITEM.LASTVALUE1}'
559 priority: AVERAGE
560 - uuid: 0bc401b00ab64e068068c02aa6843210
561 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Максимальное ожидание (микросекундная компонента)'
562 type: DEPENDENT
563 key: 'pgbouncer.pools.db.maxwait_us[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
564 delay: '0'
565 history: 30d
566 value_type: FLOAT
567 trends: 90d
568 units: micros
569 description: 'Смотреть в описание "Максимального ожидания"'
570 preprocessing:
571 - type: JSONPATH
572 parameters:
573 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].maxwait_us'
574 - type: JSONPATH
575 parameters:
576 - '$[0]'
577 master_item:
578 key: pgbouncer.pool.pools
579 tags:
580 - tag: Application
581 value: PgBouncer
582 - tag: DatabaseName
583 value: '{#PGBOUNCER_DATABASE}'
584 - tag: DatabaseUser
585 value: '{#PGBOUNCER_USER}'
586 - tag: Func
587 value: 'Статистика БД'
588 trigger_prototypes:
589 - uuid: a4971a735cc04479bbde632a0f03926f
590 expression: 'last(/PgBouncer/pgbouncer.pools.db.maxwait_us[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}])>100'
591 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Максимальное время ожидания в очереди на подключение превысило 100 микросекунд'
592 opdata: 'Время ожидания: {ITEM.LASTVALUE1}'
593 priority: INFO
594 - uuid: 7d54c757ce8f4b6eb75b470431aa31f5
595 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных серверных подключений'
596 type: DEPENDENT
597 key: 'pgbouncer.pools.db.sv_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
598 delay: '0'
599 history: 30d
600 trends: 90d
601 preprocessing:
602 - type: JSONPATH
603 parameters:
604 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_active'
605 - type: JSONPATH
606 parameters:
607 - '$[0]'
608 master_item:
609 key: pgbouncer.pool.pools
610 tags:
611 - tag: Application
612 value: PgBouncer
613 - tag: DatabaseName
614 value: '{#PGBOUNCER_DATABASE}'
615 - tag: DatabaseUser
616 value: '{#PGBOUNCER_USER}'
617 - tag: Func
618 value: 'Статистика БД'
619 - uuid: 2a95424618784993986b283ed2b473bf
620 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Простаивающие подключения'
621 type: DEPENDENT
622 key: 'pgbouncer.pools.db.sv_idle[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
623 delay: '0'
624 history: 30d
625 trends: 90d
626 description: 'Server connections that are unused and immediately usable for client queries.'
627 preprocessing:
628 - type: JSONPATH
629 parameters:
630 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_idle'
631 - type: JSONPATH
632 parameters:
633 - '$[0]'
634 master_item:
635 key: pgbouncer.pool.pools
636 tags:
637 - tag: Application
638 value: PgBouncer
639 - tag: DatabaseName
640 value: '{#PGBOUNCER_DATABASE}'
641 - tag: DatabaseUser
642 value: '{#PGBOUNCER_USER}'
643 - tag: Func
644 value: 'Статистика БД'
645 - uuid: bd06403ea5334b01833798324d22345b
646 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных серверных подключений на стадии авторизации'
647 type: DEPENDENT
648 key: 'pgbouncer.pools.db.sv_login[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
649 delay: '0'
650 history: 30d
651 trends: 90d
652 preprocessing:
653 - type: JSONPATH
654 parameters:
655 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_login'
656 - type: JSONPATH
657 parameters:
658 - '$[0]'
659 master_item:
660 key: pgbouncer.pool.pools
661 tags:
662 - tag: Application
663 value: PgBouncer
664 - tag: DatabaseName
665 value: '{#PGBOUNCER_DATABASE}'
666 - tag: DatabaseUser
667 value: '{#PGBOUNCER_USER}'
668 - tag: Func
669 value: 'Статистика БД'
670 - uuid: b7e79133dfca42f49aebb93d5d8749d3
671 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу, находящиеся либо в стадии проверки либо сброса и возврата в пул свободных'
672 type: DEPENDENT
673 key: 'pgbouncer.pools.db.sv_tested[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
674 delay: '0'
675 history: 30d
676 trends: 90d
677 preprocessing:
678 - type: JSONPATH
679 parameters:
680 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_tested'
681 - type: JSONPATH
682 parameters:
683 - '$[0]'
684 master_item:
685 key: pgbouncer.pool.pools
686 tags:
687 - tag: Application
688 value: PgBouncer
689 - tag: DatabaseName
690 value: '{#PGBOUNCER_DATABASE}'
691 - tag: DatabaseUser
692 value: '{#PGBOUNCER_USER}'
693 - tag: Func
694 value: 'Статистика БД'
695 - uuid: 9326b8cd476e4d9891153a0c2924c4d7
696 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Задействованные подключения к серверу'
697 type: DEPENDENT
698 key: 'pgbouncer.pools.db.sv_used[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
699 delay: '0'
700 history: 30d
701 trends: 90d
702 preprocessing:
703 - type: JSONPATH
704 parameters:
705 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_used'
706 - type: JSONPATH
707 parameters:
708 - '$[0]'
709 master_item:
710 key: pgbouncer.pool.pools
711 tags:
712 - tag: Application
713 value: PgBouncer
714 - tag: DatabaseName
715 value: '{#PGBOUNCER_DATABASE}'
716 - tag: DatabaseUser
717 value: '{#PGBOUNCER_USER}'
718 - tag: Func
719 value: 'Статистика БД'
720 - uuid: 1475ff5de3c54ba792458e063bd92d29
721 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Режим управления пулом соединений'
722 type: DEPENDENT
723 key: 'pgbouncer.pools.pool_mode[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
724 delay: '0'
725 history: 30d
726 value_type: CHAR
727 trends: '0'
728 description: 'The pooling mode in use'
729 preprocessing:
730 - type: JSONPATH
731 parameters:
732 - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].pool_mode'
733 - type: JSONPATH
734 parameters:
735 - '$[0]'
736 master_item:
737 key: pgbouncer.pool.pools
738 tags:
739 - tag: Application
740 value: PgBouncer
741 - tag: DatabaseName
742 value: '{#PGBOUNCER_DATABASE}'
743 - tag: DatabaseUser
744 value: '{#PGBOUNCER_USER}'
745 - tag: Func
746 value: 'Статистика БД'
747 - uuid: 7de8a33441434eedb9c49a5c6f9d12b8
748 name: '{#PGBOUNCER_DATABASE}: Средняя продолжительность запроса'
749 type: DEPENDENT
750 key: 'pgbouncer.stats.db.avg_query_time[{#PGBOUNCER_DATABASE}]'
751 delay: '0'
752 history: 30d
753 value_type: FLOAT
754 trends: 90d
755 units: s
756 preprocessing:
757 - type: JSONPATH
758 parameters:
759 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_query_time'
760 - type: JSONPATH
761 parameters:
762 - '$[0]'
763 - type: MULTIPLIER
764 parameters:
765 - '1.0E-6'
766 master_item:
767 key: pgbouncer.pool.stats
768 tags:
769 - tag: Application
770 value: PgBouncer
771 - tag: DatabaseName
772 value: '{#PGBOUNCER_DATABASE}'
773 - tag: Func
774 value: 'Статистика БД'
775 - uuid: 4911f76b7b03407b9b39737303714db6
776 name: '{#PGBOUNCER_DATABASE}: Среднее время ожидания свободного подключения'
777 type: DEPENDENT
778 key: 'pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}]'
779 delay: '0'
780 history: 30d
781 value_type: FLOAT
782 trends: 90d
783 units: s
784 preprocessing:
785 - type: JSONPATH
786 parameters:
787 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_wait_time'
788 - type: JSONPATH
789 parameters:
790 - '$[0]'
791 - type: MULTIPLIER
792 parameters:
793 - '1.0E-6'
794 master_item:
795 key: pgbouncer.pool.stats
796 tags:
797 - tag: Application
798 value: PgBouncer
799 - tag: DatabaseName
800 value: '{#PGBOUNCER_DATABASE}'
801 - tag: Func
802 value: 'Статистика БД'
803 trigger_prototypes:
804 - uuid: 8adff22128884a8cb0e30f215776ae00
805 expression: 'last(/PgBouncer/pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}])>{$PBBOUNCER.WAIT.TIME:"{#PGBOUNCER_DATABASE}"}'
806 name: '{#PGBOUNCER_DATABASE}: Среднее время ожидания в очереди более {$PBBOUNCER.WAIT.TIME:"{#PGBOUNCER_DATABASE}"}ms'
807 priority: AVERAGE
808 - uuid: 70c41f4bed104f65b47256cb1ccd3ff9
809 name: '{#PGBOUNCER_DATABASE}: Средняя продолжительность транзакции'
810 type: DEPENDENT
811 key: 'pgbouncer.stats.db.avg_xact_time[{#PGBOUNCER_DATABASE}]'
812 delay: '0'
813 history: 30d
814 value_type: FLOAT
815 trends: 90d
816 units: s
817 preprocessing:
818 - type: JSONPATH
819 parameters:
820 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_xact_time'
821 - type: JSONPATH
822 parameters:
823 - '$[0]'
824 - type: MULTIPLIER
825 parameters:
826 - '1.0E-6'
827 master_item:
828 key: pgbouncer.pool.stats
829 tags:
830 - tag: Application
831 value: PgBouncer
832 - tag: DatabaseName
833 value: '{#PGBOUNCER_DATABASE}'
834 - tag: Func
835 value: 'Статистика БД'
836 - uuid: c7784c3d75d0411d920fe6856cf050ea
837 name: '{#PGBOUNCER_DATABASE}: Среднее количество запросов к БД в секунду'
838 type: DEPENDENT
839 key: 'pgbouncer.stats.db.total_query_count[{#PGBOUNCER_DATABASE}]'
840 delay: '0'
841 history: 30d
842 trends: 90d
843 units: rps
844 preprocessing:
845 - type: JSONPATH
846 parameters:
847 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_query_count'
848 - type: JSONPATH
849 parameters:
850 - '$[0]'
851 - type: CHANGE_PER_SECOND
852 parameters:
853 - ''
854 master_item:
855 key: pgbouncer.pool.stats
856 tags:
857 - tag: Application
858 value: PgBouncer
859 - tag: DatabaseName
860 value: '{#PGBOUNCER_DATABASE}'
861 - tag: Func
862 value: 'Статистика БД'
863 - uuid: d6eb4da92aeb44cea5aefb536b4efae1
864 name: '{#PGBOUNCER_DATABASE}: Средняя скорость получения данных балансировщиком'
865 type: DEPENDENT
866 key: 'pgbouncer.stats.db.total_received[{#PGBOUNCER_DATABASE}]'
867 delay: '0'
868 history: 30d
869 trends: 90d
870 units: b/s
871 preprocessing:
872 - type: JSONPATH
873 parameters:
874 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_received'
875 - type: JSONPATH
876 parameters:
877 - '$[0]'
878 - type: CHANGE_PER_SECOND
879 parameters:
880 - ''
881 master_item:
882 key: pgbouncer.pool.stats
883 tags:
884 - tag: Application
885 value: PgBouncer
886 - tag: DatabaseName
887 value: '{#PGBOUNCER_DATABASE}'
888 - tag: Func
889 value: 'Статистика БД'
890 - uuid: 71b50f61435f4df4b97e464952cde5ab
891 name: '{#PGBOUNCER_DATABASE}: Средняя скорость отправки данных балансировщиком'
892 type: DEPENDENT
893 key: 'pgbouncer.stats.db.total_sent[{#PGBOUNCER_DATABASE}]'
894 delay: '0'
895 history: 30d
896 trends: 90d
897 units: b/s
898 description: 'Network traffic sent by pgbouncer in bytes.'
899 preprocessing:
900 - type: JSONPATH
901 parameters:
902 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_sent'
903 - type: JSONPATH
904 parameters:
905 - '$[0]'
906 - type: CHANGE_PER_SECOND
907 parameters:
908 - ''
909 master_item:
910 key: pgbouncer.pool.stats
911 tags:
912 - tag: Application
913 value: PgBouncer
914 - tag: DatabaseName
915 value: '{#PGBOUNCER_DATABASE}'
916 - tag: Func
917 value: 'Статистика БД'
918 - uuid: 1dad183897b14125b07ab89a01caa549
919 name: '{#PGBOUNCER_DATABASE}: Среднее количество транзакций в секунду.'
920 type: DEPENDENT
921 key: 'pgbouncer.stats.db.total_xact_count[{#PGBOUNCER_DATABASE}]'
922 delay: '0'
923 history: 30d
924 trends: 90d
925 units: tps
926 preprocessing:
927 - type: JSONPATH
928 parameters:
929 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_xact_count'
930 - type: JSONPATH
931 parameters:
932 - '$[0]'
933 - type: CHANGE_PER_SECOND
934 parameters:
935 - ''
936 master_item:
937 key: pgbouncer.pool.stats
938 tags:
939 - tag: Application
940 value: PgBouncer
941 - tag: DatabaseName
942 value: '{#PGBOUNCER_DATABASE}'
943 - tag: Func
944 value: 'Статистика БД'
945 graph_prototypes:
946 - uuid: 25021355bd724712a4b00e6fc62bcaac
947 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения'
948 graph_items:
949 - color: 199C0D
950 item:
951 host: PgBouncer
952 key: 'pgbouncer.pools.db.cl_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
953 - sortorder: '1'
954 color: F63100
955 item:
956 host: PgBouncer
957 key: 'pgbouncer.pools.db.cl_waiting[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
958 - uuid: ca60cfc7d1be4eb5a745e0ae402b7bc4
959 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу'
960 graph_items:
961 - color: 199C0D
962 item:
963 host: PgBouncer
964 key: 'pgbouncer.pools.db.sv_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
965 - sortorder: '1'
966 color: F63100
967 item:
968 host: PgBouncer
969 key: 'pgbouncer.pools.db.sv_login[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
970 - sortorder: '2'
971 color: 2774A4
972 item:
973 host: PgBouncer
974 key: 'pgbouncer.pools.db.sv_tested[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
975 - sortorder: '3'
976 color: F7941D
977 item:
978 host: PgBouncer
979 key: 'pgbouncer.pools.db.sv_idle[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
980 - sortorder: '4'
981 color: FC6EA3
982 item:
983 host: PgBouncer
984 key: 'pgbouncer.pools.db.sv_used[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
985 - uuid: 770b8bebd0074052848690582040f3d6
986 name: 'PgBouncer: Сетевой трафик {#PGBOUNCER_DATABASE}'
987 graph_items:
988 - sortorder: '1'
989 drawtype: GRADIENT_LINE
990 color: 199C0D
991 item:
992 host: PgBouncer
993 key: 'pgbouncer.stats.db.total_received[{#PGBOUNCER_DATABASE}]'
994 - sortorder: '2'
995 drawtype: GRADIENT_LINE
996 color: 0040FF
997 item:
998 host: PgBouncer
999 key: 'pgbouncer.stats.db.total_sent[{#PGBOUNCER_DATABASE}]'
1000 macros:
1001 - macro: '{$PBBOUNCER.WAIT.TIME}'
1002 value: '1000'
1003 description: 'Time spent by clients waiting for a server, in microseconds (average per second).'
1004 dashboards:
1005 - uuid: 391b2243c1c54c9cb4e1031f514d96b2
1006 name: 'PgBouncer - обзор'
1007 pages:
1008 - widgets:
1009 - type: graph
1010 width: '36'
1011 height: '5'
1012 fields:
1013 - type: GRAPH
1014 name: graphid
1015 value:
1016 host: PgBouncer
1017 name: 'PgBouncer: Подключения'
1018 - type: STRING
1019 name: reference
1020 value: AABHW
1021 - type: graphprototype
1022 'y': '5'
1023 width: '36'
1024 height: '5'
1025 fields:
1026 - type: INTEGER
1027 name: columns
1028 value: '1'
1029 - type: GRAPH_PROTOTYPE
1030 name: graphid
1031 value:
1032 host: PgBouncer
1033 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения'
1034 - type: STRING
1035 name: reference
1036 value: AABHY
1037 - type: graph
1038 'y': '10'
1039 width: '36'
1040 height: '5'
1041 fields:
1042 - type: ITEM
1043 name: itemid
1044 value:
1045 host: PgBouncer
1046 key: pgbouncer.total.avg_query_count
1047 - type: STRING
1048 name: reference
1049 value: AABIA
1050 - type: INTEGER
1051 name: source_type
1052 value: '1'
1053 - type: graph
1054 x: '36'
1055 width: '36'
1056 height: '5'
1057 fields:
1058 - type: GRAPH
1059 name: graphid
1060 value:
1061 host: PgBouncer
1062 name: 'PgBouncer: Объём передаваемых данных по всем БД'
1063 - type: STRING
1064 name: reference
1065 value: AABHX
1066 - type: graphprototype
1067 x: '36'
1068 'y': '5'
1069 width: '36'
1070 height: '5'
1071 fields:
1072 - type: INTEGER
1073 name: columns
1074 value: '1'
1075 - type: GRAPH_PROTOTYPE
1076 name: graphid
1077 value:
1078 host: PgBouncer
1079 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу'
1080 - type: STRING
1081 name: reference
1082 value: AABHZ
1083 - type: graph
1084 x: '36'
1085 'y': '10'
1086 width: '36'
1087 height: '5'
1088 fields:
1089 - type: ITEM
1090 name: itemid
1091 value:
1092 host: PgBouncer
1093 key: pgbouncer.total.avg_query_time
1094 - type: STRING
1095 name: reference
1096 value: AABIB
1097 - type: INTEGER
1098 name: source_type
1099 value: '1'
1100 graphs:
1101 - uuid: 8e8efd0772ab4053bb8c79173010d3e6
1102 name: 'PgBouncer: Объём передаваемых данных по всем БД'
1103 graph_items:
1104 - drawtype: FILLED_REGION
1105 color: 00FF00
1106 item:
1107 host: PgBouncer
1108 key: pgbouncer.total.total_client_bytes
1109 - sortorder: '1'
1110 drawtype: FILLED_REGION
1111 color: 0040FF
1112 item:
1113 host: PgBouncer
1114 key: pgbouncer.total.total_server_bytes
1115 - uuid: b433d80b3d69405e809b607e0a2587b0
1116 name: 'PgBouncer: Подключения'
1117 graph_items:
1118 - color: 199C0D
1119 item:
1120 host: PgBouncer
1121 key: pgbouncer.lists.free_clients
1122 - sortorder: '1'
1123 color: F63100
1124 item:
1125 host: PgBouncer
1126 key: pgbouncer.lists.free_servers
1127 - sortorder: '2'
1128 color: 2774A4
1129 item:
1130 host: PgBouncer
1131 key: pgbouncer.lists.login_clients
1132 - sortorder: '3'
1133 color: F7941D
1134 item:
1135 host: PgBouncer
1136 key: pgbouncer.lists.used_clients
1137 - sortorder: '4'
1138 color: FC6EA3
1139 item:
1140 host: PgBouncer
1141 key: pgbouncer.lists.used_servers