ncc.zabbix_templates

Yohn Y. 2025-05-15 Parent:308f360346c8

36:bc85d53acc6e Go to Latest

ncc.zabbix_templates/pgBouncer/zbx_export_templates.yaml

. PGBouncer: Изменение работы со статистикой времени

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