ncc.zabbix_templates

Yohn Y. 2023-12-02 Parent:84fd4f8047f7 Child:57989bb46468

12:161891f0a04e Go to Latest

ncc.zabbix_templates/pgBouncer/zbx_export_templates.yaml

. Смена логики слежения за пакетами в шаблонах для FreeBSD и Linux

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