ncc.zabbix_templates
7:ca9cdec2f51e Browse Files
+ Шаблон для PgBouncer
pgBouncer/REDME.md pgBouncer/install.sh pgBouncer/res/pgbouncer.conf pgBouncer/res/pgbouncer.sh pgBouncer/zbx_export_templates.yaml
1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 1.2 +++ b/pgBouncer/REDME.md Sun Oct 29 16:02:48 2023 +0300 1.3 @@ -0,0 +1,24 @@ 1.4 +Общая информация 1.5 +================ 1.6 + 1.7 +**Выполнено на основе:** https://github.com/Lelik13a/Zabbix-PgBouncer 1.8 + 1.9 +Для `FreeBSD` требует доработки в части путей в скрипте установки и расположения 1.10 +вспомогательного скрипта в определении пользовательских параметров в самом `Zabbix` 1.11 + 1.12 + 1.13 +Состав 1.14 +====== 1.15 + 1.16 +* `install.sh` - скрипт установки ресурсов шаблона на узел с балансировщиком 1.17 +* `res/pgbouncer.conf` - конфигурация агента `Zabbix` 1.18 +* `res/pgbouncer.sh` - Вспомогательный скрипт для агента, являющийся обёрткой над функционалом статистики 1.19 + pgbouncer 1.20 + 1.21 + 1.22 +Требования к среде исполнения 1.23 +============================= 1.24 + 1.25 +В СУБД должен быть зарегистрирована УЗ пользователя мониторинга, через которую `Zabbix` и будет осуществлять 1.26 +сбор метрик. Эта УЗ должна быть указана в параметре `stats_users` в конфигурации `pgbouncer` 1.27 +
2.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 2.2 +++ b/pgBouncer/install.sh Sun Oct 29 16:02:48 2023 +0300 2.3 @@ -0,0 +1,38 @@ 2.4 +#!/bin/bash 2.5 +# devel.a0fs.ru -- ncc.zabbix_templates/pgbouncer/install.sh -- v0.r202310.1 # 2.6 + 2.7 +export PATH="/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin" 2.8 +appdir="$(dirname "$(readlink -f "$0")")" 2.9 + 2.10 +install -d -o zabbix -g zabbix -m u=rwx,g=rx,o-rwx \ 2.11 + /etc/zabbix/scripts/ \ 2.12 + /etc/zabbix/scripts-data \ 2.13 + /etc/zabbix/scripts-data/pgbouncer 2.14 + 2.15 +echo "PGBOUNCER PORT" 2.16 +read -p "Port: " pgb_port 2.17 + 2.18 +echo "MONITRONG USER CREDENTIALS" 2.19 +read -p "User: " uid_name 2.20 +read -p "Passwd: " -r -s uid_passwd 2.21 + 2.22 +cat > /etc/zabbix/scripts-data/pgbouncer/.pgpass << EOF 2.23 +127.0.0.1:${pgb_port:-6432}:*:${uid_name:-zbx_mon}:${uid_passwd} 2.24 +EOF 2.25 + 2.26 +chown zabbix:zabbix /etc/zabbix/scripts-data/pgbouncer/.pgpass 2.27 +chmod go-rwx /etc/zabbix/scripts-data/pgbouncer/.pgpass 2.28 + 2.29 +install -o zabbix -g zabbix ${appdir}/res/pgbouncer.sh ${PREFIX}etc/zabbix/scripts/ 2.30 + 2.31 +for fle in /etc/zabbix/zabbix_agentd.d/ /etc/zabbix/zabbix_agentd2.d/ \ 2.32 + /etc/zabbix/zabbix_agent.d/ /etc/zabbix/zabbix_agent2.d/ ; do 2.33 + 2.34 + if ! [ -d "$fle" ] ; then 2.35 + continue 2.36 + 2.37 + fi; 2.38 + 2.39 + install -o zabbix -g zabbix -m u=rw,go=r ${appdir}/res/pgbouncer.conf ${fle} 2.40 + 2.41 +done
3.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 3.2 +++ b/pgBouncer/res/pgbouncer.conf Sun Oct 29 16:02:48 2023 +0300 3.3 @@ -0,0 +1,7 @@ 3.4 +Timeout=30 3.5 + 3.6 +UserParameter=pgbouncer.pool.discover,/bin/bash /etc/zabbix/scripts/pgbouncer.sh discover 3.7 +UserParameter=pgbouncer.pool.totals,/bin/bash /etc/zabbix/scripts/pgbouncer.sh totals 3.8 +UserParameter=pgbouncer.pool.stats,/bin/bash /etc/zabbix/scripts/pgbouncer.sh stats 3.9 +UserParameter=pgbouncer.pool.lists,/bin/bash /etc/zabbix/scripts/pgbouncer.sh lists 3.10 +UserParameter=pgbouncer.pool.pools,/bin/bash /etc/zabbix/scripts/pgbouncer.sh pools 3.11 \ No newline at end of file
4.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 4.2 +++ b/pgBouncer/res/pgbouncer.sh Sun Oct 29 16:02:48 2023 +0300 4.3 @@ -0,0 +1,46 @@ 4.4 +#!/bin/sh 4.5 +# devel.a0fs.ru -- ncc.zabbix_templates/pgbouncer/res/pgbouncer.sh -- v0.r202310.1 # 4.6 + 4.7 +export HOME=/etc/zabbix/scripts-data/pgbouncer 4.8 + 4.9 +PGBOUNCER_HOST=$(head -n 1 /etc/zabbix/scripts-data/pgbouncer/.pgpass |cut -d: -f1) 4.10 +PGBOUNCER_PORT=$(head -n 1 /etc/zabbix/scripts-data/pgbouncer/.pgpass |cut -d: -f2) 4.11 +MON_USER=$(head -n 1 /etc/zabbix/scripts-data/pgbouncer/.pgpass |cut -d: -f4) 4.12 + 4.13 +COMMAND=$1 4.14 +#USER=$3 4.15 +#DB=$2 4.16 + 4.17 +if [ "x$COMMAND" = "xdiscover" ] 4.18 +then 4.19 + # discovery bases and users 4.20 + psql -h $PGBOUNCER_HOST -p $PGBOUNCER_PORT -U $MON_USER pgbouncer -t -c 'show pools;' \ 4.21 + | awk -F'|' 'BEGIN { printf "{\"data\":["; n=0; } 4.22 + /\|/ { if (n != 0) 4.23 + printf ","; 4.24 + gsub(" ", "", $1); 4.25 + gsub(" ", "", $2); 4.26 + printf "{\"{#PGBOUNCER_DATABASE}\": \"" $1 "\", \"{#PGBOUNCER_USER}\": \"" $2 "\"}"; 4.27 + n++; } 4.28 + END { printf "]}"; }' 4.29 +elif [ "x$COMMAND" = "xtotals" ] 4.30 +then 4.31 + # get total statistic 4.32 + psql -h $PGBOUNCER_HOST -p $PGBOUNCER_PORT -U $MON_USER pgbouncer -t -c 'show totals;' 4.33 + 4.34 +elif [ "x$COMMAND" = "xstats" ] 4.35 +then 4.36 + # get statistic per db 4.37 + psql -h $PGBOUNCER_HOST -p $PGBOUNCER_PORT -U $MON_USER pgbouncer -t -c 'show stats;' 4.38 + 4.39 +elif [ "x$COMMAND" = "xlists" ] 4.40 +then 4.41 + # get internal information 4.42 + psql -h $PGBOUNCER_HOST -p $PGBOUNCER_PORT -U $MON_USER pgbouncer -t -c 'show lists;' 4.43 + 4.44 +elif [ "x$COMMAND" = "xpools" ] 4.45 +then 4.46 + # get pools statistic 4.47 + psql -h $PGBOUNCER_HOST -p $PGBOUNCER_PORT -U $MON_USER pgbouncer -t -c 'show pools;' 4.48 + 4.49 +fi 4.50 \ No newline at end of file
5.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000 5.2 +++ b/pgBouncer/zbx_export_templates.yaml Sun Oct 29 16:02:48 2023 +0300 5.3 @@ -0,0 +1,1109 @@ 5.4 +zabbix_export: 5.5 + version: '6.0' 5.6 + date: '2023-10-29T13:01:33Z' 5.7 + groups: 5.8 + - uuid: 22941f4e01294888a9bed3aae15f6ef9 5.9 + name: Templates/AWNET 5.10 + templates: 5.11 + - uuid: b7daeb1192904504a5eedbddf33be7d1 5.12 + template: PgBouncer 5.13 + name: PgBouncer 5.14 + description: | 5.15 + На основе: https://github.com/Lelik13a/Zabbix-PgBouncer 5.16 + Расположение: https://devel.a0fs.ru/ncc.zabbix_templates/pgbouncer/ 5.17 + groups: 5.18 + - name: Templates/AWNET 5.19 + items: 5.20 + - uuid: 43308caa0203485ba54520d1277e3848 5.21 + name: 'Общее количество свободных клиентских подключений' 5.22 + type: DEPENDENT 5.23 + key: pgbouncer.lists.free_clients 5.24 + delay: '0' 5.25 + history: 30d 5.26 + trends: 90d 5.27 + preprocessing: 5.28 + - type: REGEX 5.29 + parameters: 5.30 + - 'free_clients\s+\|(.*)' 5.31 + - \1 5.32 + master_item: 5.33 + key: pgbouncer.pool.lists 5.34 + tags: 5.35 + - tag: Application 5.36 + value: PgBouncer 5.37 + - tag: Func 5.38 + value: 'Общая статистика' 5.39 + - uuid: 4c8072b421d14f589e18c9c33cef3ca6 5.40 + name: 'Общее количество свободных серверных подключений' 5.41 + type: DEPENDENT 5.42 + key: pgbouncer.lists.free_servers 5.43 + delay: '0' 5.44 + history: 30d 5.45 + trends: 90d 5.46 + preprocessing: 5.47 + - type: REGEX 5.48 + parameters: 5.49 + - 'free_servers\s+\|(.*)' 5.50 + - \1 5.51 + master_item: 5.52 + key: pgbouncer.pool.lists 5.53 + tags: 5.54 + - tag: Application 5.55 + value: PgBouncer 5.56 + - tag: Func 5.57 + value: 'Общая статистика' 5.58 + - uuid: d09efd07dff342478e47a77b0cad696e 5.59 + name: 'Общее количество соединений в состоянии авторизации' 5.60 + type: DEPENDENT 5.61 + key: pgbouncer.lists.login_clients 5.62 + delay: '0' 5.63 + history: 30d 5.64 + trends: 90d 5.65 + preprocessing: 5.66 + - type: REGEX 5.67 + parameters: 5.68 + - 'login_clients\s+\|(.*)' 5.69 + - \1 5.70 + master_item: 5.71 + key: pgbouncer.pool.lists 5.72 + tags: 5.73 + - tag: Application 5.74 + value: PgBouncer 5.75 + - tag: Func 5.76 + value: 'Общая статистика' 5.77 + - uuid: 8af7e91ff25a4b3f81482affe6c876ab 5.78 + name: 'Количество пулов подключений' 5.79 + type: DEPENDENT 5.80 + key: pgbouncer.lists.pools 5.81 + delay: '0' 5.82 + history: 30d 5.83 + trends: 90d 5.84 + description: 'Count of pools.' 5.85 + preprocessing: 5.86 + - type: REGEX 5.87 + parameters: 5.88 + - 'pools\s+\|(.*)' 5.89 + - \1 5.90 + master_item: 5.91 + key: pgbouncer.pool.lists 5.92 + tags: 5.93 + - tag: Application 5.94 + value: PgBouncer 5.95 + - tag: Func 5.96 + value: 'Общая статистика' 5.97 + - uuid: 4919263e31d14542aeae03e9dc54cbb2 5.98 + name: 'Общее количество подключённых клиентов' 5.99 + type: DEPENDENT 5.100 + key: pgbouncer.lists.used_clients 5.101 + delay: '0' 5.102 + history: 30d 5.103 + trends: 90d 5.104 + preprocessing: 5.105 + - type: REGEX 5.106 + parameters: 5.107 + - 'used_clients\s+\|(.*)' 5.108 + - \1 5.109 + master_item: 5.110 + key: pgbouncer.pool.lists 5.111 + tags: 5.112 + - tag: Application 5.113 + value: PgBouncer 5.114 + - tag: Func 5.115 + value: 'Общая статистика' 5.116 + - uuid: bf97b099778a485f857d1ea590315885 5.117 + name: 'Общее количество задействованных подключений к серверу' 5.118 + type: DEPENDENT 5.119 + key: pgbouncer.lists.used_servers 5.120 + delay: '0' 5.121 + history: 30d 5.122 + trends: 90d 5.123 + description: 'Count of used servers.' 5.124 + preprocessing: 5.125 + - type: REGEX 5.126 + parameters: 5.127 + - 'used_servers\s+\|(.*)' 5.128 + - \1 5.129 + master_item: 5.130 + key: pgbouncer.pool.lists 5.131 + tags: 5.132 + - tag: Application 5.133 + value: PgBouncer 5.134 + - tag: Func 5.135 + value: 'Общая статистика' 5.136 + - uuid: 70e000f4bf0a4d6e9e5addc99e3b4b3a 5.137 + name: 'Количество пользователй' 5.138 + type: DEPENDENT 5.139 + key: pgbouncer.lists.users 5.140 + delay: '0' 5.141 + history: 30d 5.142 + trends: 90d 5.143 + preprocessing: 5.144 + - type: REGEX 5.145 + parameters: 5.146 + - 'users\s+\|(.*)' 5.147 + - \1 5.148 + master_item: 5.149 + key: pgbouncer.pool.lists 5.150 + tags: 5.151 + - tag: Application 5.152 + value: PgBouncer 5.153 + - tag: Func 5.154 + value: 'Общая статистика' 5.155 + - uuid: 2f7e4233cec54abfb2f54b252a89863f 5.156 + name: 'PgBouncer lists raw' 5.157 + key: pgbouncer.pool.lists 5.158 + history: '0' 5.159 + trends: '0' 5.160 + value_type: TEXT 5.161 + tags: 5.162 + - tag: Application 5.163 + value: PgBouncer 5.164 + - uuid: 82bfee5ff67e4830bab212d0052e9725 5.165 + name: 'PgBouncer pools raw' 5.166 + key: pgbouncer.pool.pools 5.167 + history: '0' 5.168 + trends: '0' 5.169 + value_type: TEXT 5.170 + preprocessing: 5.171 + - type: JAVASCRIPT 5.172 + parameters: 5.173 + - | 5.174 + var res = [] 5.175 + var list_buf = value.split('\n'); 5.176 + var my_trim = function (my_el) { 5.177 + if (my_el != undefined) { 5.178 + return String(my_el).trim() 5.179 + } else { 5.180 + return ''; 5.181 + }; 5.182 + }; 5.183 + 5.184 + for (var le in list_buf) { 5.185 + if (list_buf[le].trim().length == 0) continue; 5.186 + var el_buf = list_buf[le].split('|'); 5.187 + 5.188 + res.push({ 5.189 + database: my_trim(el_buf[0]), 5.190 + user: my_trim(el_buf[1]), 5.191 + cl_active: my_trim(el_buf[2]), 5.192 + cl_waiting: my_trim(el_buf[3]), 5.193 + cl_active_cancel_req: my_trim(el_buf[4]), 5.194 + cl_waiting_cancel_req: my_trim(el_buf[5]), 5.195 + sv_active: my_trim(el_buf[6]), 5.196 + sv_active_cancel: my_trim(el_buf[7]), 5.197 + sv_being_canceled: my_trim(el_buf[8]), 5.198 + sv_idle: my_trim(el_buf[9]), 5.199 + sv_used: my_trim(el_buf[10]), 5.200 + sv_tested: my_trim(el_buf[11]), 5.201 + sv_login: my_trim(el_buf[12]), 5.202 + maxwait: my_trim(el_buf[13]), 5.203 + maxwait_us: my_trim(el_buf[14]), 5.204 + pool_mode: my_trim(el_buf[15]), 5.205 + }); 5.206 + } 5.207 + 5.208 + return JSON.stringify(res); 5.209 + tags: 5.210 + - tag: Application 5.211 + value: PgBouncer 5.212 + - uuid: 5d232829001b4711b9441668e430c0ae 5.213 + name: 'PgBouncer stats raw' 5.214 + key: pgbouncer.pool.stats 5.215 + history: '0' 5.216 + trends: '0' 5.217 + value_type: TEXT 5.218 + preprocessing: 5.219 + - type: JAVASCRIPT 5.220 + parameters: 5.221 + - |2 5.222 + var res = [] 5.223 + var list_buf = value.split('\n'); 5.224 + var my_trim = function (my_el) { 5.225 + if (my_el != undefined) { 5.226 + return String(my_el).trim() 5.227 + } else { 5.228 + return ''; 5.229 + }; 5.230 + }; 5.231 + 5.232 + for (var le in list_buf) { 5.233 + if (list_buf[le].trim().length == 0) continue; 5.234 + var el_buf = list_buf[le].split('|'); 5.235 + 5.236 + res.push({ 5.237 + name: my_trim(el_buf[0]), 5.238 + total_xact_count: my_trim(el_buf[1]), 5.239 + total_query_count: my_trim(el_buf[2]), 5.240 + total_received: my_trim(el_buf[3]), 5.241 + total_sent: my_trim(el_buf[4]), 5.242 + total_xact_time: my_trim(el_buf[5]), 5.243 + total_query_time: my_trim(el_buf[6]), 5.244 + total_wait_time: my_trim(el_buf[7]), 5.245 + avg_xact_count: my_trim(el_buf[8]), 5.246 + avg_query_count: my_trim(el_buf[9]), 5.247 + avg_recv: my_trim(el_buf[10]), 5.248 + avg_sent: my_trim(el_buf[11]), 5.249 + avg_xact_time: my_trim(el_buf[12]), 5.250 + avg_query_time: my_trim(el_buf[13]), 5.251 + avg_wait_time: my_trim(el_buf[14]), 5.252 + }); 5.253 + } 5.254 + 5.255 + return JSON.stringify(res); 5.256 + tags: 5.257 + - tag: Application 5.258 + value: PgBouncer 5.259 + - uuid: 6523b0c631b54900ad00e2b914bbc7ee 5.260 + name: 'PgBouncer totals raw' 5.261 + key: pgbouncer.pool.totals 5.262 + history: '0' 5.263 + trends: '0' 5.264 + value_type: TEXT 5.265 + tags: 5.266 + - tag: Application 5.267 + value: PgBouncer 5.268 + - uuid: c5d602b4909b40c3a3adf30969a4d854 5.269 + name: 'Среднее количество запросов по всем БД' 5.270 + type: DEPENDENT 5.271 + key: pgbouncer.total.avg_query_count 5.272 + delay: '0' 5.273 + history: 30d 5.274 + trends: 90d 5.275 + preprocessing: 5.276 + - type: REGEX 5.277 + parameters: 5.278 + - ' avg_query_count\s+\|(.*)' 5.279 + - \1 5.280 + master_item: 5.281 + key: pgbouncer.pool.totals 5.282 + tags: 5.283 + - tag: Application 5.284 + value: PgBouncer 5.285 + - tag: Func 5.286 + value: 'Общая статистика' 5.287 + - uuid: e0bd310bb159467ab227b01435267dd5 5.288 + name: 'Среднее время запроса по всем БД' 5.289 + type: DEPENDENT 5.290 + key: pgbouncer.total.avg_query_time 5.291 + delay: '0' 5.292 + history: 30d 5.293 + trends: 90d 5.294 + value_type: FLOAT 5.295 + units: ms 5.296 + preprocessing: 5.297 + - type: REGEX 5.298 + parameters: 5.299 + - ' avg_query_time\s+\|(.*)' 5.300 + - \1 5.301 + - type: MULTIPLIER 5.302 + parameters: 5.303 + - '0.001' 5.304 + master_item: 5.305 + key: pgbouncer.pool.totals 5.306 + tags: 5.307 + - tag: Application 5.308 + value: PgBouncer 5.309 + - tag: Func 5.310 + value: 'Общая статистика' 5.311 + - uuid: 69d5830cbb8d49a9a29f8cedd786ca6c 5.312 + name: 'Общее среднее время ожидания клиентом сервера (среднее в секунду)' 5.313 + type: DEPENDENT 5.314 + key: pgbouncer.total.avg_wait_time 5.315 + delay: '0' 5.316 + history: 30d 5.317 + trends: 90d 5.318 + value_type: FLOAT 5.319 + units: ms 5.320 + preprocessing: 5.321 + - type: REGEX 5.322 + parameters: 5.323 + - ' avg_wait_time\s+\|(.*)' 5.324 + - \1 5.325 + - type: MULTIPLIER 5.326 + parameters: 5.327 + - '0.001' 5.328 + master_item: 5.329 + key: pgbouncer.pool.totals 5.330 + tags: 5.331 + - tag: Application 5.332 + value: PgBouncer 5.333 + - tag: Func 5.334 + value: 'Общая статистика' 5.335 + - uuid: 7370e257bd5340f1bab9c3b45720e465 5.336 + name: 'Среднее количество транзакций по всем БД' 5.337 + type: DEPENDENT 5.338 + key: pgbouncer.total.avg_xact_count 5.339 + delay: '0' 5.340 + history: 30d 5.341 + trends: 90d 5.342 + preprocessing: 5.343 + - type: REGEX 5.344 + parameters: 5.345 + - ' avg_xact_count\s+\|(.*)' 5.346 + - \1 5.347 + master_item: 5.348 + key: pgbouncer.pool.totals 5.349 + tags: 5.350 + - tag: Application 5.351 + value: PgBouncer 5.352 + - tag: Func 5.353 + value: 'Общая статистика' 5.354 + - uuid: 20aa4eb901d044e69d10d45576f492c0 5.355 + name: 'Средняя продолжительность транзакции по всем БД' 5.356 + type: DEPENDENT 5.357 + key: pgbouncer.total.avg_xact_time 5.358 + delay: '0' 5.359 + history: 30d 5.360 + trends: 90d 5.361 + value_type: FLOAT 5.362 + units: ms 5.363 + preprocessing: 5.364 + - type: REGEX 5.365 + parameters: 5.366 + - ' avg_xact_time\s+\|(.*)' 5.367 + - \1 5.368 + - type: MULTIPLIER 5.369 + parameters: 5.370 + - '0.001' 5.371 + master_item: 5.372 + key: pgbouncer.pool.totals 5.373 + tags: 5.374 + - tag: Application 5.375 + value: PgBouncer 5.376 + - tag: Func 5.377 + value: 'Общая статистика' 5.378 + - uuid: ac4adb1e65934dab8b13c9bedd88441e 5.379 + name: 'Общее количество полученных от клиентов данных по всем БД' 5.380 + type: DEPENDENT 5.381 + key: pgbouncer.total.total_client_bytes 5.382 + delay: '0' 5.383 + history: 30d 5.384 + trends: 90d 5.385 + units: Bps 5.386 + preprocessing: 5.387 + - type: REGEX 5.388 + parameters: 5.389 + - ' total_client_bytes\s+\|(.*)' 5.390 + - \1 5.391 + - type: CHANGE_PER_SECOND 5.392 + parameters: 5.393 + - '' 5.394 + master_item: 5.395 + key: pgbouncer.pool.totals 5.396 + tags: 5.397 + - tag: Application 5.398 + value: PgBouncer 5.399 + - tag: Func 5.400 + value: 'Общая статистика' 5.401 + - uuid: c120596534a242889f589adddfb25048 5.402 + name: 'Общее количество запросов по всем БД' 5.403 + type: DEPENDENT 5.404 + key: pgbouncer.total.total_query_count 5.405 + delay: '0' 5.406 + history: 30d 5.407 + trends: 90d 5.408 + units: queries/s 5.409 + preprocessing: 5.410 + - type: REGEX 5.411 + parameters: 5.412 + - ' total_query_count\s+\|(.*)' 5.413 + - \1 5.414 + - type: CHANGE_PER_SECOND 5.415 + parameters: 5.416 + - '' 5.417 + master_item: 5.418 + key: pgbouncer.pool.totals 5.419 + tags: 5.420 + - tag: Application 5.421 + value: PgBouncer 5.422 + - tag: Func 5.423 + value: 'Общая статистика' 5.424 + - uuid: 73635a0c208547ddac86c5636429a1ce 5.425 + name: 'Обще количество информации отправленное клиентам по всем БД' 5.426 + type: DEPENDENT 5.427 + key: pgbouncer.total.total_server_bytes 5.428 + delay: '0' 5.429 + history: 30d 5.430 + trends: 90d 5.431 + units: Bps 5.432 + preprocessing: 5.433 + - type: REGEX 5.434 + parameters: 5.435 + - ' total_server_bytes\s+\|(.*)' 5.436 + - \1 5.437 + - type: CHANGE_PER_SECOND 5.438 + parameters: 5.439 + - '' 5.440 + master_item: 5.441 + key: pgbouncer.pool.totals 5.442 + tags: 5.443 + - tag: Application 5.444 + value: PgBouncer 5.445 + - tag: Func 5.446 + value: 'Общая статистика' 5.447 + - uuid: f68d255de9c64005ad3b569e10517178 5.448 + name: 'Общее количество транзакций по всем БД в секунду' 5.449 + type: DEPENDENT 5.450 + key: pgbouncer.total.total_xact_count 5.451 + delay: '0' 5.452 + history: 30d 5.453 + trends: 90d 5.454 + units: transactions/s 5.455 + preprocessing: 5.456 + - type: REGEX 5.457 + parameters: 5.458 + - ' total_xact_count\s+\|(.*)' 5.459 + - \1 5.460 + - type: CHANGE_PER_SECOND 5.461 + parameters: 5.462 + - '' 5.463 + master_item: 5.464 + key: pgbouncer.pool.totals 5.465 + tags: 5.466 + - tag: Application 5.467 + value: PgBouncer 5.468 + - tag: Func 5.469 + value: 'Общая статистика' 5.470 + discovery_rules: 5.471 + - uuid: 415d14383e6a45c4ae876618c9b83adc 5.472 + name: 'PgBouncer pools discovery' 5.473 + key: pgbouncer.pool.discover 5.474 + delay: 30m 5.475 + lifetime: '0' 5.476 + item_prototypes: 5.477 + - uuid: cb931dfeada449bf9749d11b0fc506c7 5.478 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных подключений' 5.479 + type: DEPENDENT 5.480 + key: 'pgbouncer.pools.db.cl_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.481 + delay: '0' 5.482 + history: 30d 5.483 + trends: 90d 5.484 + description: 'Client connections that are linked to server connection and can process queries.' 5.485 + preprocessing: 5.486 + - type: JSONPATH 5.487 + parameters: 5.488 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].cl_active' 5.489 + - type: JSONPATH 5.490 + parameters: 5.491 + - '$[0]' 5.492 + master_item: 5.493 + key: pgbouncer.pool.pools 5.494 + tags: 5.495 + - tag: Application 5.496 + value: PgBouncer 5.497 + - tag: DatabaseName 5.498 + value: '{#PGBOUNCER_DATABASE}' 5.499 + - tag: DatabaseUser 5.500 + value: '{#PGBOUNCER_USER}' 5.501 + - tag: Func 5.502 + value: 'Статистика БД' 5.503 + - uuid: ffa5dd15a6194d3a89b0c4b9b01777dd 5.504 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных подключений в ожидании' 5.505 + type: DEPENDENT 5.506 + key: 'pgbouncer.pools.db.cl_waiting[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.507 + delay: '0' 5.508 + history: 30d 5.509 + trends: 90d 5.510 + preprocessing: 5.511 + - type: JSONPATH 5.512 + parameters: 5.513 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].cl_waiting' 5.514 + - type: JSONPATH 5.515 + parameters: 5.516 + - '$[0]' 5.517 + master_item: 5.518 + key: pgbouncer.pool.pools 5.519 + tags: 5.520 + - tag: Application 5.521 + value: PgBouncer 5.522 + - tag: DatabaseName 5.523 + value: '{#PGBOUNCER_DATABASE}' 5.524 + - tag: DatabaseUser 5.525 + value: '{#PGBOUNCER_USER}' 5.526 + - tag: Func 5.527 + value: 'Статистика БД' 5.528 + - uuid: d40aa8b10f52435e88ac0d7dcb509c38 5.529 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Максимальное ожидание' 5.530 + type: DEPENDENT 5.531 + key: 'pgbouncer.pools.db.maxwait[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.532 + delay: '0' 5.533 + history: 30d 5.534 + trends: 90d 5.535 + units: s 5.536 + description: 'Показывает как долго находится в очереди ожидания подключения к серверу самый старый запрос. Данный параметр начинает расти при не достаточной производительности сервера при обработке запросов. Если наблюдаем данную ситуацию стоит увеличить размер пула подключений к серверу (pool_size)' 5.537 + preprocessing: 5.538 + - type: JSONPATH 5.539 + parameters: 5.540 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].maxwait' 5.541 + - type: JSONPATH 5.542 + parameters: 5.543 + - '$[0]' 5.544 + master_item: 5.545 + key: pgbouncer.pool.pools 5.546 + tags: 5.547 + - tag: Application 5.548 + value: PgBouncer 5.549 + - tag: DatabaseName 5.550 + value: '{#PGBOUNCER_DATABASE}' 5.551 + - tag: DatabaseUser 5.552 + value: '{#PGBOUNCER_USER}' 5.553 + - tag: Func 5.554 + value: 'Статистика БД' 5.555 + trigger_prototypes: 5.556 + - uuid: 46dd8a2b9a0e4346a1041b897775d44c 5.557 + expression: 'last(/PgBouncer/pgbouncer.pools.db.maxwait[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}])>1' 5.558 + name: '{#PGBOUNCER_USER}: Максимальное время ожидания клиентом в очереди превысило 1 секунду' 5.559 + opdata: 'Время ожидания: {ITEM.LASTVALUE1}' 5.560 + priority: AVERAGE 5.561 + - uuid: 0bc401b00ab64e068068c02aa6843210 5.562 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Максимальное ожидание (микросекундная компонента)' 5.563 + type: DEPENDENT 5.564 + key: 'pgbouncer.pools.db.maxwait_us[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.565 + delay: '0' 5.566 + history: 30d 5.567 + trends: 90d 5.568 + value_type: FLOAT 5.569 + units: micros 5.570 + description: 'Смотреть в описание "Максимального ожидания"' 5.571 + preprocessing: 5.572 + - type: JSONPATH 5.573 + parameters: 5.574 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].maxwait_us' 5.575 + - type: JSONPATH 5.576 + parameters: 5.577 + - '$[0]' 5.578 + master_item: 5.579 + key: pgbouncer.pool.pools 5.580 + tags: 5.581 + - tag: Application 5.582 + value: PgBouncer 5.583 + - tag: DatabaseName 5.584 + value: '{#PGBOUNCER_DATABASE}' 5.585 + - tag: DatabaseUser 5.586 + value: '{#PGBOUNCER_USER}' 5.587 + - tag: Func 5.588 + value: 'Статистика БД' 5.589 + trigger_prototypes: 5.590 + - uuid: a4971a735cc04479bbde632a0f03926f 5.591 + expression: 'last(/PgBouncer/pgbouncer.pools.db.maxwait_us[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}])>100' 5.592 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Максимальное время ожидания в очереди на подключение превысило 100 микросекунд' 5.593 + opdata: 'Время ожидания: {ITEM.LASTVALUE1}' 5.594 + priority: INFO 5.595 + - uuid: 7d54c757ce8f4b6eb75b470431aa31f5 5.596 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных серверных подключений' 5.597 + type: DEPENDENT 5.598 + key: 'pgbouncer.pools.db.sv_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.599 + delay: '0' 5.600 + history: 30d 5.601 + trends: 90d 5.602 + preprocessing: 5.603 + - type: JSONPATH 5.604 + parameters: 5.605 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_active' 5.606 + - type: JSONPATH 5.607 + parameters: 5.608 + - '$[0]' 5.609 + master_item: 5.610 + key: pgbouncer.pool.pools 5.611 + tags: 5.612 + - tag: Application 5.613 + value: PgBouncer 5.614 + - tag: DatabaseName 5.615 + value: '{#PGBOUNCER_DATABASE}' 5.616 + - tag: DatabaseUser 5.617 + value: '{#PGBOUNCER_USER}' 5.618 + - tag: Func 5.619 + value: 'Статистика БД' 5.620 + - uuid: 2a95424618784993986b283ed2b473bf 5.621 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Простаивающие подключения' 5.622 + type: DEPENDENT 5.623 + key: 'pgbouncer.pools.db.sv_idle[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.624 + delay: '0' 5.625 + history: 30d 5.626 + trends: 90d 5.627 + description: 'Server connections that are unused and immediately usable for client queries.' 5.628 + preprocessing: 5.629 + - type: JSONPATH 5.630 + parameters: 5.631 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_idle' 5.632 + - type: JSONPATH 5.633 + parameters: 5.634 + - '$[0]' 5.635 + master_item: 5.636 + key: pgbouncer.pool.pools 5.637 + tags: 5.638 + - tag: Application 5.639 + value: PgBouncer 5.640 + - tag: DatabaseName 5.641 + value: '{#PGBOUNCER_DATABASE}' 5.642 + - tag: DatabaseUser 5.643 + value: '{#PGBOUNCER_USER}' 5.644 + - tag: Func 5.645 + value: 'Статистика БД' 5.646 + - uuid: bd06403ea5334b01833798324d22345b 5.647 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных серверных подключений на стадии авторизации' 5.648 + type: DEPENDENT 5.649 + key: 'pgbouncer.pools.db.sv_login[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.650 + delay: '0' 5.651 + history: 30d 5.652 + trends: 90d 5.653 + preprocessing: 5.654 + - type: JSONPATH 5.655 + parameters: 5.656 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_login' 5.657 + - type: JSONPATH 5.658 + parameters: 5.659 + - '$[0]' 5.660 + master_item: 5.661 + key: pgbouncer.pool.pools 5.662 + tags: 5.663 + - tag: Application 5.664 + value: PgBouncer 5.665 + - tag: DatabaseName 5.666 + value: '{#PGBOUNCER_DATABASE}' 5.667 + - tag: DatabaseUser 5.668 + value: '{#PGBOUNCER_USER}' 5.669 + - tag: Func 5.670 + value: 'Статистика БД' 5.671 + - uuid: b7e79133dfca42f49aebb93d5d8749d3 5.672 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу, находящиеся либо в стадии проверки либо сброса и возврата в пул свободных' 5.673 + type: DEPENDENT 5.674 + key: 'pgbouncer.pools.db.sv_tested[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.675 + delay: '0' 5.676 + history: 30d 5.677 + trends: 90d 5.678 + preprocessing: 5.679 + - type: JSONPATH 5.680 + parameters: 5.681 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_tested' 5.682 + - type: JSONPATH 5.683 + parameters: 5.684 + - '$[0]' 5.685 + master_item: 5.686 + key: pgbouncer.pool.pools 5.687 + tags: 5.688 + - tag: Application 5.689 + value: PgBouncer 5.690 + - tag: DatabaseName 5.691 + value: '{#PGBOUNCER_DATABASE}' 5.692 + - tag: DatabaseUser 5.693 + value: '{#PGBOUNCER_USER}' 5.694 + - tag: Func 5.695 + value: 'Статистика БД' 5.696 + - uuid: 9326b8cd476e4d9891153a0c2924c4d7 5.697 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Задействованные подключения к серверу' 5.698 + type: DEPENDENT 5.699 + key: 'pgbouncer.pools.db.sv_used[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.700 + delay: '0' 5.701 + history: 30d 5.702 + trends: 90d 5.703 + preprocessing: 5.704 + - type: JSONPATH 5.705 + parameters: 5.706 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].sv_used' 5.707 + - type: JSONPATH 5.708 + parameters: 5.709 + - '$[0]' 5.710 + master_item: 5.711 + key: pgbouncer.pool.pools 5.712 + tags: 5.713 + - tag: Application 5.714 + value: PgBouncer 5.715 + - tag: DatabaseName 5.716 + value: '{#PGBOUNCER_DATABASE}' 5.717 + - tag: DatabaseUser 5.718 + value: '{#PGBOUNCER_USER}' 5.719 + - tag: Func 5.720 + value: 'Статистика БД' 5.721 + - uuid: 1475ff5de3c54ba792458e063bd92d29 5.722 + name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Режим управления пулом соединений' 5.723 + type: DEPENDENT 5.724 + key: 'pgbouncer.pools.pool_mode[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.725 + delay: '0' 5.726 + history: 30d 5.727 + trends: '0' 5.728 + value_type: CHAR 5.729 + description: 'The pooling mode in use' 5.730 + preprocessing: 5.731 + - type: JSONPATH 5.732 + parameters: 5.733 + - '$[?(@.database == "{#PGBOUNCER_DATABASE}" && @.user == "{#PGBOUNCER_USER}")].pool_mode' 5.734 + - type: JSONPATH 5.735 + parameters: 5.736 + - '$[0]' 5.737 + master_item: 5.738 + key: pgbouncer.pool.pools 5.739 + tags: 5.740 + - tag: Application 5.741 + value: PgBouncer 5.742 + - tag: DatabaseName 5.743 + value: '{#PGBOUNCER_DATABASE}' 5.744 + - tag: DatabaseUser 5.745 + value: '{#PGBOUNCER_USER}' 5.746 + - tag: Func 5.747 + value: 'Статистика БД' 5.748 + - uuid: 7de8a33441434eedb9c49a5c6f9d12b8 5.749 + name: '{#PGBOUNCER_DATABASE}: Средняя продолжительность запроса' 5.750 + type: DEPENDENT 5.751 + key: 'pgbouncer.stats.db.avg_query_time[{#PGBOUNCER_DATABASE}]' 5.752 + delay: '0' 5.753 + history: 30d 5.754 + trends: 90d 5.755 + units: ms 5.756 + preprocessing: 5.757 + - type: JSONPATH 5.758 + parameters: 5.759 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_query_time' 5.760 + - type: JSONPATH 5.761 + parameters: 5.762 + - '$[0]' 5.763 + master_item: 5.764 + key: pgbouncer.pool.stats 5.765 + tags: 5.766 + - tag: Application 5.767 + value: PgBouncer 5.768 + - tag: DatabaseName 5.769 + value: '{#PGBOUNCER_DATABASE}' 5.770 + - tag: Func 5.771 + value: 'Статистика БД' 5.772 + - uuid: 4911f76b7b03407b9b39737303714db6 5.773 + name: '{#PGBOUNCER_DATABASE}: Среднее время ожидания свободного подключения' 5.774 + type: DEPENDENT 5.775 + key: 'pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}]' 5.776 + delay: '0' 5.777 + history: 30d 5.778 + trends: 90d 5.779 + units: ms 5.780 + preprocessing: 5.781 + - type: JSONPATH 5.782 + parameters: 5.783 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_wait_time' 5.784 + - type: JSONPATH 5.785 + parameters: 5.786 + - '$[0]' 5.787 + master_item: 5.788 + key: pgbouncer.pool.stats 5.789 + tags: 5.790 + - tag: Application 5.791 + value: PgBouncer 5.792 + - tag: DatabaseName 5.793 + value: '{#PGBOUNCER_DATABASE}' 5.794 + - tag: Func 5.795 + value: 'Статистика БД' 5.796 + trigger_prototypes: 5.797 + - uuid: 8adff22128884a8cb0e30f215776ae00 5.798 + expression: 'last(/PgBouncer/pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}])>{$PBBOUNCER.WAIT.TIME}' 5.799 + name: '{#PGBOUNCER_DATABASE}: Среднее время ожидания в очереди более {$PBBOUNCER.WAIT.TIME}ms' 5.800 + priority: AVERAGE 5.801 + - uuid: 70c41f4bed104f65b47256cb1ccd3ff9 5.802 + name: '{#PGBOUNCER_DATABASE}: Средняя продолжительность транзакции' 5.803 + type: DEPENDENT 5.804 + key: 'pgbouncer.stats.db.avg_xact_time[{#PGBOUNCER_DATABASE}]' 5.805 + delay: '0' 5.806 + history: 30d 5.807 + trends: 90d 5.808 + units: ms 5.809 + preprocessing: 5.810 + - type: JSONPATH 5.811 + parameters: 5.812 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].avg_xact_time' 5.813 + - type: JSONPATH 5.814 + parameters: 5.815 + - '$[0]' 5.816 + master_item: 5.817 + key: pgbouncer.pool.stats 5.818 + tags: 5.819 + - tag: Application 5.820 + value: PgBouncer 5.821 + - tag: DatabaseName 5.822 + value: '{#PGBOUNCER_DATABASE}' 5.823 + - tag: Func 5.824 + value: 'Статистика БД' 5.825 + - uuid: c7784c3d75d0411d920fe6856cf050ea 5.826 + name: '{#PGBOUNCER_DATABASE}: Среднее количество запросов к БД в секунду' 5.827 + type: DEPENDENT 5.828 + key: 'pgbouncer.stats.db.total_query_count[{#PGBOUNCER_DATABASE}]' 5.829 + delay: '0' 5.830 + history: 30d 5.831 + trends: 90d 5.832 + units: queries/s 5.833 + preprocessing: 5.834 + - type: JSONPATH 5.835 + parameters: 5.836 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_query_count' 5.837 + - type: JSONPATH 5.838 + parameters: 5.839 + - '$[0]' 5.840 + - type: CHANGE_PER_SECOND 5.841 + parameters: 5.842 + - '' 5.843 + master_item: 5.844 + key: pgbouncer.pool.stats 5.845 + tags: 5.846 + - tag: Application 5.847 + value: PgBouncer 5.848 + - tag: DatabaseName 5.849 + value: '{#PGBOUNCER_DATABASE}' 5.850 + - tag: Func 5.851 + value: 'Статистика БД' 5.852 + - uuid: d6eb4da92aeb44cea5aefb536b4efae1 5.853 + name: '{#PGBOUNCER_DATABASE}: Средняя скорость получения данных балансировщиком' 5.854 + type: DEPENDENT 5.855 + key: 'pgbouncer.stats.db.total_received[{#PGBOUNCER_DATABASE}]' 5.856 + delay: '0' 5.857 + history: 30d 5.858 + trends: 90d 5.859 + units: b/s 5.860 + preprocessing: 5.861 + - type: JSONPATH 5.862 + parameters: 5.863 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_received' 5.864 + - type: JSONPATH 5.865 + parameters: 5.866 + - '$[0]' 5.867 + - type: CHANGE_PER_SECOND 5.868 + parameters: 5.869 + - '' 5.870 + master_item: 5.871 + key: pgbouncer.pool.stats 5.872 + tags: 5.873 + - tag: Application 5.874 + value: PgBouncer 5.875 + - tag: DatabaseName 5.876 + value: '{#PGBOUNCER_DATABASE}' 5.877 + - tag: Func 5.878 + value: 'Статистика БД' 5.879 + - uuid: 71b50f61435f4df4b97e464952cde5ab 5.880 + name: '{#PGBOUNCER_DATABASE}: Средняя скорость отправки данных балансировщиком' 5.881 + type: DEPENDENT 5.882 + key: 'pgbouncer.stats.db.total_sent[{#PGBOUNCER_DATABASE}]' 5.883 + delay: '0' 5.884 + history: 30d 5.885 + trends: 90d 5.886 + units: b/s 5.887 + description: 'Network traffic sent by pgbouncer in bytes.' 5.888 + preprocessing: 5.889 + - type: JSONPATH 5.890 + parameters: 5.891 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_sent' 5.892 + - type: JSONPATH 5.893 + parameters: 5.894 + - '$[0]' 5.895 + - type: CHANGE_PER_SECOND 5.896 + parameters: 5.897 + - '' 5.898 + master_item: 5.899 + key: pgbouncer.pool.stats 5.900 + tags: 5.901 + - tag: Application 5.902 + value: PgBouncer 5.903 + - tag: DatabaseName 5.904 + value: '{#PGBOUNCER_DATABASE}' 5.905 + - tag: Func 5.906 + value: 'Статистика БД' 5.907 + - uuid: 1dad183897b14125b07ab89a01caa549 5.908 + name: '{#PGBOUNCER_DATABASE}: Среднее количество транзакций в секунду.' 5.909 + type: DEPENDENT 5.910 + key: 'pgbouncer.stats.db.total_xact_count[{#PGBOUNCER_DATABASE}]' 5.911 + delay: '0' 5.912 + history: 30d 5.913 + trends: 90d 5.914 + units: transactions/s 5.915 + preprocessing: 5.916 + - type: JSONPATH 5.917 + parameters: 5.918 + - '$[?(@.name == "{#PGBOUNCER_DATABASE}")].total_xact_count' 5.919 + - type: JSONPATH 5.920 + parameters: 5.921 + - '$[0]' 5.922 + - type: CHANGE_PER_SECOND 5.923 + parameters: 5.924 + - '' 5.925 + master_item: 5.926 + key: pgbouncer.pool.stats 5.927 + tags: 5.928 + - tag: Application 5.929 + value: PgBouncer 5.930 + - tag: DatabaseName 5.931 + value: '{#PGBOUNCER_DATABASE}' 5.932 + - tag: Func 5.933 + value: 'Статистика БД' 5.934 + graph_prototypes: 5.935 + - uuid: 25021355bd724712a4b00e6fc62bcaac 5.936 + name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения' 5.937 + graph_items: 5.938 + - color: 199C0D 5.939 + item: 5.940 + host: PgBouncer 5.941 + key: 'pgbouncer.pools.db.cl_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.942 + - sortorder: '1' 5.943 + color: F63100 5.944 + item: 5.945 + host: PgBouncer 5.946 + key: 'pgbouncer.pools.db.cl_waiting[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.947 + - uuid: ca60cfc7d1be4eb5a745e0ae402b7bc4 5.948 + name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу' 5.949 + graph_items: 5.950 + - color: 199C0D 5.951 + item: 5.952 + host: PgBouncer 5.953 + key: 'pgbouncer.pools.db.sv_active[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.954 + - sortorder: '1' 5.955 + color: F63100 5.956 + item: 5.957 + host: PgBouncer 5.958 + key: 'pgbouncer.pools.db.sv_login[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.959 + - sortorder: '2' 5.960 + color: 2774A4 5.961 + item: 5.962 + host: PgBouncer 5.963 + key: 'pgbouncer.pools.db.sv_tested[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.964 + - sortorder: '3' 5.965 + color: F7941D 5.966 + item: 5.967 + host: PgBouncer 5.968 + key: 'pgbouncer.pools.db.sv_idle[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.969 + - sortorder: '4' 5.970 + color: FC6EA3 5.971 + item: 5.972 + host: PgBouncer 5.973 + key: 'pgbouncer.pools.db.sv_used[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]' 5.974 + - uuid: 770b8bebd0074052848690582040f3d6 5.975 + name: 'PgBouncer: Сетевой трафик {#PGBOUNCER_DATABASE}' 5.976 + graph_items: 5.977 + - sortorder: '1' 5.978 + drawtype: GRADIENT_LINE 5.979 + color: 199C0D 5.980 + item: 5.981 + host: PgBouncer 5.982 + key: 'pgbouncer.stats.db.total_received[{#PGBOUNCER_DATABASE}]' 5.983 + - sortorder: '2' 5.984 + drawtype: GRADIENT_LINE 5.985 + color: 0040FF 5.986 + item: 5.987 + host: PgBouncer 5.988 + key: 'pgbouncer.stats.db.total_sent[{#PGBOUNCER_DATABASE}]' 5.989 + macros: 5.990 + - macro: '{$PBBOUNCER.WAIT.TIME}' 5.991 + value: '1000' 5.992 + description: 'Time spent by clients waiting for a server, in microseconds (average per second).' 5.993 + dashboards: 5.994 + - uuid: 391b2243c1c54c9cb4e1031f514d96b2 5.995 + name: 'PgBouncer - обзор' 5.996 + pages: 5.997 + - widgets: 5.998 + - type: GRAPH_CLASSIC 5.999 + width: '12' 5.1000 + height: '5' 5.1001 + fields: 5.1002 + - type: GRAPH 5.1003 + name: graphid 5.1004 + value: 5.1005 + host: PgBouncer 5.1006 + name: 'PgBouncer: Подключения' 5.1007 + - type: GRAPH_PROTOTYPE 5.1008 + 'y': '5' 5.1009 + width: '12' 5.1010 + height: '5' 5.1011 + fields: 5.1012 + - type: INTEGER 5.1013 + name: columns 5.1014 + value: '1' 5.1015 + - type: GRAPH_PROTOTYPE 5.1016 + name: graphid 5.1017 + value: 5.1018 + host: PgBouncer 5.1019 + name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения' 5.1020 + - type: GRAPH_CLASSIC 5.1021 + 'y': '10' 5.1022 + width: '12' 5.1023 + height: '5' 5.1024 + fields: 5.1025 + - type: ITEM 5.1026 + name: itemid 5.1027 + value: 5.1028 + host: PgBouncer 5.1029 + key: pgbouncer.total.avg_query_count 5.1030 + - type: INTEGER 5.1031 + name: source_type 5.1032 + value: '1' 5.1033 + - type: GRAPH_CLASSIC 5.1034 + x: '12' 5.1035 + width: '12' 5.1036 + height: '5' 5.1037 + fields: 5.1038 + - type: GRAPH 5.1039 + name: graphid 5.1040 + value: 5.1041 + host: PgBouncer 5.1042 + name: 'PgBouncer: Объём передаваемых данных по всем БД' 5.1043 + - type: GRAPH_PROTOTYPE 5.1044 + x: '12' 5.1045 + 'y': '5' 5.1046 + width: '12' 5.1047 + height: '5' 5.1048 + fields: 5.1049 + - type: INTEGER 5.1050 + name: columns 5.1051 + value: '1' 5.1052 + - type: GRAPH_PROTOTYPE 5.1053 + name: graphid 5.1054 + value: 5.1055 + host: PgBouncer 5.1056 + name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу' 5.1057 + - type: GRAPH_CLASSIC 5.1058 + x: '12' 5.1059 + 'y': '10' 5.1060 + width: '12' 5.1061 + height: '5' 5.1062 + fields: 5.1063 + - type: ITEM 5.1064 + name: itemid 5.1065 + value: 5.1066 + host: PgBouncer 5.1067 + key: pgbouncer.total.avg_query_time 5.1068 + - type: INTEGER 5.1069 + name: source_type 5.1070 + value: '1' 5.1071 + graphs: 5.1072 + - uuid: 8e8efd0772ab4053bb8c79173010d3e6 5.1073 + name: 'PgBouncer: Объём передаваемых данных по всем БД' 5.1074 + graph_items: 5.1075 + - drawtype: FILLED_REGION 5.1076 + color: 00FF00 5.1077 + item: 5.1078 + host: PgBouncer 5.1079 + key: pgbouncer.total.total_client_bytes 5.1080 + - sortorder: '1' 5.1081 + drawtype: FILLED_REGION 5.1082 + color: 0040FF 5.1083 + item: 5.1084 + host: PgBouncer 5.1085 + key: pgbouncer.total.total_server_bytes 5.1086 + - uuid: b433d80b3d69405e809b607e0a2587b0 5.1087 + name: 'PgBouncer: Подключения' 5.1088 + graph_items: 5.1089 + - color: 199C0D 5.1090 + item: 5.1091 + host: PgBouncer 5.1092 + key: pgbouncer.lists.free_clients 5.1093 + - sortorder: '1' 5.1094 + color: F63100 5.1095 + item: 5.1096 + host: PgBouncer 5.1097 + key: pgbouncer.lists.free_servers 5.1098 + - sortorder: '2' 5.1099 + color: 2774A4 5.1100 + item: 5.1101 + host: PgBouncer 5.1102 + key: pgbouncer.lists.login_clients 5.1103 + - sortorder: '3' 5.1104 + color: F7941D 5.1105 + item: 5.1106 + host: PgBouncer 5.1107 + key: pgbouncer.lists.used_clients 5.1108 + - sortorder: '4' 5.1109 + color: FC6EA3 5.1110 + item: 5.1111 + host: PgBouncer 5.1112 + key: pgbouncer.lists.used_servers