Add Histogram Relays ratio dashboard

Closes tpo/network-health/metrics/monitoring-and-alerting#31 (closed)

network-health/relays-histogram-ratio.json

+{
+  "__inputs": [],
+  "annotations": {
+    "list": []
+  },
+  "description": "",
+  "editable": true,
+  "gnetId": null,
+  "graphTooltip": 0,
+  "hideControls": false,
+  "id": null,
+  "links": [],
+  "panels": [],
+  "refresh": "10s",
+  "rows": [
+    {
+      "collapse": false,
+      "editable": true,
+      "height": "250px",
+      "panels": [
+        {
+          "cacheTimeout": null,
+          "datasource": "grafana-postgresql-datasource",
+          "description": null,
+          "editable": true,
+          "error": false,
+          "fieldConfig": {
+            "defaults": {
+              "color": {
+                "mode": "thresholds"
+              },
+              "custom": {
+                "fillOpacity": 80,
+                "lineWidth": 0
+              },
+              "mappings": [],
+              "thresholds": {
+                "mode": "absolute",
+                "steps": []
+              }
+            },
+            "overrides": []
+          },
+          "gridPos": null,
+          "height": null,
+          "hideTimeOverride": false,
+          "id": 1,
+          "interval": null,
+          "links": [],
+          "maxDataPoints": 100,
+          "maxPerRow": null,
+          "minSpan": null,
+          "options": {
+            "bucketOffset": 0,
+            "bucketSize": 0.05,
+            "combine": false,
+            "legend": {
+              "displayMode": "list",
+              "placement": "bottom"
+            }
+          },
+          "repeat": null,
+          "repeatDirection": null,
+          "span": 6,
+          "targets": [
+            {
+              "datasource": "grafana-postgresql-datasource",
+              "expr": "",
+              "format": "table",
+              "hide": false,
+              "instant": false,
+              "interval": "",
+              "intervalFactor": 2,
+              "legendFormat": "",
+              "metric": "",
+              "query": "",
+              "rawQuery": true,
+              "rawSql": "\n    SELECT DISTINCT\n        node_id,\n        AVG(GREATEST(r_strm, r_strm_filt)) AS ratio_bastet\n    FROM bandwidth_record \n    INNER JOIN bandwidth_file\n    ON bandwidth_record.bandwidth_file = bandwidth_file.digest WHERE $__timeFilter(time) \n    AND bandwidth_file.scanner_country='US'\n    AND bandwidth_file.software_version='1.8.1' GROUP BY node_id ORDER BY ratio_bastet",
+              "refId": "",
+              "step": 10,
+              "target": ""
+            }
+          ],
+          "timeFrom": null,
+          "timeShift": null,
+          "title": "Histogram Relays ratio bastet",
+          "transformations": [],
+          "transparent": false,
+          "type": "histogram"
+        },
+        {
+          "cacheTimeout": null,
+          "datasource": "grafana-postgresql-datasource",
+          "description": null,
+          "editable": true,
+          "error": false,
+          "fieldConfig": {
+            "defaults": {
+              "color": {
+                "mode": "thresholds"
+              },
+              "custom": {
+                "fillOpacity": 80,
+                "lineWidth": 0
+              },
+              "mappings": [],
+              "thresholds": {
+                "mode": "absolute",
+                "steps": []
+              }
+            },
+            "overrides": []
+          },
+          "gridPos": null,
+          "height": null,
+          "hideTimeOverride": false,
+          "id": 2,
+          "interval": null,
+          "links": [],
+          "maxDataPoints": 100,
+          "maxPerRow": null,
+          "minSpan": null,
+          "options": {
+            "bucketOffset": 0,
+            "bucketSize": 0.05,
+            "combine": false,
+            "legend": {
+              "displayMode": "list",
+              "placement": "bottom"
+            }
+          },
+          "repeat": null,
+          "repeatDirection": null,
+          "span": 6,
+          "targets": [
+            {
+              "datasource": "grafana-postgresql-datasource",
+              "expr": "",
+              "format": "table",
+              "hide": false,
+              "instant": false,
+              "interval": "",
+              "intervalFactor": 2,
+              "legendFormat": "",
+              "metric": "",
+              "query": "",
+              "rawQuery": true,
+              "rawSql": "\n    SELECT DISTINCT\n        node_id,\n        AVG(GREATEST(r_strm, r_strm_filt)) AS ratio_gabelmoo\n    FROM bandwidth_record \n    INNER JOIN bandwidth_file\n    ON bandwidth_record.bandwidth_file = bandwidth_file.digest WHERE $__timeFilter(time) AND bandwidth_file.scanner_country='DE' GROUP BY node_id ORDER BY ratio_gabelmoo",
+              "refId": "",
+              "step": 10,
+              "target": ""
+            }
+          ],
+          "timeFrom": null,
+          "timeShift": null,
+          "title": "Histogram Relays ratio gabelmoo",
+          "transformations": [],
+          "transparent": false,
+          "type": "histogram"
+        }
+      ],
+      "repeat": null,
+      "showTitle": false,
+      "title": "New row"
+    },
+    {
+      "collapse": false,
+      "editable": true,
+      "height": "250px",
+      "panels": [
+        {
+          "cacheTimeout": null,
+          "datasource": "grafana-postgresql-datasource",
+          "description": null,
+          "editable": true,
+          "error": false,
+          "fieldConfig": {
+            "defaults": {
+              "color": {
+                "mode": "thresholds"
+              },
+              "custom": {
+                "fillOpacity": 80,
+                "lineWidth": 0
+              },
+              "mappings": [],
+              "thresholds": {
+                "mode": "absolute",
+                "steps": []
+              }
+            },
+            "overrides": []
+          },
+          "gridPos": null,
+          "height": null,
+          "hideTimeOverride": false,
+          "id": 3,
+          "interval": null,
+          "links": [],
+          "maxDataPoints": 100,
+          "maxPerRow": null,
+          "minSpan": null,
+          "options": {
+            "bucketOffset": 0,
+            "bucketSize": 0.05,
+            "combine": false,
+            "legend": {
+              "displayMode": "list",
+              "placement": "bottom"
+            }
+          },
+          "repeat": null,
+          "repeatDirection": null,
+          "span": 6,
+          "targets": [
+            {
+              "datasource": "grafana-postgresql-datasource",
+              "expr": "",
+              "format": "table",
+              "hide": false,
+              "instant": false,
+              "interval": "",
+              "intervalFactor": 2,
+              "legendFormat": "",
+              "metric": "",
+              "query": "",
+              "rawQuery": true,
+              "rawSql": "\n    SELECT DISTINCT\n        node_id,\n        AVG(GREATEST(r_strm, r_strm_filt)) AS ratio_longclaw\n    FROM bandwidth_record \n    INNER JOIN bandwidth_file\n    ON bandwidth_record.bandwidth_file = bandwidth_file.digest WHERE $__timeFilter(time) AND dirauth_nickname='longclaw' GROUP BY node_id ORDER BY ratio_longclaw",
+              "refId": "",
+              "step": 10,
+              "target": ""
+            }
+          ],
+          "timeFrom": null,
+          "timeShift": null,
+          "title": "Histogram Relays ratio longclaw",
+          "transformations": [],
+          "transparent": false,
+          "type": "histogram"
+        },
+        {
+          "cacheTimeout": null,
+          "datasource": "grafana-postgresql-datasource",
+          "description": null,
+          "editable": true,
+          "error": false,
+          "fieldConfig": {
+            "defaults": {
+              "color": {
+                "mode": "thresholds"
+              },
+              "custom": {
+                "fillOpacity": 80,
+                "lineWidth": 0
+              },
+              "mappings": [],
+              "thresholds": {
+                "mode": "absolute",
+                "steps": []
+              }
+            },
+            "overrides": []
+          },
+          "gridPos": null,
+          "height": null,
+          "hideTimeOverride": false,
+          "id": 4,
+          "interval": null,
+          "links": [],
+          "maxDataPoints": 100,
+          "maxPerRow": null,
+          "minSpan": null,
+          "options": {
+            "bucketOffset": 0,
+            "bucketSize": 0.05,
+            "combine": false,
+            "legend": {
+              "displayMode": "list",
+              "placement": "bottom"
+            }
+          },
+          "repeat": null,
+          "repeatDirection": null,
+          "span": 6,
+          "targets": [
+            {
+              "datasource": "grafana-postgresql-datasource",
+              "expr": "",
+              "format": "table",
+              "hide": false,
+              "instant": false,
+              "interval": "",
+              "intervalFactor": 2,
+              "legendFormat": "",
+              "metric": "",
+              "query": "",
+              "rawQuery": true,
+              "rawSql": "\n    SELECT DISTINCT\n        node_id,\n        AVG(GREATEST(r_strm, r_strm_filt)) AS ratio_maatuska\n    FROM bandwidth_record \n    INNER JOIN bandwidth_file\n    ON bandwidth_record.bandwidth_file = bandwidth_file.digest WHERE $__timeFilter(time) AND bandwidth_file.scanner_country='SE' GROUP BY node_id ORDER BY ratio_maatuska",
+              "refId": "",
+              "step": 10,
+              "target": ""
+            }
+          ],
+          "timeFrom": null,
+          "timeShift": null,
+          "title": "Histogram Relays ratio maatuska",
+          "transformations": [],
+          "transparent": false,
+          "type": "histogram"
+        }
+      ],
+      "repeat": null,
+      "showTitle": false,
+      "title": "New row"
+    },
+    {
+      "collapse": false,
+      "editable": true,
+      "height": "250px",
+      "panels": [
+        {
+          "cacheTimeout": null,
+          "datasource": "grafana-postgresql-datasource",
+          "description": null,
+          "editable": true,
+          "error": false,
+          "fieldConfig": {
+            "defaults": {
+              "color": {
+                "mode": "thresholds"
+              },
+              "custom": {
+                "fillOpacity": 80,
+                "lineWidth": 0
+              },
+              "mappings": [],
+              "thresholds": {
+                "mode": "absolute",
+                "steps": []
+              }
+            },
+            "overrides": []
+          },
+          "gridPos": null,
+          "height": null,
+          "hideTimeOverride": false,
+          "id": 5,
+          "interval": null,
+          "links": [],
+          "maxDataPoints": 100,
+          "maxPerRow": null,
+          "minSpan": null,
+          "options": {
+            "bucketOffset": 0,
+            "bucketSize": 0.05,
+            "combine": false,
+            "legend": {
+              "displayMode": "list",
+              "placement": "bottom"
+            }
+          },
+          "repeat": null,
+          "repeatDirection": null,
+          "span": 12,
+          "targets": [
+            {
+              "datasource": "grafana-postgresql-datasource",
+              "expr": "",
+              "format": "table",
+              "hide": false,
+              "instant": false,
+              "interval": "",
+              "intervalFactor": 2,
+              "legendFormat": "",
+              "metric": "",
+              "query": "",
+              "rawQuery": true,
+              "rawSql": "\n    SELECT DISTINCT\n        node_id,\n        AVG(GREATEST(r_strm, r_strm_filt)) AS ratio_moria1\n    FROM bandwidth_record \n    INNER JOIN bandwidth_file\n    ON bandwidth_record.bandwidth_file = bandwidth_file.digest WHERE $__timeFilter(time) \n    AND bandwidth_file.software_version='1.5.2' GROUP BY node_id ORDER BY ratio_moria1",
+              "refId": "",
+              "step": 10,
+              "target": ""
+            }
+          ],
+          "timeFrom": null,
+          "timeShift": null,
+          "title": "Histogram Relays ratio moria1",
+          "transformations": [],
+          "transparent": false,
+          "type": "histogram"
+        }
+      ],
+      "repeat": null,
+      "showTitle": false,
+      "title": "New row"
+    }
+  ],
+  "schemaVersion": 12,
+  "sharedCrosshair": false,
+  "style": "dark",
+  "tags": [
+    "provisioned"
+  ],
+  "templating": {
+    "list": []
+  },
+  "time": {
+    "from": "2024-01-29 10:56:13",
+    "to": "2024-01-31 10:56:13"
+  },
+  "timepicker": {
+    "hidden": false,
+    "refresh_intervals": [
+      "5s",
+      "10s",
+      "30s",
+      "1m",
+      "5m",
+      "15m",
+      "30m",
+      "1h",
+      "2h",
+      "1d"
+    ],
+    "time_options": [
+      "5m",
+      "15m",
+      "1h",
+      "6h",
+      "12h",
+      "24h",
+      "2d",
+      "7d",
+      "30d"
+    ]
+  },
+  "timezone": "utc",
+  "title": "Histogram Relays ratio",
+  "uid": "histogram-ratio",
+  "version": 0
+}
\ No newline at end of file