ncc.zabbix_templates

Yohn Y. 2024-07-10 Parent:f04672d92cd6 Child:308f360346c8

30:39b1adf10b0b Go to Latest

ncc.zabbix_templates/pgBouncer/zbx_export_templates.yaml

. Не вводим пользователя в заблужюение именем триггера

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