ncc.zabbix_templates

     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/.hgignore	Fri Mar 14 00:27:05 2025 +0300
     1.3 @@ -0,0 +1,3 @@
     1.4 +# Default ignored files
     1.5 +.idea/
     1.6 +.idea/*

     2.1 --- a/pgBouncer/zbx_export_templates.yaml	Mon Sep 09 20:38:42 2024 +0300
     2.2 +++ b/pgBouncer/zbx_export_templates.yaml	Fri Mar 14 00:27:05 2025 +0300
     2.3 @@ -152,8 +152,8 @@
     2.4            name: 'PgBouncer lists raw'
     2.5            key: pgbouncer.pool.lists
     2.6            history: '0'
     2.7 +          value_type: TEXT
     2.8            trends: '0'
     2.9 -          value_type: TEXT
    2.10            tags:
    2.11              - tag: Application
    2.12                value: PgBouncer
    2.13 @@ -161,8 +161,8 @@
    2.14            name: 'PgBouncer pools raw'
    2.15            key: pgbouncer.pool.pools
    2.16            history: '0'
    2.17 +          value_type: TEXT
    2.18            trends: '0'
    2.19 -          value_type: TEXT
    2.20            preprocessing:
    2.21              - type: JAVASCRIPT
    2.22                parameters:
    2.23 @@ -209,8 +209,8 @@
    2.24            name: 'PgBouncer stats raw'
    2.25            key: pgbouncer.pool.stats
    2.26            history: '0'
    2.27 +          value_type: TEXT
    2.28            trends: '0'
    2.29 -          value_type: TEXT
    2.30            preprocessing:
    2.31              - type: JAVASCRIPT
    2.32                parameters:
    2.33 @@ -256,8 +256,8 @@
    2.34            name: 'PgBouncer totals raw'
    2.35            key: pgbouncer.pool.totals
    2.36            history: '0'
    2.37 +          value_type: TEXT
    2.38            trends: '0'
    2.39 -          value_type: TEXT
    2.40            tags:
    2.41              - tag: Application
    2.42                value: PgBouncer
    2.43 @@ -286,8 +286,8 @@
    2.44            key: pgbouncer.total.avg_query_time
    2.45            delay: '0'
    2.46            history: 30d
    2.47 +          value_type: FLOAT
    2.48            trends: 90d
    2.49 -          value_type: FLOAT
    2.50            units: ms
    2.51            preprocessing:
    2.52              - type: REGEX
    2.53 @@ -310,8 +310,8 @@
    2.54            key: pgbouncer.total.avg_wait_time
    2.55            delay: '0'
    2.56            history: 30d
    2.57 +          value_type: FLOAT
    2.58            trends: 90d
    2.59 -          value_type: FLOAT
    2.60            units: ms
    2.61            preprocessing:
    2.62              - type: REGEX
    2.63 @@ -353,8 +353,8 @@
    2.64            key: pgbouncer.total.avg_xact_time
    2.65            delay: '0'
    2.66            history: 30d
    2.67 +          value_type: FLOAT
    2.68            trends: 90d
    2.69 -          value_type: FLOAT
    2.70            units: ms
    2.71            preprocessing:
    2.72              - type: REGEX
    2.73 @@ -561,8 +561,8 @@
    2.74                key: 'pgbouncer.pools.db.maxwait_us[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
    2.75                delay: '0'
    2.76                history: 30d
    2.77 +              value_type: FLOAT
    2.78                trends: 90d
    2.79 -              value_type: FLOAT
    2.80                units: micros
    2.81                description: 'Смотреть в описание "Максимального ожидания"'
    2.82                preprocessing:
    2.83 @@ -721,8 +721,8 @@
    2.84                key: 'pgbouncer.pools.pool_mode[{#PGBOUNCER_DATABASE},{#PGBOUNCER_USER}]'
    2.85                delay: '0'
    2.86                history: 30d
    2.87 +              value_type: CHAR
    2.88                trends: '0'
    2.89 -              value_type: CHAR
    2.90                description: 'The pooling mode in use'
    2.91                preprocessing:
    2.92                  - type: JSONPATH
    2.93 @@ -748,6 +748,7 @@
    2.94                key: 'pgbouncer.stats.db.avg_query_time[{#PGBOUNCER_DATABASE}]'
    2.95                delay: '0'
    2.96                history: 30d
    2.97 +              value_type: FLOAT
    2.98                trends: 90d
    2.99                units: ms
   2.100                preprocessing:
   2.101 @@ -757,6 +758,9 @@
   2.102                  - type: JSONPATH
   2.103                    parameters:
   2.104                      - '$[0]'
   2.105 +                - type: MULTIPLIER
   2.106 +                  parameters:
   2.107 +                    - '0.001'
   2.108                master_item:
   2.109                  key: pgbouncer.pool.stats
   2.110                tags:
   2.111 @@ -772,6 +776,7 @@
   2.112                key: 'pgbouncer.stats.db.avg_wait_time[{#PGBOUNCER_DATABASE}]'
   2.113                delay: '0'
   2.114                history: 30d
   2.115 +              value_type: FLOAT
   2.116                trends: 90d
   2.117                units: ms
   2.118                preprocessing:
   2.119 @@ -781,6 +786,9 @@
   2.120                  - type: JSONPATH
   2.121                    parameters:
   2.122                      - '$[0]'
   2.123 +                - type: MULTIPLIER
   2.124 +                  parameters:
   2.125 +                    - '0.001'
   2.126                master_item:
   2.127                  key: pgbouncer.pool.stats
   2.128                tags:
   2.129 @@ -801,6 +809,7 @@
   2.130                key: 'pgbouncer.stats.db.avg_xact_time[{#PGBOUNCER_DATABASE}]'
   2.131                delay: '0'
   2.132                history: 30d
   2.133 +              value_type: FLOAT
   2.134                trends: 90d
   2.135                units: ms
   2.136                preprocessing:
   2.137 @@ -810,6 +819,9 @@
   2.138                  - type: JSONPATH
   2.139                    parameters:
   2.140                      - '$[0]'
   2.141 +                - type: MULTIPLIER
   2.142 +                  parameters:
   2.143 +                    - '0.001'
   2.144                master_item:
   2.145                  key: pgbouncer.pool.stats
   2.146                tags: