ncc.zabbix_templates
ncc.zabbix_templates/pgBouncer/zbx_export_templates.yaml
* Ложные срабатывания триггеров при частых изменениях состояния массива + Отдельное наблюдение за состоянием деградации массива.
| 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 |