ncc.zabbix_templates

Yohn Y. 2024-01-01 Parent:84fd4f8047f7 Child:57989bb46468

18:fb690be54c05 Go to Latest

ncc.zabbix_templates/pgBouncer/zbx_export_templates.yaml

. Изменение в отображении ошибки SSH

Download raw file
View source Diff to previous Annotate
History
1 zabbix_export:
2 version: '6.0'
3 date: '2023-11-27T11:25:38Z'
4 groups:
5 - uuid: 22941f4e01294888a9bed3aae15f6ef9
6 name: Templates/AWNET
7 templates:
8 - uuid: b7daeb1192904504a5eedbddf33be7d1
9 template: PgBouncer
10 name: PgBouncer
11 description: |
12 На основе: https://github.com/Lelik13a/Zabbix-PgBouncer
13 Расположение: https://devel.a0fs.ru/ncc.zabbix_templates/file/tip/pgBouncer
14 groups:
15 - name: Templates/AWNET
16 items:
17 - uuid: 43308caa0203485ba54520d1277e3848
18 name: 'Общее количество свободных клиентских подключений'
19 type: DEPENDENT
20 key: pgbouncer.lists.free_clients
21 delay: '0'
22 history: 30d
23 trends: 90d
24 preprocessing:
25 - type: REGEX
26 parameters:
27 - 'free_clients\s+\|(.*)'
28 - \1
29 master_item:
30 key: pgbouncer.pool.lists
31 tags:
32 - tag: Application
33 value: PgBouncer
34 - tag: Func
35 value: 'Общая статистика'
36 - uuid: 4c8072b421d14f589e18c9c33cef3ca6
37 name: 'Общее количество свободных серверных подключений'
38 type: DEPENDENT
39 key: pgbouncer.lists.free_servers
40 delay: '0'
41 history: 30d
42 trends: 90d
43 preprocessing:
44 - type: REGEX
45 parameters:
46 - 'free_servers\s+\|(.*)'
47 - \1
48 master_item:
49 key: pgbouncer.pool.lists
50 tags:
51 - tag: Application
52 value: PgBouncer
53 - tag: Func
54 value: 'Общая статистика'
55 - uuid: d09efd07dff342478e47a77b0cad696e
56 name: 'Общее количество соединений в состоянии авторизации'
57 type: DEPENDENT
58 key: pgbouncer.lists.login_clients
59 delay: '0'
60 history: 30d
61 trends: 90d
62 preprocessing:
63 - type: REGEX
64 parameters:
65 - 'login_clients\s+\|(.*)'
66 - \1
67 master_item:
68 key: pgbouncer.pool.lists
69 tags:
70 - tag: Application
71 value: PgBouncer
72 - tag: Func
73 value: 'Общая статистика'
74 - uuid: 8af7e91ff25a4b3f81482affe6c876ab
75 name: 'Количество пулов подключений'
76 type: DEPENDENT
77 key: pgbouncer.lists.pools
78 delay: '0'
79 history: 30d
80 trends: 90d
81 description: 'Count of pools.'
82 preprocessing:
83 - type: REGEX
84 parameters:
85 - 'pools\s+\|(.*)'
86 - \1
87 master_item:
88 key: pgbouncer.pool.lists
89 tags:
90 - tag: Application
91 value: PgBouncer
92 - tag: Func
93 value: 'Общая статистика'
94 - uuid: 4919263e31d14542aeae03e9dc54cbb2
95 name: 'Общее количество подключённых клиентов'
96 type: DEPENDENT
97 key: pgbouncer.lists.used_clients
98 delay: '0'
99 history: 30d
100 trends: 90d
101 preprocessing:
102 - type: REGEX
103 parameters:
104 - 'used_clients\s+\|(.*)'
105 - \1
106 master_item:
107 key: pgbouncer.pool.lists
108 tags:
109 - tag: Application
110 value: PgBouncer
111 - tag: Func
112 value: 'Общая статистика'
113 - uuid: bf97b099778a485f857d1ea590315885
114 name: 'Общее количество задействованных подключений к серверу'
115 type: DEPENDENT
116 key: pgbouncer.lists.used_servers
117 delay: '0'
118 history: 30d
119 trends: 90d
120 description: 'Count of used servers.'
121 preprocessing:
122 - type: REGEX
123 parameters:
124 - 'used_servers\s+\|(.*)'
125 - \1
126 master_item:
127 key: pgbouncer.pool.lists
128 tags:
129 - tag: Application
130 value: PgBouncer
131 - tag: Func
132 value: 'Общая статистика'
133 - uuid: 70e000f4bf0a4d6e9e5addc99e3b4b3a
134 name: 'Количество пользователй'
135 type: DEPENDENT
136 key: pgbouncer.lists.users
137 delay: '0'
138 history: 30d
139 trends: 90d
140 preprocessing:
141 - type: REGEX
142 parameters:
143 - 'users\s+\|(.*)'
144 - \1
145 master_item:
146 key: pgbouncer.pool.lists
147 tags:
148 - tag: Application
149 value: PgBouncer
150 - tag: Func
151 value: 'Общая статистика'
152 - uuid: 2f7e4233cec54abfb2f54b252a89863f
153 name: 'PgBouncer lists raw'
154 key: pgbouncer.pool.lists
155 history: '0'
156 trends: '0'
157 value_type: TEXT
158 tags:
159 - tag: Application
160 value: PgBouncer
161 - uuid: 82bfee5ff67e4830bab212d0052e9725
162 name: 'PgBouncer pools raw'
163 key: pgbouncer.pool.pools
164 history: '0'
165 trends: '0'
166 value_type: TEXT
167 preprocessing:
168 - type: JAVASCRIPT
169 parameters:
170 - |
171 var res = []
172 var list_buf = value.split('\n');
173 var my_trim = function (my_el) {
174 if (my_el != undefined) {
175 return String(my_el).trim()
176 } else {
177 return '';
178 };
179 };
180
181 for (var le in list_buf) {
182 if (list_buf[le].trim().length == 0) continue;
183 var el_buf = list_buf[le].split('|');
184
185 res.push({
186 database: my_trim(el_buf[0]),
187 user: my_trim(el_buf[1]),
188 cl_active: my_trim(el_buf[2]),
189 cl_waiting: my_trim(el_buf[3]),
190 cl_active_cancel_req: my_trim(el_buf[4]),
191 cl_waiting_cancel_req: my_trim(el_buf[5]),
192 sv_active: my_trim(el_buf[6]),
193 sv_active_cancel: my_trim(el_buf[7]),
194 sv_being_canceled: my_trim(el_buf[8]),
195 sv_idle: my_trim(el_buf[9]),
196 sv_used: my_trim(el_buf[10]),
197 sv_tested: my_trim(el_buf[11]),
198 sv_login: my_trim(el_buf[12]),
199 maxwait: my_trim(el_buf[13]),
200 maxwait_us: my_trim(el_buf[14]),
201 pool_mode: my_trim(el_buf[15]),
202 });
203 }
204
205 return JSON.stringify(res);
206 tags:
207 - tag: Application
208 value: PgBouncer
209 - uuid: 5d232829001b4711b9441668e430c0ae
210 name: 'PgBouncer stats raw'
211 key: pgbouncer.pool.stats
212 history: '0'
213 trends: '0'
214 value_type: TEXT
215 preprocessing:
216 - type: JAVASCRIPT
217 parameters:
218 - |2
219 var res = []
220 var list_buf = value.split('\n');
221 var my_trim = function (my_el) {
222 if (my_el != undefined) {
223 return String(my_el).trim()
224 } else {
225 return '';
226 };
227 };
228
229 for (var le in list_buf) {
230 if (list_buf[le].trim().length == 0) continue;
231 var el_buf = list_buf[le].split('|');
232
233 res.push({
234 name: my_trim(el_buf[0]),
235 total_xact_count: my_trim(el_buf[1]),
236 total_query_count: my_trim(el_buf[2]),
237 total_received: my_trim(el_buf[3]),
238 total_sent: my_trim(el_buf[4]),
239 total_xact_time: my_trim(el_buf[5]),
240 total_query_time: my_trim(el_buf[6]),
241 total_wait_time: my_trim(el_buf[7]),
242 avg_xact_count: my_trim(el_buf[8]),
243 avg_query_count: my_trim(el_buf[9]),
244 avg_recv: my_trim(el_buf[10]),
245 avg_sent: my_trim(el_buf[11]),
246 avg_xact_time: my_trim(el_buf[12]),
247 avg_query_time: my_trim(el_buf[13]),
248 avg_wait_time: my_trim(el_buf[14]),
249 });
250 }
251
252 return JSON.stringify(res);
253 tags:
254 - tag: Application
255 value: PgBouncer
256 - uuid: 6523b0c631b54900ad00e2b914bbc7ee
257 name: 'PgBouncer totals raw'
258 key: pgbouncer.pool.totals
259 history: '0'
260 trends: '0'
261 value_type: TEXT
262 tags:
263 - tag: Application
264 value: PgBouncer
265 - uuid: c5d602b4909b40c3a3adf30969a4d854
266 name: 'Среднее количество запросов по всем БД'
267 type: DEPENDENT
268 key: pgbouncer.total.avg_query_count
269 delay: '0'
270 history: 30d
271 trends: 90d
272 preprocessing:
273 - type: REGEX
274 parameters:
275 - ' avg_query_count\s+\|(.*)'
276 - \1
277 master_item:
278 key: pgbouncer.pool.totals
279 tags:
280 - tag: Application
281 value: PgBouncer
282 - tag: Func
283 value: 'Общая статистика'
284 - uuid: e0bd310bb159467ab227b01435267dd5
285 name: 'Среднее время запроса по всем БД'
286 type: DEPENDENT
287 key: pgbouncer.total.avg_query_time
288 delay: '0'
289 history: 30d
290 trends: 90d
291 value_type: FLOAT
292 units: ms
293 preprocessing:
294 - type: REGEX
295 parameters:
296 - ' avg_query_time\s+\|(.*)'
297 - \1
298 - type: MULTIPLIER
299 parameters:
300 - '0.001'
301 master_item:
302 key: pgbouncer.pool.totals
303 tags:
304 - tag: Application
305 value: PgBouncer
306 - tag: Func
307 value: 'Общая статистика'
308 - uuid: 69d5830cbb8d49a9a29f8cedd786ca6c
309 name: 'Общее среднее время ожидания клиентом сервера (среднее в секунду)'
310 type: DEPENDENT
311 key: pgbouncer.total.avg_wait_time
312 delay: '0'
313 history: 30d
314 trends: 90d
315 value_type: FLOAT
316 units: ms
317 preprocessing:
318 - type: REGEX
319 parameters:
320 - ' avg_wait_time\s+\|(.*)'
321 - \1
322 - type: MULTIPLIER
323 parameters:
324 - '0.001'
325 master_item:
326 key: pgbouncer.pool.totals
327 tags:
328 - tag: Application
329 value: PgBouncer
330 - tag: Func
331 value: 'Общая статистика'
332 - uuid: 7370e257bd5340f1bab9c3b45720e465
333 name: 'Среднее количество транзакций по всем БД'
334 type: DEPENDENT
335 key: pgbouncer.total.avg_xact_count
336 delay: '0'
337 history: 30d
338 trends: 90d
339 preprocessing:
340 - type: REGEX
341 parameters:
342 - ' avg_xact_count\s+\|(.*)'
343 - \1
344 master_item:
345 key: pgbouncer.pool.totals
346 tags:
347 - tag: Application
348 value: PgBouncer
349 - tag: Func
350 value: 'Общая статистика'
351 - uuid: 20aa4eb901d044e69d10d45576f492c0
352 name: 'Средняя продолжительность транзакции по всем БД'
353 type: DEPENDENT
354 key: pgbouncer.total.avg_xact_time
355 delay: '0'
356 history: 30d
357 trends: 90d
358 value_type: FLOAT
359 units: ms
360 preprocessing:
361 - type: REGEX
362 parameters:
363 - ' avg_xact_time\s+\|(.*)'
364 - \1
365 - type: MULTIPLIER
366 parameters:
367 - '0.001'
368 master_item:
369 key: pgbouncer.pool.totals
370 tags:
371 - tag: Application
372 value: PgBouncer
373 - tag: Func
374 value: 'Общая статистика'
375 - uuid: ac4adb1e65934dab8b13c9bedd88441e
376 name: 'Общее количество полученных от клиентов данных по всем БД'
377 type: DEPENDENT
378 key: pgbouncer.total.total_client_bytes
379 delay: '0'
380 history: 30d
381 trends: 90d
382 units: Bps
383 preprocessing:
384 - type: REGEX
385 parameters:
386 - ' total_client_bytes\s+\|(.*)'
387 - \1
388 - type: CHANGE_PER_SECOND
389 parameters:
390 - ''
391 master_item:
392 key: pgbouncer.pool.totals
393 tags:
394 - tag: Application
395 value: PgBouncer
396 - tag: Func
397 value: 'Общая статистика'
398 - uuid: c120596534a242889f589adddfb25048
399 name: 'Общее количество запросов по всем БД'
400 type: DEPENDENT
401 key: pgbouncer.total.total_query_count
402 delay: '0'
403 history: 30d
404 trends: 90d
405 units: rps
406 preprocessing:
407 - type: REGEX
408 parameters:
409 - ' total_query_count\s+\|(.*)'
410 - \1
411 - type: CHANGE_PER_SECOND
412 parameters:
413 - ''
414 master_item:
415 key: pgbouncer.pool.totals
416 tags:
417 - tag: Application
418 value: PgBouncer
419 - tag: Func
420 value: 'Общая статистика'
421 - uuid: 73635a0c208547ddac86c5636429a1ce
422 name: 'Обще количество информации отправленное клиентам по всем БД'
423 type: DEPENDENT
424 key: pgbouncer.total.total_server_bytes
425 delay: '0'
426 history: 30d
427 trends: 90d
428 units: Bps
429 preprocessing:
430 - type: REGEX
431 parameters:
432 - ' total_server_bytes\s+\|(.*)'
433 - \1
434 - type: CHANGE_PER_SECOND
435 parameters:
436 - ''
437 master_item:
438 key: pgbouncer.pool.totals
439 tags:
440 - tag: Application
441 value: PgBouncer
442 - tag: Func
443 value: 'Общая статистика'
444 - uuid: f68d255de9c64005ad3b569e10517178
445 name: 'Общее количество транзакций по всем БД в секунду'
446 type: DEPENDENT
447 key: pgbouncer.total.total_xact_count
448 delay: '0'
449 history: 30d
450 trends: 90d
451 units: tps
452 preprocessing:
453 - type: REGEX
454 parameters:
455 - ' total_xact_count\s+\|(.*)'
456 - \1
457 - type: CHANGE_PER_SECOND
458 parameters:
459 - ''
460 master_item:
461 key: pgbouncer.pool.totals
462 tags:
463 - tag: Application
464 value: PgBouncer
465 - tag: Func
466 value: 'Общая статистика'
467 discovery_rules:
468 - uuid: 415d14383e6a45c4ae876618c9b83adc
469 name: 'PgBouncer pools discovery'
470 key: pgbouncer.pool.discover
471 delay: 30m
472 lifetime: 1h
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}'
796 name: '{#PGBOUNCER_DATABASE}: Среднее время ожидания в очереди более {$PBBOUNCER.WAIT.TIME}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_CLASSIC
996 width: '12'
997 height: '5'
998 fields:
999 - type: GRAPH
1000 name: graphid
1001 value:
1002 host: PgBouncer
1003 name: 'PgBouncer: Подключения'
1004 - type: GRAPH_PROTOTYPE
1005 'y': '5'
1006 width: '12'
1007 height: '5'
1008 fields:
1009 - type: INTEGER
1010 name: columns
1011 value: '1'
1012 - type: GRAPH_PROTOTYPE
1013 name: graphid
1014 value:
1015 host: PgBouncer
1016 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения'
1017 - type: GRAPH_CLASSIC
1018 'y': '10'
1019 width: '12'
1020 height: '5'
1021 fields:
1022 - type: ITEM
1023 name: itemid
1024 value:
1025 host: PgBouncer
1026 key: pgbouncer.total.avg_query_count
1027 - type: INTEGER
1028 name: source_type
1029 value: '1'
1030 - type: GRAPH_CLASSIC
1031 x: '12'
1032 width: '12'
1033 height: '5'
1034 fields:
1035 - type: GRAPH
1036 name: graphid
1037 value:
1038 host: PgBouncer
1039 name: 'PgBouncer: Объём передаваемых данных по всем БД'
1040 - type: GRAPH_PROTOTYPE
1041 x: '12'
1042 'y': '5'
1043 width: '12'
1044 height: '5'
1045 fields:
1046 - type: INTEGER
1047 name: columns
1048 value: '1'
1049 - type: GRAPH_PROTOTYPE
1050 name: graphid
1051 value:
1052 host: PgBouncer
1053 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу'
1054 - type: GRAPH_CLASSIC
1055 x: '12'
1056 'y': '10'
1057 width: '12'
1058 height: '5'
1059 fields:
1060 - type: ITEM
1061 name: itemid
1062 value:
1063 host: PgBouncer
1064 key: pgbouncer.total.avg_query_time
1065 - type: INTEGER
1066 name: source_type
1067 value: '1'
1068 graphs:
1069 - uuid: 8e8efd0772ab4053bb8c79173010d3e6
1070 name: 'PgBouncer: Объём передаваемых данных по всем БД'
1071 graph_items:
1072 - drawtype: FILLED_REGION
1073 color: 00FF00
1074 item:
1075 host: PgBouncer
1076 key: pgbouncer.total.total_client_bytes
1077 - sortorder: '1'
1078 drawtype: FILLED_REGION
1079 color: 0040FF
1080 item:
1081 host: PgBouncer
1082 key: pgbouncer.total.total_server_bytes
1083 - uuid: b433d80b3d69405e809b607e0a2587b0
1084 name: 'PgBouncer: Подключения'
1085 graph_items:
1086 - color: 199C0D
1087 item:
1088 host: PgBouncer
1089 key: pgbouncer.lists.free_clients
1090 - sortorder: '1'
1091 color: F63100
1092 item:
1093 host: PgBouncer
1094 key: pgbouncer.lists.free_servers
1095 - sortorder: '2'
1096 color: 2774A4
1097 item:
1098 host: PgBouncer
1099 key: pgbouncer.lists.login_clients
1100 - sortorder: '3'
1101 color: F7941D
1102 item:
1103 host: PgBouncer
1104 key: pgbouncer.lists.used_clients
1105 - sortorder: '4'
1106 color: FC6EA3
1107 item:
1108 host: PgBouncer
1109 key: pgbouncer.lists.used_servers