ncc.zabbix_templates

     1.1 --- a/pgBouncer/zbx_export_templates.yaml	Mon Sep 09 20:38:42 2024 +0300
     1.2 +++ b/pgBouncer/zbx_export_templates.yaml	Fri Mar 14 00:27:05 2025 +0300
     1.3 @@ -152,8 +152,8 @@
     1.4            name: 'PgBouncer lists raw'
     1.5            key: pgbouncer.pool.lists
     1.6            history: '0'
     1.7 +          value_type: TEXT
     1.8            trends: '0'
     1.9 -          value_type: TEXT
    1.10            tags:
    1.11              - tag: Application
    1.12                value: PgBouncer
    1.13 @@ -161,8 +161,8 @@
    1.14            name: 'PgBouncer pools raw'
    1.15            key: pgbouncer.pool.pools
    1.16            history: '0'
    1.17 +          value_type: TEXT
    1.18            trends: '0'
    1.19 -          value_type: TEXT
    1.20            preprocessing:
    1.21              - type: JAVASCRIPT
    1.22                parameters:
    1.23 @@ -209,8 +209,8 @@
    1.24            name: 'PgBouncer stats raw'
    1.25            key: pgbouncer.pool.stats
    1.26            history: '0'
    1.27 +          value_type: TEXT
    1.28            trends: '0'
    1.29 -          value_type: TEXT
    1.30            preprocessing:
    1.31              - type: JAVASCRIPT
    1.32                parameters:
    1.33 @@ -256,8 +256,8 @@
    1.34            name: 'PgBouncer totals raw'
    1.35            key: pgbouncer.pool.totals
    1.36            history: '0'
    1.37 +          value_type: TEXT
    1.38            trends: '0'
    1.39 -          value_type: TEXT
    1.40            tags:
    1.41              - tag: Application
    1.42                value: PgBouncer
    1.43 @@ -286,8 +286,8 @@
    1.44            key: pgbouncer.total.avg_query_time
    1.45            delay: '0'
    1.46            history: 30d
    1.47 +          value_type: FLOAT
    1.48            trends: 90d
    1.49 -          value_type: FLOAT
    1.50            units: ms
    1.51            preprocessing:
    1.52              - type: REGEX
    1.53 @@ -310,8 +310,8 @@
    1.54            key: pgbouncer.total.avg_wait_time
    1.55            delay: '0'
    1.56            history: 30d
    1.57 +          value_type: FLOAT
    1.58            trends: 90d
    1.59 -          value_type: FLOAT
    1.60            units: ms
    1.61            preprocessing:
    1.62              - type: REGEX
    1.63 @@ -353,8 +353,8 @@
    1.64            key: pgbouncer.total.avg_xact_time
    1.65            delay: '0'
    1.66            history: 30d
    1.67 +          value_type: FLOAT
    1.68            trends: 90d
    1.69 -          value_type: FLOAT
    1.70            units: ms
    1.71            preprocessing:
    1.72              - type: REGEX
    1.73 @@ -561,8 +561,8 @@
    1.74                key: 'pgbouncer.pools.db.maxwait_us[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
    1.75                delay: '0'
    1.76                history: 30d
    1.77 +              value_type: FLOAT
    1.78                trends: 90d
    1.79 -              value_type: FLOAT
    1.80                units: micros
    1.81                description: 'Смотреть в описание "Максимального ожидания"'
    1.82                preprocessing:
    1.83 @@ -721,8 +721,8 @@
    1.84                key: 'pgbouncer.pools.pool_mode[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
    1.85                delay: '0'
    1.86                history: 30d
    1.87 +              value_type: CHAR
    1.88                trends: '0'
    1.89 -              value_type: CHAR
    1.90                description: 'The pooling mode in use'
    1.91                preprocessing:
    1.92                  - type: JSONPATH
    1.93 @@ -748,6 +748,7 @@
    1.94                key: 'pgbouncer.stats.db.avg_query_time[{#PGBOUNCER_DATABASE}]'
    1.95                delay: '0'
    1.96                history: 30d
    1.97 +              value_type: FLOAT
    1.98                trends: 90d
    1.99                units: ms
   1.100                preprocessing:
   1.101 @@ -757,6 +758,9 @@
   1.102                  - type: JSONPATH
   1.103                    parameters:
   1.104                      - '$[0]'
   1.105 +                - type: MULTIPLIER
   1.106 +                  parameters:
   1.107 +                    - '0.001'
   1.108                master_item:
   1.109                  key: pgbouncer.pool.stats
   1.110                tags:
   1.111 @@ -772,6 +776,7 @@
   1.112                key: 'pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}]'
   1.113                delay: '0'
   1.114                history: 30d
   1.115 +              value_type: FLOAT
   1.116                trends: 90d
   1.117                units: ms
   1.118                preprocessing:
   1.119 @@ -781,6 +786,9 @@
   1.120                  - type: JSONPATH
   1.121                    parameters:
   1.122                      - '$[0]'
   1.123 +                - type: MULTIPLIER
   1.124 +                  parameters:
   1.125 +                    - '0.001'
   1.126                master_item:
   1.127                  key: pgbouncer.pool.stats
   1.128                tags:
   1.129 @@ -801,6 +809,7 @@
   1.130                key: 'pgbouncer.stats.db.avg_xact_time[{#PGBOUNCER_DATABASE}]'
   1.131                delay: '0'
   1.132                history: 30d
   1.133 +              value_type: FLOAT
   1.134                trends: 90d
   1.135                units: ms
   1.136                preprocessing:
   1.137 @@ -810,6 +819,9 @@
   1.138                  - type: JSONPATH
   1.139                    parameters:
   1.140                      - '$[0]'
   1.141 +                - type: MULTIPLIER
   1.142 +                  parameters:
   1.143 +                    - '0.001'
   1.144                master_item:
   1.145                  key: pgbouncer.pool.stats
   1.146                tags: