ncc.zabbix_templates

Yohn Y. 2025-03-14 Parent:39b1adf10b0b Child:bc85d53acc6e

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