ncc.zabbix_templates

Yohn Y. 2024-09-09 Parent:39b1adf10b0b Child:308f360346c8

34:1f1ee604c8b9 Go to Latest

ncc.zabbix_templates/pgBouncer/zbx_export_templates.yaml

. Ещё один экземпляр в коллекции ненужных сообщений в логах ошибок

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 trends: '0'
156 value_type: TEXT
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 trends: '0'
165 value_type: TEXT
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 trends: '0'
213 value_type: TEXT
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 trends: '0'
260 value_type: TEXT
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 trends: 90d
290 value_type: FLOAT
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 trends: 90d
314 value_type: FLOAT
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 trends: 90d
357 value_type: FLOAT
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 trends: 90d
565 value_type: FLOAT
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 trends: '0'
725 value_type: CHAR
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 trends: 90d
752 units: ms
753 preprocessing:
754 - type: JSONPATH
755 parameters:
756 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_query_time'
757 - type: JSONPATH
758 parameters:
759 - '$[0]'
760 master_item:
761 key: pgbouncer.pool.stats
762 tags:
763 - tag: Application
764 value: PgBouncer
765 - tag: DatabaseName
766 value: '{#PGBOUNCER_DATABASE}'
767 - tag: Func
768 value: 'Статистика БД'
769 - uuid: 4911f76b7b03407b9b39737303714db6
770 name: '{#PGBOUNCER_DATABASE}: Среднее время ожидания свободного подключения'
771 type: DEPENDENT
772 key: 'pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}]'
773 delay: '0'
774 history: 30d
775 trends: 90d
776 units: ms
777 preprocessing:
778 - type: JSONPATH
779 parameters:
780 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_wait_time'
781 - type: JSONPATH
782 parameters:
783 - '$[0]'
784 master_item:
785 key: pgbouncer.pool.stats
786 tags:
787 - tag: Application
788 value: PgBouncer
789 - tag: DatabaseName
790 value: '{#PGBOUNCER_DATABASE}'
791 - tag: Func
792 value: 'Статистика БД'
793 trigger_prototypes:
794 - uuid: 8adff22128884a8cb0e30f215776ae00
795 expression: 'last(/PgBouncer/pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}])>{$PBBOUNCER.WAIT.TIME:"{#PGBOUNCER_DATABASE}"}'
796 name: '{#PGBOUNCER_DATABASE}: Среднее время ожидания в очереди более {$PBBOUNCER.WAIT.TIME:"{#PGBOUNCER_DATABASE}"}ms'
797 priority: AVERAGE
798 - uuid: 70c41f4bed104f65b47256cb1ccd3ff9
799 name: '{#PGBOUNCER_DATABASE}: Средняя продолжительность транзакции'
800 type: DEPENDENT
801 key: 'pgbouncer.stats.db.avg_xact_time[{#PGBOUNCER_DATABASE}]'
802 delay: '0'
803 history: 30d
804 trends: 90d
805 units: ms
806 preprocessing:
807 - type: JSONPATH
808 parameters:
809 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_xact_time'
810 - type: JSONPATH
811 parameters:
812 - '$[0]'
813 master_item:
814 key: pgbouncer.pool.stats
815 tags:
816 - tag: Application
817 value: PgBouncer
818 - tag: DatabaseName
819 value: '{#PGBOUNCER_DATABASE}'
820 - tag: Func
821 value: 'Статистика БД'
822 - uuid: c7784c3d75d0411d920fe6856cf050ea
823 name: '{#PGBOUNCER_DATABASE}: Среднее количество запросов к БД в секунду'
824 type: DEPENDENT
825 key: 'pgbouncer.stats.db.total_query_count[{#PGBOUNCER_DATABASE}]'
826 delay: '0'
827 history: 30d
828 trends: 90d
829 units: rps
830 preprocessing:
831 - type: JSONPATH
832 parameters:
833 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_query_count'
834 - type: JSONPATH
835 parameters:
836 - '$[0]'
837 - type: CHANGE_PER_SECOND
838 parameters:
839 - ''
840 master_item:
841 key: pgbouncer.pool.stats
842 tags:
843 - tag: Application
844 value: PgBouncer
845 - tag: DatabaseName
846 value: '{#PGBOUNCER_DATABASE}'
847 - tag: Func
848 value: 'Статистика БД'
849 - uuid: d6eb4da92aeb44cea5aefb536b4efae1
850 name: '{#PGBOUNCER_DATABASE}: Средняя скорость получения данных балансировщиком'
851 type: DEPENDENT
852 key: 'pgbouncer.stats.db.total_received[{#PGBOUNCER_DATABASE}]'
853 delay: '0'
854 history: 30d
855 trends: 90d
856 units: b/s
857 preprocessing:
858 - type: JSONPATH
859 parameters:
860 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_received'
861 - type: JSONPATH
862 parameters:
863 - '$[0]'
864 - type: CHANGE_PER_SECOND
865 parameters:
866 - ''
867 master_item:
868 key: pgbouncer.pool.stats
869 tags:
870 - tag: Application
871 value: PgBouncer
872 - tag: DatabaseName
873 value: '{#PGBOUNCER_DATABASE}'
874 - tag: Func
875 value: 'Статистика БД'
876 - uuid: 71b50f61435f4df4b97e464952cde5ab
877 name: '{#PGBOUNCER_DATABASE}: Средняя скорость отправки данных балансировщиком'
878 type: DEPENDENT
879 key: 'pgbouncer.stats.db.total_sent[{#PGBOUNCER_DATABASE}]'
880 delay: '0'
881 history: 30d
882 trends: 90d
883 units: b/s
884 description: 'Network traffic sent by pgbouncer in bytes.'
885 preprocessing:
886 - type: JSONPATH
887 parameters:
888 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_sent'
889 - type: JSONPATH
890 parameters:
891 - '$[0]'
892 - type: CHANGE_PER_SECOND
893 parameters:
894 - ''
895 master_item:
896 key: pgbouncer.pool.stats
897 tags:
898 - tag: Application
899 value: PgBouncer
900 - tag: DatabaseName
901 value: '{#PGBOUNCER_DATABASE}'
902 - tag: Func
903 value: 'Статистика БД'
904 - uuid: 1dad183897b14125b07ab89a01caa549
905 name: '{#PGBOUNCER_DATABASE}: Среднее количество транзакций в секунду.'
906 type: DEPENDENT
907 key: 'pgbouncer.stats.db.total_xact_count[{#PGBOUNCER_DATABASE}]'
908 delay: '0'
909 history: 30d
910 trends: 90d
911 units: tps
912 preprocessing:
913 - type: JSONPATH
914 parameters:
915 - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_xact_count'
916 - type: JSONPATH
917 parameters:
918 - '$[0]'
919 - type: CHANGE_PER_SECOND
920 parameters:
921 - ''
922 master_item:
923 key: pgbouncer.pool.stats
924 tags:
925 - tag: Application
926 value: PgBouncer
927 - tag: DatabaseName
928 value: '{#PGBOUNCER_DATABASE}'
929 - tag: Func
930 value: 'Статистика БД'
931 graph_prototypes:
932 - uuid: 25021355bd724712a4b00e6fc62bcaac
933 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения'
934 graph_items:
935 - color: 199C0D
936 item:
937 host: PgBouncer
938 key: 'pgbouncer.pools.db.cl_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
939 - sortorder: '1'
940 color: F63100
941 item:
942 host: PgBouncer
943 key: 'pgbouncer.pools.db.cl_waiting[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
944 - uuid: ca60cfc7d1be4eb5a745e0ae402b7bc4
945 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу'
946 graph_items:
947 - color: 199C0D
948 item:
949 host: PgBouncer
950 key: 'pgbouncer.pools.db.sv_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
951 - sortorder: '1'
952 color: F63100
953 item:
954 host: PgBouncer
955 key: 'pgbouncer.pools.db.sv_login[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
956 - sortorder: '2'
957 color: 2774A4
958 item:
959 host: PgBouncer
960 key: 'pgbouncer.pools.db.sv_tested[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
961 - sortorder: '3'
962 color: F7941D
963 item:
964 host: PgBouncer
965 key: 'pgbouncer.pools.db.sv_idle[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
966 - sortorder: '4'
967 color: FC6EA3
968 item:
969 host: PgBouncer
970 key: 'pgbouncer.pools.db.sv_used[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
971 - uuid: 770b8bebd0074052848690582040f3d6
972 name: 'PgBouncer: Сетевой трафик {#PGBOUNCER_DATABASE}'
973 graph_items:
974 - sortorder: '1'
975 drawtype: GRADIENT_LINE
976 color: 199C0D
977 item:
978 host: PgBouncer
979 key: 'pgbouncer.stats.db.total_received[{#PGBOUNCER_DATABASE}]'
980 - sortorder: '2'
981 drawtype: GRADIENT_LINE
982 color: 0040FF
983 item:
984 host: PgBouncer
985 key: 'pgbouncer.stats.db.total_sent[{#PGBOUNCER_DATABASE}]'
986 macros:
987 - macro: '{$PBBOUNCER.WAIT.TIME}'
988 value: '1000'
989 description: 'Time spent by clients waiting for a server, in microseconds (average per second).'
990 dashboards:
991 - uuid: 391b2243c1c54c9cb4e1031f514d96b2
992 name: 'PgBouncer - обзор'
993 pages:
994 - widgets:
995 - type: graph
996 width: '36'
997 height: '5'
998 fields:
999 - type: GRAPH
1000 name: graphid
1001 value:
1002 host: PgBouncer
1003 name: 'PgBouncer: Подключения'
1004 - type: STRING
1005 name: reference
1006 value: AABHW
1007 - type: graphprototype
1008 'y': '5'
1009 width: '36'
1010 height: '5'
1011 fields:
1012 - type: INTEGER
1013 name: columns
1014 value: '1'
1015 - type: GRAPH_PROTOTYPE
1016 name: graphid
1017 value:
1018 host: PgBouncer
1019 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения'
1020 - type: STRING
1021 name: reference
1022 value: AABHY
1023 - type: graph
1024 'y': '10'
1025 width: '36'
1026 height: '5'
1027 fields:
1028 - type: ITEM
1029 name: itemid
1030 value:
1031 host: PgBouncer
1032 key: pgbouncer.total.avg_query_count
1033 - type: STRING
1034 name: reference
1035 value: AABIA
1036 - type: INTEGER
1037 name: source_type
1038 value: '1'
1039 - type: graph
1040 x: '36'
1041 width: '36'
1042 height: '5'
1043 fields:
1044 - type: GRAPH
1045 name: graphid
1046 value:
1047 host: PgBouncer
1048 name: 'PgBouncer: Объём передаваемых данных по всем БД'
1049 - type: STRING
1050 name: reference
1051 value: AABHX
1052 - type: graphprototype
1053 x: '36'
1054 'y': '5'
1055 width: '36'
1056 height: '5'
1057 fields:
1058 - type: INTEGER
1059 name: columns
1060 value: '1'
1061 - type: GRAPH_PROTOTYPE
1062 name: graphid
1063 value:
1064 host: PgBouncer
1065 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу'
1066 - type: STRING
1067 name: reference
1068 value: AABHZ
1069 - type: graph
1070 x: '36'
1071 'y': '10'
1072 width: '36'
1073 height: '5'
1074 fields:
1075 - type: ITEM
1076 name: itemid
1077 value:
1078 host: PgBouncer
1079 key: pgbouncer.total.avg_query_time
1080 - type: STRING
1081 name: reference
1082 value: AABIB
1083 - type: INTEGER
1084 name: source_type
1085 value: '1'
1086 graphs:
1087 - uuid: 8e8efd0772ab4053bb8c79173010d3e6
1088 name: 'PgBouncer: Объём передаваемых данных по всем БД'
1089 graph_items:
1090 - drawtype: FILLED_REGION
1091 color: 00FF00
1092 item:
1093 host: PgBouncer
1094 key: pgbouncer.total.total_client_bytes
1095 - sortorder: '1'
1096 drawtype: FILLED_REGION
1097 color: 0040FF
1098 item:
1099 host: PgBouncer
1100 key: pgbouncer.total.total_server_bytes
1101 - uuid: b433d80b3d69405e809b607e0a2587b0
1102 name: 'PgBouncer: Подключения'
1103 graph_items:
1104 - color: 199C0D
1105 item:
1106 host: PgBouncer
1107 key: pgbouncer.lists.free_clients
1108 - sortorder: '1'
1109 color: F63100
1110 item:
1111 host: PgBouncer
1112 key: pgbouncer.lists.free_servers
1113 - sortorder: '2'
1114 color: 2774A4
1115 item:
1116 host: PgBouncer
1117 key: pgbouncer.lists.login_clients
1118 - sortorder: '3'
1119 color: F7941D
1120 item:
1121 host: PgBouncer
1122 key: pgbouncer.lists.used_clients
1123 - sortorder: '4'
1124 color: FC6EA3
1125 item:
1126 host: PgBouncer
1127 key: pgbouncer.lists.used_servers