Last active
February 19, 2019 11:24
-
-
Save meysammeisam/4753940f05945ab8b9427b5388121aef to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "__inputs": [ | |
| { | |
| "name": "DS_PROMETHEUS", | |
| "label": "Prometheus", | |
| "description": "", | |
| "type": "datasource", | |
| "pluginId": "prometheus", | |
| "pluginName": "Prometheus" | |
| } | |
| ], | |
| "__requires": [ | |
| { | |
| "type": "panel", | |
| "id": "digrich-bubblechart-panel", | |
| "name": "Bubble Chart", | |
| "version": "1.1.0" | |
| }, | |
| { | |
| "type": "grafana", | |
| "id": "grafana", | |
| "name": "Grafana", | |
| "version": "5.4.3" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "graph", | |
| "name": "Graph", | |
| "version": "5.0.0" | |
| }, | |
| { | |
| "type": "datasource", | |
| "id": "prometheus", | |
| "name": "Prometheus", | |
| "version": "5.0.0" | |
| } | |
| ], | |
| "annotations": { | |
| "list": [ | |
| { | |
| "builtIn": 1, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "enable": true, | |
| "hide": true, | |
| "iconColor": "rgba(0, 211, 255, 1)", | |
| "name": "Annotations & Alerts", | |
| "type": "dashboard" | |
| }, | |
| { | |
| "datasource": "${DS_PROMETHEUS}", | |
| "enable": true, | |
| "expr": "5", | |
| "hide": false, | |
| "iconColor": "rgba(255, 96, 96, 1)", | |
| "limit": 100, | |
| "name": "Config Reloads", | |
| "showIn": 0, | |
| "step": "30s", | |
| "tagKeys": "controller_class", | |
| "tags": [], | |
| "titleFormat": "Config Reloaded", | |
| "type": "tags" | |
| } | |
| ] | |
| }, | |
| "editable": true, | |
| "gnetId": null, | |
| "graphTooltip": 0, | |
| "id": null, | |
| "links": [], | |
| "panels": [ | |
| { | |
| "alert": { | |
| "conditions": [ | |
| { | |
| "evaluator": { | |
| "params": [ | |
| 0.2 | |
| ], | |
| "type": "gt" | |
| }, | |
| "operator": { | |
| "type": "and" | |
| }, | |
| "query": { | |
| "params": [ | |
| "A", | |
| "5m", | |
| "now" | |
| ] | |
| }, | |
| "reducer": { | |
| "params": [], | |
| "type": "avg" | |
| }, | |
| "type": "query" | |
| } | |
| ], | |
| "executionErrorState": "alerting", | |
| "for": "1m", | |
| "frequency": "10s", | |
| "handler": 1, | |
| "name": "Pools Max Waiting Time alert", | |
| "noDataState": "no_data", | |
| "notifications": [] | |
| }, | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "fill": 0, | |
| "gridPos": { | |
| "h": 12, | |
| "w": 12, | |
| "x": 0, | |
| "y": 0 | |
| }, | |
| "id": 12, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": false, | |
| "current": true, | |
| "hideEmpty": true, | |
| "hideZero": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "avg(max_over_time(pgbouncer_exporter_pools_max_wait{user!='pgbouncer'}[1m])) by (database,instance)", | |
| "format": "time_series", | |
| "hide": false, | |
| "intervalFactor": 1, | |
| "legendFormat": "{{database}}@{{instance}}", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": [ | |
| { | |
| "colorMode": "critical", | |
| "fill": true, | |
| "line": true, | |
| "op": "gt", | |
| "value": 0.2 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Pools Max Waiting Time", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 2, | |
| "value_type": "individual" | |
| }, | |
| "transparent": false, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "fill": 0, | |
| "gridPos": { | |
| "h": 12, | |
| "w": 12, | |
| "x": 12, | |
| "y": 0 | |
| }, | |
| "id": 8, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": false, | |
| "current": true, | |
| "hideEmpty": true, | |
| "hideZero": false, | |
| "max": true, | |
| "min": true, | |
| "rightSide": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "null as zero", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "avg(pgbouncer_exporter_pools_active_clients{database!='pgbouncer'}) by (database,instance)", | |
| "format": "time_series", | |
| "hide": false, | |
| "intervalFactor": 1, | |
| "legendFormat": "{{database}}@{{instance}}", | |
| "refId": "A" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Active Client Connections", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 2, | |
| "value_type": "individual" | |
| }, | |
| "transparent": false, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "alert": { | |
| "conditions": [ | |
| { | |
| "evaluator": { | |
| "params": [ | |
| 40 | |
| ], | |
| "type": "gt" | |
| }, | |
| "operator": { | |
| "type": "and" | |
| }, | |
| "query": { | |
| "params": [ | |
| "A", | |
| "5m", | |
| "now" | |
| ] | |
| }, | |
| "reducer": { | |
| "params": [], | |
| "type": "avg" | |
| }, | |
| "type": "query" | |
| } | |
| ], | |
| "executionErrorState": "alerting", | |
| "for": "1m", | |
| "frequency": "15s", | |
| "handler": 1, | |
| "name": "Waiting Clients alert", | |
| "noDataState": "no_data", | |
| "notifications": [] | |
| }, | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "fill": 0, | |
| "gridPos": { | |
| "h": 12, | |
| "w": 12, | |
| "x": 0, | |
| "y": 12 | |
| }, | |
| "id": 4, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": false, | |
| "current": true, | |
| "hideEmpty": true, | |
| "max": true, | |
| "min": true, | |
| "rightSide": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "avg(avg_over_time(pgbouncer_exporter_pools_waiting_clients{user!='pgbouncer'}[30s])) by (instance, database)", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "interval": "10s", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{ database }}@{{ instance }}", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": [ | |
| { | |
| "colorMode": "critical", | |
| "fill": true, | |
| "line": true, | |
| "op": "gt", | |
| "value": 40 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Waiting Clients", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 1, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| }, | |
| { | |
| "bgColor": null, | |
| "colorScheme": "Unique", | |
| "datasource": "${DS_PROMETHEUS}", | |
| "decimal": 2, | |
| "displayLabel": true, | |
| "format": "short", | |
| "gradientColors": [ | |
| "red", | |
| "green" | |
| ], | |
| "gradientThresholds": "50,80", | |
| "gridPos": { | |
| "h": 12, | |
| "w": 12, | |
| "x": 12, | |
| "y": 12 | |
| }, | |
| "groupDepthColors": [ | |
| "hsl(152,80%,80%)", | |
| "hsl(228,30%,40%)" | |
| ], | |
| "groupSeperator": ",", | |
| "height": 400, | |
| "id": 14, | |
| "links": [], | |
| "mode": "time", | |
| "nullPointMode": "connected", | |
| "svgBubbleId": "svg_14", | |
| "svgContainer": {}, | |
| "targets": [ | |
| { | |
| "expr": "avg(pgbouncer_exporter_pools_active_clients) by (database,instance)", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "intervalFactor": 1, | |
| "legendFormat": "{{database}}@{{instance}}", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholdColors": [ | |
| "green", | |
| "yellow", | |
| "red" | |
| ], | |
| "thresholds": "50,80", | |
| "title": "", | |
| "transparent": true, | |
| "type": "digrich-bubblechart-panel", | |
| "valueName": "current" | |
| }, | |
| { | |
| "alert": { | |
| "conditions": [ | |
| { | |
| "evaluator": { | |
| "params": [ | |
| 40 | |
| ], | |
| "type": "gt" | |
| }, | |
| "operator": { | |
| "type": "and" | |
| }, | |
| "query": { | |
| "params": [ | |
| "A", | |
| "5m", | |
| "now" | |
| ] | |
| }, | |
| "reducer": { | |
| "params": [], | |
| "type": "avg" | |
| }, | |
| "type": "query" | |
| } | |
| ], | |
| "executionErrorState": "alerting", | |
| "for": "1m", | |
| "frequency": "15s", | |
| "handler": 1, | |
| "name": "Active Server Connections alert", | |
| "noDataState": "no_data", | |
| "notifications": [] | |
| }, | |
| "aliasColors": {}, | |
| "bars": false, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_PROMETHEUS}", | |
| "fill": 1, | |
| "gridPos": { | |
| "h": 12, | |
| "w": 12, | |
| "x": 0, | |
| "y": 24 | |
| }, | |
| "id": 2, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": false, | |
| "current": true, | |
| "hideEmpty": true, | |
| "max": true, | |
| "min": true, | |
| "rightSide": true, | |
| "show": true, | |
| "total": false, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "expr": "avg(avg_over_time(pgbouncer_exporter_pools_active_server{database!='pgbouncer'}[10s])) by (database,instance)", | |
| "format": "time_series", | |
| "groupBy": [ | |
| { | |
| "params": [ | |
| "$__interval" | |
| ], | |
| "type": "time" | |
| }, | |
| { | |
| "params": [ | |
| "null" | |
| ], | |
| "type": "fill" | |
| } | |
| ], | |
| "hide": false, | |
| "interval": "1s", | |
| "intervalFactor": 1, | |
| "legendFormat": "{{database}}@{{instance}}", | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": [ | |
| "value" | |
| ], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [] | |
| } | |
| ], | |
| "thresholds": [ | |
| { | |
| "colorMode": "critical", | |
| "fill": true, | |
| "line": true, | |
| "op": "gt", | |
| "value": 40 | |
| } | |
| ], | |
| "timeFrom": null, | |
| "timeRegions": [], | |
| "timeShift": null, | |
| "title": "Active Server Connections", | |
| "tooltip": { | |
| "shared": true, | |
| "sort": 1, | |
| "value_type": "individual" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": "0", | |
| "show": true | |
| }, | |
| { | |
| "format": "short", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": false | |
| } | |
| ], | |
| "yaxis": { | |
| "align": false, | |
| "alignLevel": null | |
| } | |
| } | |
| ], | |
| "refresh": "10s", | |
| "schemaVersion": 16, | |
| "style": "dark", | |
| "tags": [ | |
| "DB", | |
| "pgbouncer" | |
| ], | |
| "templating": { | |
| "list": [] | |
| }, | |
| "time": { | |
| "from": "now-1h", | |
| "to": "now" | |
| }, | |
| "timepicker": { | |
| "refresh_intervals": [ | |
| "5s", | |
| "10s", | |
| "30s", | |
| "1m", | |
| "5m", | |
| "15m", | |
| "30m", | |
| "1h", | |
| "2h", | |
| "1d" | |
| ], | |
| "time_options": [ | |
| "5m", | |
| "15m", | |
| "1h", | |
| "6h", | |
| "12h", | |
| "24h", | |
| "2d", | |
| "7d", | |
| "30d" | |
| ] | |
| }, | |
| "timezone": "", | |
| "title": "Pgbouncer Monitoring", | |
| "uid": "3TqFt0_mz", | |
| "version": 5 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment