ncc.zabbix_templates
2023-10-29
Child:979ea476d696
ncc.zabbix_templates/pgBouncer/zbx_export_templates.yaml
+ Шаблон для PgBouncer
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/pgBouncer/zbx_export_templates.yaml Sun Oct 29 16:02:48 2023 +0300 1.3 @@ -0,0 +1,1109 @@ 1.4 +zabbix_export: 1.5 + version: '6.0' 1.6 + date: '2023-10-29T13:01:33Z' 1.7 + groups: 1.8 + - uuid: 22941f4e01294888a9bed3aae15f6ef9 1.9 + name: Templates/AWNET 1.10 + templates: 1.11 + - uuid: b7daeb1192904504a5eedbddf33be7d1 1.12 + template: PgBouncer 1.13 + name: PgBouncer 1.14 + description: | 1.15 + На основе: https://github.com/Lelik13a/Zabbix-PgBouncer 1.16 + Расположение: https://devel.a0fs.ru/ncc.zabbix_templates/pgbouncer/ 1.17 + groups: 1.18 + - name: Templates/AWNET 1.19 + items: 1.20 + - uuid: 43308caa0203485ba54520d1277e3848 1.21 + name: 'Общее количество свободных клиентских подключений' 1.22 + type: DEPENDENT 1.23 + key: pgbouncer.lists.free_clients 1.24 + delay: '0' 1.25 + history: 30d 1.26 + trends: 90d 1.27 + preprocessing: 1.28 + - type: REGEX 1.29 + parameters: 1.30 + - 'free_clients\s+\|(.*)' 1.31 + - \1 1.32 + master_item: 1.33 + key: pgbouncer.pool.lists 1.34 + tags: 1.35 + - tag: Application 1.36 + value: PgBouncer 1.37 + - tag: Func 1.38 + value: 'Общая статистика' 1.39 + - uuid: 4c8072b421d14f589e18c9c33cef3ca6 1.40 + name: 'Общее количество свободных серверных подключений' 1.41 + type: DEPENDENT 1.42 + key: pgbouncer.lists.free_servers 1.43 + delay: '0' 1.44 + history: 30d 1.45 + trends: 90d 1.46 + preprocessing: 1.47 + - type: REGEX 1.48 + parameters: 1.49 + - 'free_servers\s+\|(.*)' 1.50 + - \1 1.51 + master_item: 1.52 + key: pgbouncer.pool.lists 1.53 + tags: 1.54 + - tag: Application 1.55 + value: PgBouncer 1.56 + - tag: Func 1.57 + value: 'Общая статистика' 1.58 + - uuid: d09efd07dff342478e47a77b0cad696e 1.59 + name: 'Общее количество соединений в состоянии авторизации' 1.60 + type: DEPENDENT 1.61 + key: pgbouncer.lists.login_clients 1.62 + delay: '0' 1.63 + history: 30d 1.64 + trends: 90d 1.65 + preprocessing: 1.66 + - type: REGEX 1.67 + parameters: 1.68 + - 'login_clients\s+\|(.*)' 1.69 + - \1 1.70 + master_item: 1.71 + key: pgbouncer.pool.lists 1.72 + tags: 1.73 + - tag: Application 1.74 + value: PgBouncer 1.75 + - tag: Func 1.76 + value: 'Общая статистика' 1.77 + - uuid: 8af7e91ff25a4b3f81482affe6c876ab 1.78 + name: 'Количество пулов подключений' 1.79 + type: DEPENDENT 1.80 + key: pgbouncer.lists.pools 1.81 + delay: '0' 1.82 + history: 30d 1.83 + trends: 90d 1.84 + description: 'Count of pools.' 1.85 + preprocessing: 1.86 + - type: REGEX 1.87 + parameters: 1.88 + - 'pools\s+\|(.*)' 1.89 + - \1 1.90 + master_item: 1.91 + key: pgbouncer.pool.lists 1.92 + tags: 1.93 + - tag: Application 1.94 + value: PgBouncer 1.95 + - tag: Func 1.96 + value: 'Общая статистика' 1.97 + - uuid: 4919263e31d14542aeae03e9dc54cbb2 1.98 + name: 'Общее количество подключённых клиентов' 1.99 + type: DEPENDENT 1.100 + key: pgbouncer.lists.used_clients 1.101 + delay: '0' 1.102 + history: 30d 1.103 + trends: 90d 1.104 + preprocessing: 1.105 + - type: REGEX 1.106 + parameters: 1.107 + - 'used_clients\s+\|(.*)' 1.108 + - \1 1.109 + master_item: 1.110 + key: pgbouncer.pool.lists 1.111 + tags: 1.112 + - tag: Application 1.113 + value: PgBouncer 1.114 + - tag: Func 1.115 + value: 'Общая статистика' 1.116 + - uuid: bf97b099778a485f857d1ea590315885 1.117 + name: 'Общее количество задействованных подключений к серверу' 1.118 + type: DEPENDENT 1.119 + key: pgbouncer.lists.used_servers 1.120 + delay: '0' 1.121 + history: 30d 1.122 + trends: 90d 1.123 + description: 'Count of used servers.' 1.124 + preprocessing: 1.125 + - type: REGEX 1.126 + parameters: 1.127 + - 'used_servers\s+\|(.*)' 1.128 + - \1 1.129 + master_item: 1.130 + key: pgbouncer.pool.lists 1.131 + tags: 1.132 + - tag: Application 1.133 + value: PgBouncer 1.134 + - tag: Func 1.135 + value: 'Общая статистика' 1.136 + - uuid: 70e000f4bf0a4d6e9e5addc99e3b4b3a 1.137 + name: 'Количество пользователй' 1.138 + type: DEPENDENT 1.139 + key: pgbouncer.lists.users 1.140 + delay: '0' 1.141 + history: 30d 1.142 + trends: 90d 1.143 + preprocessing: 1.144 + - type: REGEX 1.145 + parameters: 1.146 + - 'users\s+\|(.*)' 1.147 + - \1 1.148 + master_item: 1.149 + key: pgbouncer.pool.lists 1.150 + tags: 1.151 + - tag: Application 1.152 + value: PgBouncer 1.153 + - tag: Func 1.154 + value: 'Общая статистика' 1.155 + - uuid: 2f7e4233cec54abfb2f54b252a89863f 1.156 + name: 'PgBouncer lists raw' 1.157 + key: pgbouncer.pool.lists 1.158 + history: '0' 1.159 + trends: '0' 1.160 + value_type: TEXT 1.161 + tags: 1.162 + - tag: Application 1.163 + value: PgBouncer 1.164 + - uuid: 82bfee5ff67e4830bab212d0052e9725 1.165 + name: 'PgBouncer pools raw' 1.166 + key: pgbouncer.pool.pools 1.167 + history: '0' 1.168 + trends: '0' 1.169 + value_type: TEXT 1.170 + preprocessing: 1.171 + - type: JAVASCRIPT 1.172 + parameters: 1.173 + - | 1.174 + var res = [] 1.175 + var list_buf = value.split('\n'); 1.176 + var my_trim = function (my_el) { 1.177 + if (my_el != undefined) { 1.178 + return String(my_el).trim() 1.179 + } else { 1.180 + return ''; 1.181 + }; 1.182 + }; 1.183 + 1.184 + for (var le in list_buf) { 1.185 + if (list_buf[le].trim().length == 0) continue; 1.186 + var el_buf = list_buf[le].split('|'); 1.187 + 1.188 + res.push({ 1.189 + database: my_trim(el_buf[0]), 1.190 + user: my_trim(el_buf[1]), 1.191 + cl_active: my_trim(el_buf[2]), 1.192 + cl_waiting: my_trim(el_buf[3]), 1.193 + cl_active_cancel_req: my_trim(el_buf[4]), 1.194 + cl_waiting_cancel_req: my_trim(el_buf[5]), 1.195 + sv_active: my_trim(el_buf[6]), 1.196 + sv_active_cancel: my_trim(el_buf[7]), 1.197 + sv_being_canceled: my_trim(el_buf[8]), 1.198 + sv_idle: my_trim(el_buf[9]), 1.199 + sv_used: my_trim(el_buf[10]), 1.200 + sv_tested: my_trim(el_buf[11]), 1.201 + sv_login: my_trim(el_buf[12]), 1.202 + maxwait: my_trim(el_buf[13]), 1.203 + maxwait_us: my_trim(el_buf[14]), 1.204 + pool_mode: my_trim(el_buf[15]), 1.205 + }); 1.206 + } 1.207 + 1.208 + return JSON.stringify(res); 1.209 + tags: 1.210 + - tag: Application 1.211 + value: PgBouncer 1.212 + - uuid: 5d232829001b4711b9441668e430c0ae 1.213 + name: 'PgBouncer stats raw' 1.214 + key: pgbouncer.pool.stats 1.215 + history: '0' 1.216 + trends: '0' 1.217 + value_type: TEXT 1.218 + preprocessing: 1.219 + - type: JAVASCRIPT 1.220 + parameters: 1.221 + - |2 1.222 + var res = [] 1.223 + var list_buf = value.split('\n'); 1.224 + var my_trim = function (my_el) { 1.225 + if (my_el != undefined) { 1.226 + return String(my_el).trim() 1.227 + } else { 1.228 + return ''; 1.229 + }; 1.230 + }; 1.231 + 1.232 + for (var le in list_buf) { 1.233 + if (list_buf[le].trim().length == 0) continue; 1.234 + var el_buf = list_buf[le].split('|'); 1.235 + 1.236 + res.push({ 1.237 + name: my_trim(el_buf[0]), 1.238 + total_xact_count: my_trim(el_buf[1]), 1.239 + total_query_count: my_trim(el_buf[2]), 1.240 + total_received: my_trim(el_buf[3]), 1.241 + total_sent: my_trim(el_buf[4]), 1.242 + total_xact_time: my_trim(el_buf[5]), 1.243 + total_query_time: my_trim(el_buf[6]), 1.244 + total_wait_time: my_trim(el_buf[7]), 1.245 + avg_xact_count: my_trim(el_buf[8]), 1.246 + avg_query_count: my_trim(el_buf[9]), 1.247 + avg_recv: my_trim(el_buf[10]), 1.248 + avg_sent: my_trim(el_buf[11]), 1.249 + avg_xact_time: my_trim(el_buf[12]), 1.250 + avg_query_time: my_trim(el_buf[13]), 1.251 + avg_wait_time: my_trim(el_buf[14]), 1.252 + }); 1.253 + } 1.254 + 1.255 + return JSON.stringify(res); 1.256 + tags: 1.257 + - tag: Application 1.258 + value: PgBouncer 1.259 + - uuid: 6523b0c631b54900ad00e2b914bbc7ee 1.260 + name: 'PgBouncer totals raw' 1.261 + key: pgbouncer.pool.totals 1.262 + history: '0' 1.263 + trends: '0' 1.264 + value_type: TEXT 1.265 + tags: 1.266 + - tag: Application 1.267 + value: PgBouncer 1.268 + - uuid: c5d602b4909b40c3a3adf30969a4d854 1.269 + name: 'Среднее количество запросов по всем БД' 1.270 + type: DEPENDENT 1.271 + key: pgbouncer.total.avg_query_count 1.272 + delay: '0' 1.273 + history: 30d 1.274 + trends: 90d 1.275 + preprocessing: 1.276 + - type: REGEX 1.277 + parameters: 1.278 + - ' avg_query_count\s+\|(.*)' 1.279 + - \1 1.280 + master_item: 1.281 + key: pgbouncer.pool.totals 1.282 + tags: 1.283 + - tag: Application 1.284 + value: PgBouncer 1.285 + - tag: Func 1.286 + value: 'Общая статистика' 1.287 + - uuid: e0bd310bb159467ab227b01435267dd5 1.288 + name: 'Среднее время запроса по всем БД' 1.289 + type: DEPENDENT 1.290 + key: pgbouncer.total.avg_query_time 1.291 + delay: '0' 1.292 + history: 30d 1.293 + trends: 90d 1.294 + value_type: FLOAT 1.295 + units: ms 1.296 + preprocessing: 1.297 + - type: REGEX 1.298 + parameters: 1.299 + - ' avg_query_time\s+\|(.*)' 1.300 + - \1 1.301 + - type: MULTIPLIER 1.302 + parameters: 1.303 + - '0.001' 1.304 + master_item: 1.305 + key: pgbouncer.pool.totals 1.306 + tags: 1.307 + - tag: Application 1.308 + value: PgBouncer 1.309 + - tag: Func 1.310 + value: 'Общая статистика' 1.311 + - uuid: 69d5830cbb8d49a9a29f8cedd786ca6c 1.312 + name: 'Общее среднее время ожидания клиентом сервера (среднее в секунду)' 1.313 + type: DEPENDENT 1.314 + key: pgbouncer.total.avg_wait_time 1.315 + delay: '0' 1.316 + history: 30d 1.317 + trends: 90d 1.318 + value_type: FLOAT 1.319 + units: ms 1.320 + preprocessing: 1.321 + - type: REGEX 1.322 + parameters: 1.323 + - ' avg_wait_time\s+\|(.*)' 1.324 + - \1 1.325 + - type: MULTIPLIER 1.326 + parameters: 1.327 + - '0.001' 1.328 + master_item: 1.329 + key: pgbouncer.pool.totals 1.330 + tags: 1.331 + - tag: Application 1.332 + value: PgBouncer 1.333 + - tag: Func 1.334 + value: 'Общая статистика' 1.335 + - uuid: 7370e257bd5340f1bab9c3b45720e465 1.336 + name: 'Среднее количество транзакций по всем БД' 1.337 + type: DEPENDENT 1.338 + key: pgbouncer.total.avg_xact_count 1.339 + delay: '0' 1.340 + history: 30d 1.341 + trends: 90d 1.342 + preprocessing: 1.343 + - type: REGEX 1.344 + parameters: 1.345 + - ' avg_xact_count\s+\|(.*)' 1.346 + - \1 1.347 + master_item: 1.348 + key: pgbouncer.pool.totals 1.349 + tags: 1.350 + - tag: Application 1.351 + value: PgBouncer 1.352 + - tag: Func 1.353 + value: 'Общая статистика' 1.354 + - uuid: 20aa4eb901d044e69d10d45576f492c0 1.355 + name: 'Средняя продолжительность транзакции по всем БД' 1.356 + type: DEPENDENT 1.357 + key: pgbouncer.total.avg_xact_time 1.358 + delay: '0' 1.359 + history: 30d 1.360 + trends: 90d 1.361 + value_type: FLOAT 1.362 + units: ms 1.363 + preprocessing: 1.364 + - type: REGEX 1.365 + parameters: 1.366 + - ' avg_xact_time\s+\|(.*)' 1.367 + - \1 1.368 + - type: MULTIPLIER 1.369 + parameters: 1.370 + - '0.001' 1.371 + master_item: 1.372 + key: pgbouncer.pool.totals 1.373 + tags: 1.374 + - tag: Application 1.375 + value: PgBouncer 1.376 + - tag: Func 1.377 + value: 'Общая статистика' 1.378 + - uuid: ac4adb1e65934dab8b13c9bedd88441e 1.379 + name: 'Общее количество полученных от клиентов данных по всем БД' 1.380 + type: DEPENDENT 1.381 + key: pgbouncer.total.total_client_bytes 1.382 + delay: '0' 1.383 + history: 30d 1.384 + trends: 90d 1.385 + units: Bps 1.386 + preprocessing: 1.387 + - type: REGEX 1.388 + parameters: 1.389 + - ' total_client_bytes\s+\|(.*)' 1.390 + - \1 1.391 + - type: CHANGE_PER_SECOND 1.392 + parameters: 1.393 + - '' 1.394 + master_item: 1.395 + key: pgbouncer.pool.totals 1.396 + tags: 1.397 + - tag: Application 1.398 + value: PgBouncer 1.399 + - tag: Func 1.400 + value: 'Общая статистика' 1.401 + - uuid: c120596534a242889f589adddfb25048 1.402 + name: 'Общее количество запросов по всем БД' 1.403 + type: DEPENDENT 1.404 + key: pgbouncer.total.total_query_count 1.405 + delay: '0' 1.406 + history: 30d 1.407 + trends: 90d 1.408 + units: queries/s 1.409 + preprocessing: 1.410 + - type: REGEX 1.411 + parameters: 1.412 + - ' total_query_count\s+\|(.*)' 1.413 + - \1 1.414 + - type: CHANGE_PER_SECOND 1.415 + parameters: 1.416 + - '' 1.417 + master_item: 1.418 + key: pgbouncer.pool.totals 1.419 + tags: 1.420 + - tag: Application 1.421 + value: PgBouncer 1.422 + - tag: Func 1.423 + value: 'Общая статистика' 1.424 + - uuid: 73635a0c208547ddac86c5636429a1ce 1.425 + name: 'Обще количество информации отправленное клиентам по всем БД' 1.426 + type: DEPENDENT 1.427 + key: pgbouncer.total.total_server_bytes 1.428 + delay: '0' 1.429 + history: 30d 1.430 + trends: 90d 1.431 + units: Bps 1.432 + preprocessing: 1.433 + - type: REGEX 1.434 + parameters: 1.435 + - ' total_server_bytes\s+\|(.*)' 1.436 + - \1 1.437 + - type: CHANGE_PER_SECOND 1.438 + parameters: 1.439 + - '' 1.440 + master_item: 1.441 + key: pgbouncer.pool.totals 1.442 + tags: 1.443 + - tag: Application 1.444 + value: PgBouncer 1.445 + - tag: Func 1.446 + value: 'Общая статистика' 1.447 + - uuid: f68d255de9c64005ad3b569e10517178 1.448 + name: 'Общее количество транзакций по всем БД в секунду' 1.449 + type: DEPENDENT 1.450 + key: pgbouncer.total.total_xact_count 1.451 + delay: '0' 1.452 + history: 30d 1.453 + trends: 90d 1.454 + units: transactions/s 1.455 + preprocessing: 1.456 + - type: REGEX 1.457 + parameters: 1.458 + - ' total_xact_count\s+\|(.*)' 1.459 + - \1 1.460 + - type: CHANGE_PER_SECOND 1.461 + parameters: 1.462 + - '' 1.463 + master_item: 1.464 + key: pgbouncer.pool.totals 1.465 + tags: 1.466 + - tag: Application 1.467 + value: PgBouncer 1.468 + - tag: Func 1.469 + value: 'Общая статистика' 1.470 + discovery_rules: 1.471 + - uuid: 415d14383e6a45c4ae876618c9b83adc 1.472 + name: 'PgBouncer pools discovery' 1.473 + key: pgbouncer.pool.discover 1.474 + delay: 30m 1.475 + lifetime: '0' 1.476 + item_prototypes: 1.477 + - uuid: cb931dfeada449bf9749d11b0fc506c7 1.478 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных подключений' 1.479 + type: DEPENDENT 1.480 + key: 'pgbouncer.pools.db.cl_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.481 + delay: '0' 1.482 + history: 30d 1.483 + trends: 90d 1.484 + description: 'Client connections that are linked to server connection and can process queries.' 1.485 + preprocessing: 1.486 + - type: JSONPATH 1.487 + parameters: 1.488 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].cl_active' 1.489 + - type: JSONPATH 1.490 + parameters: 1.491 + - '$[0]' 1.492 + master_item: 1.493 + key: pgbouncer.pool.pools 1.494 + tags: 1.495 + - tag: Application 1.496 + value: PgBouncer 1.497 + - tag: DatabaseName 1.498 + value: '{#PGBOUNCER_DATABASE}' 1.499 + - tag: DatabaseUser 1.500 + value: '{#PGBOUNCER_USER}' 1.501 + - tag: Func 1.502 + value: 'Статистика БД' 1.503 + - uuid: ffa5dd15a6194d3a89b0c4b9b01777dd 1.504 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных подключений в ожидании' 1.505 + type: DEPENDENT 1.506 + key: 'pgbouncer.pools.db.cl_waiting[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.507 + delay: '0' 1.508 + history: 30d 1.509 + trends: 90d 1.510 + preprocessing: 1.511 + - type: JSONPATH 1.512 + parameters: 1.513 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].cl_waiting' 1.514 + - type: JSONPATH 1.515 + parameters: 1.516 + - '$[0]' 1.517 + master_item: 1.518 + key: pgbouncer.pool.pools 1.519 + tags: 1.520 + - tag: Application 1.521 + value: PgBouncer 1.522 + - tag: DatabaseName 1.523 + value: '{#PGBOUNCER_DATABASE}' 1.524 + - tag: DatabaseUser 1.525 + value: '{#PGBOUNCER_USER}' 1.526 + - tag: Func 1.527 + value: 'Статистика БД' 1.528 + - uuid: d40aa8b10f52435e88ac0d7dcb509c38 1.529 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Максимальное ожидание' 1.530 + type: DEPENDENT 1.531 + key: 'pgbouncer.pools.db.maxwait[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.532 + delay: '0' 1.533 + history: 30d 1.534 + trends: 90d 1.535 + units: s 1.536 + description: 'Показывает как долго находится в очереди ожидания подключения к серверу самый старый запрос. Данный параметр начинает расти при не достаточной производительности сервера при обработке запросов. Если наблюдаем данную ситуацию стоит увеличить размер пула подключений к серверу (pool_size)' 1.537 + preprocessing: 1.538 + - type: JSONPATH 1.539 + parameters: 1.540 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].maxwait' 1.541 + - type: JSONPATH 1.542 + parameters: 1.543 + - '$[0]' 1.544 + master_item: 1.545 + key: pgbouncer.pool.pools 1.546 + tags: 1.547 + - tag: Application 1.548 + value: PgBouncer 1.549 + - tag: DatabaseName 1.550 + value: '{#PGBOUNCER_DATABASE}' 1.551 + - tag: DatabaseUser 1.552 + value: '{#PGBOUNCER_USER}' 1.553 + - tag: Func 1.554 + value: 'Статистика БД' 1.555 + trigger_prototypes: 1.556 + - uuid: 46dd8a2b9a0e4346a1041b897775d44c 1.557 + expression: 'last(/PgBouncer/pgbouncer.pools.db.maxwait[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}])>1' 1.558 + name: '{#PGBOUNCER_USER}: Максимальное время ожидания клиентом в очереди превысило 1 секунду' 1.559 + opdata: 'Время ожидания: {ITEM.LASTVALUE1}' 1.560 + priority: AVERAGE 1.561 + - uuid: 0bc401b00ab64e068068c02aa6843210 1.562 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Максимальное ожидание (микросекундная компонента)' 1.563 + type: DEPENDENT 1.564 + key: 'pgbouncer.pools.db.maxwait_us[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.565 + delay: '0' 1.566 + history: 30d 1.567 + trends: 90d 1.568 + value_type: FLOAT 1.569 + units: micros 1.570 + description: 'Смотреть в описание "Максимального ожидания"' 1.571 + preprocessing: 1.572 + - type: JSONPATH 1.573 + parameters: 1.574 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].maxwait_us' 1.575 + - type: JSONPATH 1.576 + parameters: 1.577 + - '$[0]' 1.578 + master_item: 1.579 + key: pgbouncer.pool.pools 1.580 + tags: 1.581 + - tag: Application 1.582 + value: PgBouncer 1.583 + - tag: DatabaseName 1.584 + value: '{#PGBOUNCER_DATABASE}' 1.585 + - tag: DatabaseUser 1.586 + value: '{#PGBOUNCER_USER}' 1.587 + - tag: Func 1.588 + value: 'Статистика БД' 1.589 + trigger_prototypes: 1.590 + - uuid: a4971a735cc04479bbde632a0f03926f 1.591 + expression: 'last(/PgBouncer/pgbouncer.pools.db.maxwait_us[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}])>100' 1.592 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Максимальное время ожидания в очереди на подключение превысило 100 микросекунд' 1.593 + opdata: 'Время ожидания: {ITEM.LASTVALUE1}' 1.594 + priority: INFO 1.595 + - uuid: 7d54c757ce8f4b6eb75b470431aa31f5 1.596 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных серверных подключений' 1.597 + type: DEPENDENT 1.598 + key: 'pgbouncer.pools.db.sv_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.599 + delay: '0' 1.600 + history: 30d 1.601 + trends: 90d 1.602 + preprocessing: 1.603 + - type: JSONPATH 1.604 + parameters: 1.605 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_active' 1.606 + - type: JSONPATH 1.607 + parameters: 1.608 + - '$[0]' 1.609 + master_item: 1.610 + key: pgbouncer.pool.pools 1.611 + tags: 1.612 + - tag: Application 1.613 + value: PgBouncer 1.614 + - tag: DatabaseName 1.615 + value: '{#PGBOUNCER_DATABASE}' 1.616 + - tag: DatabaseUser 1.617 + value: '{#PGBOUNCER_USER}' 1.618 + - tag: Func 1.619 + value: 'Статистика БД' 1.620 + - uuid: 2a95424618784993986b283ed2b473bf 1.621 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Простаивающие подключения' 1.622 + type: DEPENDENT 1.623 + key: 'pgbouncer.pools.db.sv_idle[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.624 + delay: '0' 1.625 + history: 30d 1.626 + trends: 90d 1.627 + description: 'Server connections that are unused and immediately usable for client queries.' 1.628 + preprocessing: 1.629 + - type: JSONPATH 1.630 + parameters: 1.631 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_idle' 1.632 + - type: JSONPATH 1.633 + parameters: 1.634 + - '$[0]' 1.635 + master_item: 1.636 + key: pgbouncer.pool.pools 1.637 + tags: 1.638 + - tag: Application 1.639 + value: PgBouncer 1.640 + - tag: DatabaseName 1.641 + value: '{#PGBOUNCER_DATABASE}' 1.642 + - tag: DatabaseUser 1.643 + value: '{#PGBOUNCER_USER}' 1.644 + - tag: Func 1.645 + value: 'Статистика БД' 1.646 + - uuid: bd06403ea5334b01833798324d22345b 1.647 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных серверных подключений на стадии авторизации' 1.648 + type: DEPENDENT 1.649 + key: 'pgbouncer.pools.db.sv_login[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.650 + delay: '0' 1.651 + history: 30d 1.652 + trends: 90d 1.653 + preprocessing: 1.654 + - type: JSONPATH 1.655 + parameters: 1.656 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_login' 1.657 + - type: JSONPATH 1.658 + parameters: 1.659 + - '$[0]' 1.660 + master_item: 1.661 + key: pgbouncer.pool.pools 1.662 + tags: 1.663 + - tag: Application 1.664 + value: PgBouncer 1.665 + - tag: DatabaseName 1.666 + value: '{#PGBOUNCER_DATABASE}' 1.667 + - tag: DatabaseUser 1.668 + value: '{#PGBOUNCER_USER}' 1.669 + - tag: Func 1.670 + value: 'Статистика БД' 1.671 + - uuid: b7e79133dfca42f49aebb93d5d8749d3 1.672 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу, находящиеся либо в стадии проверки либо сброса и возврата в пул свободных' 1.673 + type: DEPENDENT 1.674 + key: 'pgbouncer.pools.db.sv_tested[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.675 + delay: '0' 1.676 + history: 30d 1.677 + trends: 90d 1.678 + preprocessing: 1.679 + - type: JSONPATH 1.680 + parameters: 1.681 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_tested' 1.682 + - type: JSONPATH 1.683 + parameters: 1.684 + - '$[0]' 1.685 + master_item: 1.686 + key: pgbouncer.pool.pools 1.687 + tags: 1.688 + - tag: Application 1.689 + value: PgBouncer 1.690 + - tag: DatabaseName 1.691 + value: '{#PGBOUNCER_DATABASE}' 1.692 + - tag: DatabaseUser 1.693 + value: '{#PGBOUNCER_USER}' 1.694 + - tag: Func 1.695 + value: 'Статистика БД' 1.696 + - uuid: 9326b8cd476e4d9891153a0c2924c4d7 1.697 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Задействованные подключения к серверу' 1.698 + type: DEPENDENT 1.699 + key: 'pgbouncer.pools.db.sv_used[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.700 + delay: '0' 1.701 + history: 30d 1.702 + trends: 90d 1.703 + preprocessing: 1.704 + - type: JSONPATH 1.705 + parameters: 1.706 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_used' 1.707 + - type: JSONPATH 1.708 + parameters: 1.709 + - '$[0]' 1.710 + master_item: 1.711 + key: pgbouncer.pool.pools 1.712 + tags: 1.713 + - tag: Application 1.714 + value: PgBouncer 1.715 + - tag: DatabaseName 1.716 + value: '{#PGBOUNCER_DATABASE}' 1.717 + - tag: DatabaseUser 1.718 + value: '{#PGBOUNCER_USER}' 1.719 + - tag: Func 1.720 + value: 'Статистика БД' 1.721 + - uuid: 1475ff5de3c54ba792458e063bd92d29 1.722 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Режим управления пулом соединений' 1.723 + type: DEPENDENT 1.724 + key: 'pgbouncer.pools.pool_mode[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.725 + delay: '0' 1.726 + history: 30d 1.727 + trends: '0' 1.728 + value_type: CHAR 1.729 + description: 'The pooling mode in use' 1.730 + preprocessing: 1.731 + - type: JSONPATH 1.732 + parameters: 1.733 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].pool_mode' 1.734 + - type: JSONPATH 1.735 + parameters: 1.736 + - '$[0]' 1.737 + master_item: 1.738 + key: pgbouncer.pool.pools 1.739 + tags: 1.740 + - tag: Application 1.741 + value: PgBouncer 1.742 + - tag: DatabaseName 1.743 + value: '{#PGBOUNCER_DATABASE}' 1.744 + - tag: DatabaseUser 1.745 + value: '{#PGBOUNCER_USER}' 1.746 + - tag: Func 1.747 + value: 'Статистика БД' 1.748 + - uuid: 7de8a33441434eedb9c49a5c6f9d12b8 1.749 + name: '{#PGBOUNCER_DATABASE}: Средняя продолжительность запроса' 1.750 + type: DEPENDENT 1.751 + key: 'pgbouncer.stats.db.avg_query_time[{#PGBOUNCER_DATABASE}]' 1.752 + delay: '0' 1.753 + history: 30d 1.754 + trends: 90d 1.755 + units: ms 1.756 + preprocessing: 1.757 + - type: JSONPATH 1.758 + parameters: 1.759 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_query_time' 1.760 + - type: JSONPATH 1.761 + parameters: 1.762 + - '$[0]' 1.763 + master_item: 1.764 + key: pgbouncer.pool.stats 1.765 + tags: 1.766 + - tag: Application 1.767 + value: PgBouncer 1.768 + - tag: DatabaseName 1.769 + value: '{#PGBOUNCER_DATABASE}' 1.770 + - tag: Func 1.771 + value: 'Статистика БД' 1.772 + - uuid: 4911f76b7b03407b9b39737303714db6 1.773 + name: '{#PGBOUNCER_DATABASE}: Среднее время ожидания свободного подключения' 1.774 + type: DEPENDENT 1.775 + key: 'pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}]' 1.776 + delay: '0' 1.777 + history: 30d 1.778 + trends: 90d 1.779 + units: ms 1.780 + preprocessing: 1.781 + - type: JSONPATH 1.782 + parameters: 1.783 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_wait_time' 1.784 + - type: JSONPATH 1.785 + parameters: 1.786 + - '$[0]' 1.787 + master_item: 1.788 + key: pgbouncer.pool.stats 1.789 + tags: 1.790 + - tag: Application 1.791 + value: PgBouncer 1.792 + - tag: DatabaseName 1.793 + value: '{#PGBOUNCER_DATABASE}' 1.794 + - tag: Func 1.795 + value: 'Статистика БД' 1.796 + trigger_prototypes: 1.797 + - uuid: 8adff22128884a8cb0e30f215776ae00 1.798 + expression: 'last(/PgBouncer/pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}])>{$PBBOUNCER.WAIT.TIME}' 1.799 + name: '{#PGBOUNCER_DATABASE}: Среднее время ожидания в очереди более {$PBBOUNCER.WAIT.TIME}ms' 1.800 + priority: AVERAGE 1.801 + - uuid: 70c41f4bed104f65b47256cb1ccd3ff9 1.802 + name: '{#PGBOUNCER_DATABASE}: Средняя продолжительность транзакции' 1.803 + type: DEPENDENT 1.804 + key: 'pgbouncer.stats.db.avg_xact_time[{#PGBOUNCER_DATABASE}]' 1.805 + delay: '0' 1.806 + history: 30d 1.807 + trends: 90d 1.808 + units: ms 1.809 + preprocessing: 1.810 + - type: JSONPATH 1.811 + parameters: 1.812 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_xact_time' 1.813 + - type: JSONPATH 1.814 + parameters: 1.815 + - '$[0]' 1.816 + master_item: 1.817 + key: pgbouncer.pool.stats 1.818 + tags: 1.819 + - tag: Application 1.820 + value: PgBouncer 1.821 + - tag: DatabaseName 1.822 + value: '{#PGBOUNCER_DATABASE}' 1.823 + - tag: Func 1.824 + value: 'Статистика БД' 1.825 + - uuid: c7784c3d75d0411d920fe6856cf050ea 1.826 + name: '{#PGBOUNCER_DATABASE}: Среднее количество запросов к БД в секунду' 1.827 + type: DEPENDENT 1.828 + key: 'pgbouncer.stats.db.total_query_count[{#PGBOUNCER_DATABASE}]' 1.829 + delay: '0' 1.830 + history: 30d 1.831 + trends: 90d 1.832 + units: queries/s 1.833 + preprocessing: 1.834 + - type: JSONPATH 1.835 + parameters: 1.836 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_query_count' 1.837 + - type: JSONPATH 1.838 + parameters: 1.839 + - '$[0]' 1.840 + - type: CHANGE_PER_SECOND 1.841 + parameters: 1.842 + - '' 1.843 + master_item: 1.844 + key: pgbouncer.pool.stats 1.845 + tags: 1.846 + - tag: Application 1.847 + value: PgBouncer 1.848 + - tag: DatabaseName 1.849 + value: '{#PGBOUNCER_DATABASE}' 1.850 + - tag: Func 1.851 + value: 'Статистика БД' 1.852 + - uuid: d6eb4da92aeb44cea5aefb536b4efae1 1.853 + name: '{#PGBOUNCER_DATABASE}: Средняя скорость получения данных балансировщиком' 1.854 + type: DEPENDENT 1.855 + key: 'pgbouncer.stats.db.total_received[{#PGBOUNCER_DATABASE}]' 1.856 + delay: '0' 1.857 + history: 30d 1.858 + trends: 90d 1.859 + units: b/s 1.860 + preprocessing: 1.861 + - type: JSONPATH 1.862 + parameters: 1.863 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_received' 1.864 + - type: JSONPATH 1.865 + parameters: 1.866 + - '$[0]' 1.867 + - type: CHANGE_PER_SECOND 1.868 + parameters: 1.869 + - '' 1.870 + master_item: 1.871 + key: pgbouncer.pool.stats 1.872 + tags: 1.873 + - tag: Application 1.874 + value: PgBouncer 1.875 + - tag: DatabaseName 1.876 + value: '{#PGBOUNCER_DATABASE}' 1.877 + - tag: Func 1.878 + value: 'Статистика БД' 1.879 + - uuid: 71b50f61435f4df4b97e464952cde5ab 1.880 + name: '{#PGBOUNCER_DATABASE}: Средняя скорость отправки данных балансировщиком' 1.881 + type: DEPENDENT 1.882 + key: 'pgbouncer.stats.db.total_sent[{#PGBOUNCER_DATABASE}]' 1.883 + delay: '0' 1.884 + history: 30d 1.885 + trends: 90d 1.886 + units: b/s 1.887 + description: 'Network traffic sent by pgbouncer in bytes.' 1.888 + preprocessing: 1.889 + - type: JSONPATH 1.890 + parameters: 1.891 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_sent' 1.892 + - type: JSONPATH 1.893 + parameters: 1.894 + - '$[0]' 1.895 + - type: CHANGE_PER_SECOND 1.896 + parameters: 1.897 + - '' 1.898 + master_item: 1.899 + key: pgbouncer.pool.stats 1.900 + tags: 1.901 + - tag: Application 1.902 + value: PgBouncer 1.903 + - tag: DatabaseName 1.904 + value: '{#PGBOUNCER_DATABASE}' 1.905 + - tag: Func 1.906 + value: 'Статистика БД' 1.907 + - uuid: 1dad183897b14125b07ab89a01caa549 1.908 + name: '{#PGBOUNCER_DATABASE}: Среднее количество транзакций в секунду.' 1.909 + type: DEPENDENT 1.910 + key: 'pgbouncer.stats.db.total_xact_count[{#PGBOUNCER_DATABASE}]' 1.911 + delay: '0' 1.912 + history: 30d 1.913 + trends: 90d 1.914 + units: transactions/s 1.915 + preprocessing: 1.916 + - type: JSONPATH 1.917 + parameters: 1.918 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_xact_count' 1.919 + - type: JSONPATH 1.920 + parameters: 1.921 + - '$[0]' 1.922 + - type: CHANGE_PER_SECOND 1.923 + parameters: 1.924 + - '' 1.925 + master_item: 1.926 + key: pgbouncer.pool.stats 1.927 + tags: 1.928 + - tag: Application 1.929 + value: PgBouncer 1.930 + - tag: DatabaseName 1.931 + value: '{#PGBOUNCER_DATABASE}' 1.932 + - tag: Func 1.933 + value: 'Статистика БД' 1.934 + graph_prototypes: 1.935 + - uuid: 25021355bd724712a4b00e6fc62bcaac 1.936 + name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения' 1.937 + graph_items: 1.938 + - color: 199C0D 1.939 + item: 1.940 + host: PgBouncer 1.941 + key: 'pgbouncer.pools.db.cl_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.942 + - sortorder: '1' 1.943 + color: F63100 1.944 + item: 1.945 + host: PgBouncer 1.946 + key: 'pgbouncer.pools.db.cl_waiting[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.947 + - uuid: ca60cfc7d1be4eb5a745e0ae402b7bc4 1.948 + name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу' 1.949 + graph_items: 1.950 + - color: 199C0D 1.951 + item: 1.952 + host: PgBouncer 1.953 + key: 'pgbouncer.pools.db.sv_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.954 + - sortorder: '1' 1.955 + color: F63100 1.956 + item: 1.957 + host: PgBouncer 1.958 + key: 'pgbouncer.pools.db.sv_login[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.959 + - sortorder: '2' 1.960 + color: 2774A4 1.961 + item: 1.962 + host: PgBouncer 1.963 + key: 'pgbouncer.pools.db.sv_tested[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.964 + - sortorder: '3' 1.965 + color: F7941D 1.966 + item: 1.967 + host: PgBouncer 1.968 + key: 'pgbouncer.pools.db.sv_idle[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.969 + - sortorder: '4' 1.970 + color: FC6EA3 1.971 + item: 1.972 + host: PgBouncer 1.973 + key: 'pgbouncer.pools.db.sv_used[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 1.974 + - uuid: 770b8bebd0074052848690582040f3d6 1.975 + name: 'PgBouncer: Сетевой трафик {#PGBOUNCER_DATABASE}' 1.976 + graph_items: 1.977 + - sortorder: '1' 1.978 + drawtype: GRADIENT_LINE 1.979 + color: 199C0D 1.980 + item: 1.981 + host: PgBouncer 1.982 + key: 'pgbouncer.stats.db.total_received[{#PGBOUNCER_DATABASE}]' 1.983 + - sortorder: '2' 1.984 + drawtype: GRADIENT_LINE 1.985 + color: 0040FF 1.986 + item: 1.987 + host: PgBouncer 1.988 + key: 'pgbouncer.stats.db.total_sent[{#PGBOUNCER_DATABASE}]' 1.989 + macros: 1.990 + - macro: '{$PBBOUNCER.WAIT.TIME}' 1.991 + value: '1000' 1.992 + description: 'Time spent by clients waiting for a server, in microseconds (average per second).' 1.993 + dashboards: 1.994 + - uuid: 391b2243c1c54c9cb4e1031f514d96b2 1.995 + name: 'PgBouncer - обзор' 1.996 + pages: 1.997 + - widgets: 1.998 + - type: GRAPH_CLASSIC 1.999 + width: '12' 1.1000 + height: '5' 1.1001 + fields: 1.1002 + - type: GRAPH 1.1003 + name: graphid 1.1004 + value: 1.1005 + host: PgBouncer 1.1006 + name: 'PgBouncer: Подключения' 1.1007 + - type: GRAPH_PROTOTYPE 1.1008 + 'y': '5' 1.1009 + width: '12' 1.1010 + height: '5' 1.1011 + fields: 1.1012 + - type: INTEGER 1.1013 + name: columns 1.1014 + value: '1' 1.1015 + - type: GRAPH_PROTOTYPE 1.1016 + name: graphid 1.1017 + value: 1.1018 + host: PgBouncer 1.1019 + name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения' 1.1020 + - type: GRAPH_CLASSIC 1.1021 + 'y': '10' 1.1022 + width: '12' 1.1023 + height: '5' 1.1024 + fields: 1.1025 + - type: ITEM 1.1026 + name: itemid 1.1027 + value: 1.1028 + host: PgBouncer 1.1029 + key: pgbouncer.total.avg_query_count 1.1030 + - type: INTEGER 1.1031 + name: source_type 1.1032 + value: '1' 1.1033 + - type: GRAPH_CLASSIC 1.1034 + x: '12' 1.1035 + width: '12' 1.1036 + height: '5' 1.1037 + fields: 1.1038 + - type: GRAPH 1.1039 + name: graphid 1.1040 + value: 1.1041 + host: PgBouncer 1.1042 + name: 'PgBouncer: Объём передаваемых данных по всем БД' 1.1043 + - type: GRAPH_PROTOTYPE 1.1044 + x: '12' 1.1045 + 'y': '5' 1.1046 + width: '12' 1.1047 + height: '5' 1.1048 + fields: 1.1049 + - type: INTEGER 1.1050 + name: columns 1.1051 + value: '1' 1.1052 + - type: GRAPH_PROTOTYPE 1.1053 + name: graphid 1.1054 + value: 1.1055 + host: PgBouncer 1.1056 + name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу' 1.1057 + - type: GRAPH_CLASSIC 1.1058 + x: '12' 1.1059 + 'y': '10' 1.1060 + width: '12' 1.1061 + height: '5' 1.1062 + fields: 1.1063 + - type: ITEM 1.1064 + name: itemid 1.1065 + value: 1.1066 + host: PgBouncer 1.1067 + key: pgbouncer.total.avg_query_time 1.1068 + - type: INTEGER 1.1069 + name: source_type 1.1070 + value: '1' 1.1071 + graphs: 1.1072 + - uuid: 8e8efd0772ab4053bb8c79173010d3e6 1.1073 + name: 'PgBouncer: Объём передаваемых данных по всем БД' 1.1074 + graph_items: 1.1075 + - drawtype: FILLED_REGION 1.1076 + color: 00FF00 1.1077 + item: 1.1078 + host: PgBouncer 1.1079 + key: pgbouncer.total.total_client_bytes 1.1080 + - sortorder: '1' 1.1081 + drawtype: FILLED_REGION 1.1082 + color: 0040FF 1.1083 + item: 1.1084 + host: PgBouncer 1.1085 + key: pgbouncer.total.total_server_bytes 1.1086 + - uuid: b433d80b3d69405e809b607e0a2587b0 1.1087 + name: 'PgBouncer: Подключения' 1.1088 + graph_items: 1.1089 + - color: 199C0D 1.1090 + item: 1.1091 + host: PgBouncer 1.1092 + key: pgbouncer.lists.free_clients 1.1093 + - sortorder: '1' 1.1094 + color: F63100 1.1095 + item: 1.1096 + host: PgBouncer 1.1097 + key: pgbouncer.lists.free_servers 1.1098 + - sortorder: '2' 1.1099 + color: 2774A4 1.1100 + item: 1.1101 + host: PgBouncer 1.1102 + key: pgbouncer.lists.login_clients 1.1103 + - sortorder: '3' 1.1104 + color: F7941D 1.1105 + item: 1.1106 + host: PgBouncer 1.1107 + key: pgbouncer.lists.used_clients 1.1108 + - sortorder: '4' 1.1109 + color: FC6EA3 1.1110 + item: 1.1111 + host: PgBouncer 1.1112 + key: pgbouncer.lists.used_servers