ncc.zabbix_templates
ncc.zabbix_templates/pgBouncer/zbx_export_templates.yaml
* Отражаем изменения сделанные в выдаче статистики в pgbouncer версии 1.23
1.1 --- a/pgBouncer/zbx_export_templates.yaml Wed Jun 26 00:32:00 2024 +0300 1.2 +++ b/pgBouncer/zbx_export_templates.yaml Sat Jul 06 19:57:04 2024 +0300 1.3 @@ -1,7 +1,6 @@ 1.4 zabbix_export: 1.5 - version: '6.0' 1.6 - date: '2023-11-27T11:25:38Z' 1.7 - groups: 1.8 + version: '7.0' 1.9 + template_groups: 1.10 - uuid: 22941f4e01294888a9bed3aae15f6ef9 1.11 name: Templates/AWNET 1.12 templates: 1.13 @@ -232,20 +231,20 @@ 1.14 1.15 res.push({ 1.16 name: my_trim(el_buf[0]), 1.17 - total_xact_count: my_trim(el_buf[1]), 1.18 - total_query_count: my_trim(el_buf[2]), 1.19 - total_received: my_trim(el_buf[3]), 1.20 - total_sent: my_trim(el_buf[4]), 1.21 - total_xact_time: my_trim(el_buf[5]), 1.22 - total_query_time: my_trim(el_buf[6]), 1.23 - total_wait_time: my_trim(el_buf[7]), 1.24 - avg_xact_count: my_trim(el_buf[8]), 1.25 - avg_query_count: my_trim(el_buf[9]), 1.26 - avg_recv: my_trim(el_buf[10]), 1.27 - avg_sent: my_trim(el_buf[11]), 1.28 - avg_xact_time: my_trim(el_buf[12]), 1.29 - avg_query_time: my_trim(el_buf[13]), 1.30 - avg_wait_time: my_trim(el_buf[14]), 1.31 + total_xact_count: my_trim(el_buf[2]), 1.32 + total_query_count: my_trim(el_buf[3]), 1.33 + total_received: my_trim(el_buf[4]), 1.34 + total_sent: my_trim(el_buf[5]), 1.35 + total_xact_time: my_trim(el_buf[6]), 1.36 + total_query_time: my_trim(el_buf[7]), 1.37 + total_wait_time: my_trim(el_buf[8]), 1.38 + avg_xact_count: my_trim(el_buf[10]), 1.39 + avg_query_count: my_trim(el_buf[11]), 1.40 + avg_recv: my_trim(el_buf[12]), 1.41 + avg_sent: my_trim(el_buf[13]), 1.42 + avg_xact_time: my_trim(el_buf[14]), 1.43 + avg_query_time: my_trim(el_buf[15]), 1.44 + avg_wait_time: my_trim(el_buf[16]), 1.45 }); 1.46 } 1.47 1.48 @@ -470,6 +469,7 @@ 1.49 key: pgbouncer.pool.discover 1.50 delay: 30m 1.51 lifetime: 1h 1.52 + enabled_lifetime_type: DISABLE_NEVER 1.53 item_prototypes: 1.54 - uuid: cb931dfeada449bf9749d11b0fc506c7 1.55 name: '{#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Активных подключений' 1.56 @@ -992,8 +992,8 @@ 1.57 name: 'PgBouncer - обзор' 1.58 pages: 1.59 - widgets: 1.60 - - type: GRAPH_CLASSIC 1.61 - width: '12' 1.62 + - type: graph 1.63 + width: '36' 1.64 height: '5' 1.65 fields: 1.66 - type: GRAPH 1.67 @@ -1001,9 +1001,12 @@ 1.68 value: 1.69 host: PgBouncer 1.70 name: 'PgBouncer: Подключения' 1.71 - - type: GRAPH_PROTOTYPE 1.72 + - type: STRING 1.73 + name: reference 1.74 + value: AABHW 1.75 + - type: graphprototype 1.76 'y': '5' 1.77 - width: '12' 1.78 + width: '36' 1.79 height: '5' 1.80 fields: 1.81 - type: INTEGER 1.82 @@ -1014,9 +1017,12 @@ 1.83 value: 1.84 host: PgBouncer 1.85 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Клиентские подключения' 1.86 - - type: GRAPH_CLASSIC 1.87 + - type: STRING 1.88 + name: reference 1.89 + value: AABHY 1.90 + - type: graph 1.91 'y': '10' 1.92 - width: '12' 1.93 + width: '36' 1.94 height: '5' 1.95 fields: 1.96 - type: ITEM 1.97 @@ -1024,12 +1030,15 @@ 1.98 value: 1.99 host: PgBouncer 1.100 key: pgbouncer.total.avg_query_count 1.101 + - type: STRING 1.102 + name: reference 1.103 + value: AABIA 1.104 - type: INTEGER 1.105 name: source_type 1.106 value: '1' 1.107 - - type: GRAPH_CLASSIC 1.108 - x: '12' 1.109 - width: '12' 1.110 + - type: graph 1.111 + x: '36' 1.112 + width: '36' 1.113 height: '5' 1.114 fields: 1.115 - type: GRAPH 1.116 @@ -1037,10 +1046,13 @@ 1.117 value: 1.118 host: PgBouncer 1.119 name: 'PgBouncer: Объём передаваемых данных по всем БД' 1.120 - - type: GRAPH_PROTOTYPE 1.121 - x: '12' 1.122 + - type: STRING 1.123 + name: reference 1.124 + value: AABHX 1.125 + - type: graphprototype 1.126 + x: '36' 1.127 'y': '5' 1.128 - width: '12' 1.129 + width: '36' 1.130 height: '5' 1.131 fields: 1.132 - type: INTEGER 1.133 @@ -1051,10 +1063,13 @@ 1.134 value: 1.135 host: PgBouncer 1.136 name: 'PgBouncer: {#PGBOUNCER_DATABASE}[{#PGBOUNCER_USER}]: Подключения к серверу' 1.137 - - type: GRAPH_CLASSIC 1.138 - x: '12' 1.139 + - type: STRING 1.140 + name: reference 1.141 + value: AABHZ 1.142 + - type: graph 1.143 + x: '36' 1.144 'y': '10' 1.145 - width: '12' 1.146 + width: '36' 1.147 height: '5' 1.148 fields: 1.149 - type: ITEM 1.150 @@ -1062,6 +1077,9 @@ 1.151 value: 1.152 host: PgBouncer 1.153 key: pgbouncer.total.avg_query_time 1.154 + - type: STRING 1.155 + name: reference 1.156 + value: AABIB 1.157 - type: INTEGER 1.158 name: source_type 1.159 value: '1'