diff options
author | Boss Marco <bossm8@bfh.ch> | 2022-05-25 13:45:50 +0200 |
---|---|---|
committer | Boss Marco <bossm8@bfh.ch> | 2022-05-25 13:45:50 +0200 |
commit | 2c3d3c1680868343d26b37a9e00f092bcc5582b0 (patch) | |
tree | 247a1d23ff067f494d3abae3a2339fb6286023da | |
parent | 1e9d072a65c6455ca26ceb19406c658b37fa57bf (diff) | |
download | grid5k-2c3d3c1680868343d26b37a9e00f092bcc5582b0.tar.gz grid5k-2c3d3c1680868343d26b37a9e00f092bcc5582b0.tar.bz2 grid5k-2c3d3c1680868343d26b37a9e00f092bcc5582b0.zip |
added new panels for db statistics
-rw-r--r-- | additional/grafana/database.json | 1181 | ||||
-rw-r--r-- | additional/grafana/transactions.json | 202 |
2 files changed, 1223 insertions, 160 deletions
diff --git a/additional/grafana/database.json b/additional/grafana/database.json index 1d3140a..db3f318 100644 --- a/additional/grafana/database.json +++ b/additional/grafana/database.json @@ -15,7 +15,7 @@ "type": "grafana", "id": "grafana", "name": "Grafana", - "version": "8.4.3" + "version": "8.4.6" }, { "type": "panel", @@ -37,6 +37,12 @@ }, { "type": "panel", + "id": "table", + "name": "Table", + "version": "" + }, + { + "type": "panel", "id": "timeseries", "name": "Time series", "version": "" @@ -67,7 +73,7 @@ "gnetId": 6742, "graphTooltip": 1, "id": null, - "iteration": 1649441739195, + "iteration": 1653478495743, "links": [], "liveNow": false, "panels": [ @@ -143,7 +149,7 @@ "text": {}, "textMode": "name" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -221,7 +227,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -271,7 +277,7 @@ } ] }, - "unit": "bytes" + "unit": "none" }, "overrides": [] }, @@ -281,7 +287,7 @@ "x": 6, "y": 1 }, - "id": 56, + "id": 64, "links": [], "maxDataPoints": 100, "options": { @@ -291,7 +297,7 @@ "orientation": "horizontal", "reduceOptions": { "calcs": [ - "lastNotNull" + "mean" ], "fields": "", "values": false @@ -299,11 +305,11 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, - "expr": "pg_settings_shared_buffers_bytes{instance=\"$instance\", server=\"$server\"}", + "expr": "pg_settings_max_worker_processes{instance=\"$instance\", server=\"$server\"}", "format": "time_series", "instant": true, "interval": "", @@ -312,7 +318,7 @@ "refId": "A" } ], - "title": "Shared Buffers", + "title": "Max Worker Processes", "type": "stat" }, { @@ -349,7 +355,7 @@ } ] }, - "unit": "bytes" + "unit": "none" }, "overrides": [] }, @@ -359,7 +365,7 @@ "x": 9, "y": 1 }, - "id": 58, + "id": 68, "links": [], "maxDataPoints": 100, "options": { @@ -377,11 +383,11 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, - "expr": "pg_settings_effective_cache_size_bytes{instance=\"$instance\", server=\"$server\"}", + "expr": "pg_settings_max_parallel_workers{instance=\"$instance\", server=\"$server\"}", "format": "time_series", "instant": true, "interval": "", @@ -390,7 +396,7 @@ "refId": "A" } ], - "title": "Effective Cache", + "title": "Max Parallel Workers", "type": "stat" }, { @@ -455,7 +461,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -533,7 +539,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -612,7 +618,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -691,7 +697,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -769,7 +775,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -847,7 +853,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -897,7 +903,7 @@ } ] }, - "unit": "none" + "unit": "bytes" }, "overrides": [] }, @@ -907,7 +913,7 @@ "x": 6, "y": 4 }, - "id": 64, + "id": 56, "links": [], "maxDataPoints": 100, "options": { @@ -917,7 +923,7 @@ "orientation": "horizontal", "reduceOptions": { "calcs": [ - "mean" + "lastNotNull" ], "fields": "", "values": false @@ -925,11 +931,11 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, - "expr": "pg_settings_max_worker_processes{instance=\"$instance\", server=\"$server\"}", + "expr": "pg_settings_shared_buffers_bytes{instance=\"$instance\", server=\"$server\"}", "format": "time_series", "instant": true, "interval": "", @@ -938,7 +944,7 @@ "refId": "A" } ], - "title": "Max Worker Processes", + "title": "Shared Buffers", "type": "stat" }, { @@ -975,7 +981,7 @@ } ] }, - "unit": "none" + "unit": "bytes" }, "overrides": [] }, @@ -985,7 +991,7 @@ "x": 9, "y": 4 }, - "id": 68, + "id": 58, "links": [], "maxDataPoints": 100, "options": { @@ -1003,11 +1009,11 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, - "expr": "pg_settings_max_parallel_workers{instance=\"$instance\", server=\"$server\"}", + "expr": "pg_settings_effective_cache_size_bytes{instance=\"$instance\", server=\"$server\"}", "format": "time_series", "instant": true, "interval": "", @@ -1016,7 +1022,7 @@ "refId": "A" } ], - "title": "Max Parallel Workers", + "title": "Effective Cache", "type": "stat" }, { @@ -1064,7 +1070,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -1122,7 +1128,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -1180,7 +1186,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -1254,7 +1260,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "exemplar": true, @@ -1411,7 +1417,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -1512,7 +1518,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -1612,7 +1618,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -1727,7 +1733,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -1812,7 +1818,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -1870,12 +1876,1068 @@ } }, { + "description": "", + "fieldConfig": { + "defaults": { + "color": { + "mode": "thresholds" + }, + "custom": { + "align": "auto", + "displayMode": "auto" + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "red", + "value": 80 + } + ] + } + }, + "overrides": [] + }, + "gridPos": { + "h": 10, + "w": 12, + "x": 0, + "y": 34 + }, + "id": 103, + "options": { + "footer": { + "fields": "", + "reducer": [ + "sum" + ], + "show": false + }, + "frameIndex": 6, + "showHeader": true + }, + "pluginVersion": "8.4.6", + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "rate(pg_wait_events_count{} [5m])", + "interval": "", + "legendFormat": "", + "refId": "A" + } + ], + "title": "Wait Events", + "transformations": [ + { + "id": "labelsToFields", + "options": { + "keepLabels": [ + "wait_event", + "wait_event_type" + ] + } + }, + { + "id": "groupBy", + "options": { + "fields": { + "Value": { + "aggregations": [ + "sum" + ], + "operation": "aggregate" + }, + "wait_event": { + "aggregations": [], + "operation": "groupby" + }, + "wait_event_type": { + "aggregations": [], + "operation": "groupby" + } + } + } + }, + { + "id": "merge", + "options": {} + }, + { + "id": "organize", + "options": { + "excludeByName": {}, + "indexByName": { + "Value (sum)": 2, + "wait_event": 1, + "wait_event_type": 0 + }, + "renameByName": { + "Value (sum)": "Count per Second", + "wait_event": "Event", + "wait_event_type": "Type" + } + } + }, + { + "id": "sortBy", + "options": { + "fields": {}, + "sort": [ + { + "desc": true, + "field": "Count per Second" + } + ] + } + } + ], + "type": "table" + }, + { "collapsed": false, "gridPos": { "h": 1, "w": 24, "x": 0, - "y": 34 + "y": 44 + }, + "id": 92, + "panels": [], + "title": "Table Statistics", + "type": "row" + }, + { + "description": "", + "fieldConfig": { + "defaults": { + "color": { + "mode": "palette-classic" + }, + "custom": { + "axisLabel": "", + "axisPlacement": "auto", + "barAlignment": 0, + "drawStyle": "line", + "fillOpacity": 0, + "gradientMode": "none", + "hideFrom": { + "legend": false, + "tooltip": false, + "viz": false + }, + "lineInterpolation": "linear", + "lineWidth": 1, + "pointSize": 5, + "scaleDistribution": { + "type": "linear" + }, + "showPoints": "auto", + "spanNulls": false, + "stacking": { + "group": "A", + "mode": "none" + }, + "thresholdsStyle": { + "mode": "off" + } + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "red", + "value": 80 + } + ] + } + }, + "overrides": [ + { + "__systemRef": "hideSeriesFrom", + "matcher": { + "id": "byNames", + "options": { + "mode": "exclude", + "names": [ + "Value" + ], + "prefix": "All except:", + "readOnly": true + } + }, + "properties": [ + { + "id": "custom.hideFrom", + "value": { + "legend": false, + "tooltip": false, + "viz": true + } + } + ] + } + ] + }, + "gridPos": { + "h": 8, + "w": 12, + "x": 0, + "y": 45 + }, + "id": 94, + "options": { + "legend": { + "calcs": [], + "displayMode": "table", + "placement": "bottom" + }, + "tooltip": { + "mode": "single", + "sort": "none" + } + }, + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "sum by (relnamenew) (label_replace(rate(pg_stat_user_tables_seq_scan{} [5m]), \"relnamenew\", \"$1\", \"relname\", \"(.*[^_0-9])(_[0-9]+)*\"))", + "hide": false, + "interval": "", + "legendFormat": "{{ relnamenew }}", + "refId": "B" + } + ], + "title": "Sequential Scans per Second", + "transformations": [], + "type": "timeseries" + }, + { + "description": "", + "fieldConfig": { + "defaults": { + "color": { + "mode": "palette-classic" + }, + "custom": { + "axisLabel": "", + "axisPlacement": "auto", + "barAlignment": 0, + "drawStyle": "line", + "fillOpacity": 0, + "gradientMode": "none", + "hideFrom": { + "legend": false, + "tooltip": false, + "viz": false + }, + "lineInterpolation": "linear", + "lineWidth": 1, + "pointSize": 5, + "scaleDistribution": { + "type": "linear" + }, + "showPoints": "auto", + "spanNulls": false, + "stacking": { + "group": "A", + "mode": "none" + }, + "thresholdsStyle": { + "mode": "off" + } + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "red", + "value": 80 + } + ] + } + }, + "overrides": [ + { + "__systemRef": "hideSeriesFrom", + "matcher": { + "id": "byNames", + "options": { + "mode": "exclude", + "names": [ + "Value" + ], + "prefix": "All except:", + "readOnly": true + } + }, + "properties": [ + { + "id": "custom.hideFrom", + "value": { + "legend": false, + "tooltip": false, + "viz": true + } + } + ] + } + ] + }, + "gridPos": { + "h": 8, + "w": 12, + "x": 12, + "y": 45 + }, + "id": 95, + "options": { + "legend": { + "calcs": [], + "displayMode": "table", + "placement": "bottom" + }, + "tooltip": { + "mode": "single", + "sort": "none" + } + }, + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "sum by (relnamenew) (label_replace(rate(pg_stat_user_tables_idx_scan{} [5m]), \"relnamenew\", \"$1\", \"relname\", \"(.*[^_0-9])(_[0-9]+)*\"))", + "hide": false, + "interval": "", + "legendFormat": "{{ relnamenew }}", + "refId": "B" + } + ], + "title": "Index Scans per Second", + "transformations": [], + "type": "timeseries" + }, + { + "description": "", + "fieldConfig": { + "defaults": { + "color": { + "mode": "palette-classic" + }, + "custom": { + "axisLabel": "", + "axisPlacement": "auto", + "barAlignment": 0, + "drawStyle": "line", + "fillOpacity": 0, + "gradientMode": "none", + "hideFrom": { + "legend": false, + "tooltip": false, + "viz": false + }, + "lineInterpolation": "linear", + "lineWidth": 1, + "pointSize": 5, + "scaleDistribution": { + "type": "linear" + }, + "showPoints": "auto", + "spanNulls": false, + "stacking": { + "group": "A", + "mode": "none" + }, + "thresholdsStyle": { + "mode": "off" + } + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "red", + "value": 80 + } + ] + } + }, + "overrides": [ + { + "__systemRef": "hideSeriesFrom", + "matcher": { + "id": "byNames", + "options": { + "mode": "exclude", + "names": [ + "Value" + ], + "prefix": "All except:", + "readOnly": true + } + }, + "properties": [ + { + "id": "custom.hideFrom", + "value": { + "legend": false, + "tooltip": false, + "viz": true + } + } + ] + } + ] + }, + "gridPos": { + "h": 8, + "w": 12, + "x": 0, + "y": 53 + }, + "id": 98, + "options": { + "legend": { + "calcs": [], + "displayMode": "table", + "placement": "bottom" + }, + "tooltip": { + "mode": "single", + "sort": "none" + } + }, + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "sum by (relnamenew) (label_replace(rate(pg_stat_user_tables_n_live_tup{} [5m]), \"relnamenew\", \"$1\", \"relname\", \"(.*[^_0-9])(_[0-9]+)*\"))", + "hide": false, + "interval": "", + "legendFormat": "{{ relnamenew }}", + "refId": "B" + } + ], + "title": "Live Tuples (rate)", + "transformations": [], + "type": "timeseries" + }, + { + "description": "", + "fieldConfig": { + "defaults": { + "color": { + "mode": "palette-classic" + }, + "custom": { + "axisLabel": "", + "axisPlacement": "auto", + "barAlignment": 0, + "drawStyle": "line", + "fillOpacity": 0, + "gradientMode": "none", + "hideFrom": { + "legend": false, + "tooltip": false, + "viz": false + }, + "lineInterpolation": "linear", + "lineWidth": 1, + "pointSize": 5, + "scaleDistribution": { + "type": "linear" + }, + "showPoints": "auto", + "spanNulls": false, + "stacking": { + "group": "A", + "mode": "none" + }, + "thresholdsStyle": { + "mode": "off" + } + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "red", + "value": 80 + } + ] + } + }, + "overrides": [ + { + "__systemRef": "hideSeriesFrom", + "matcher": { + "id": "byNames", + "options": { + "mode": "exclude", + "names": [ + "Value" + ], + "prefix": "All except:", + "readOnly": true + } + }, + "properties": [ + { + "id": "custom.hideFrom", + "value": { + "legend": false, + "tooltip": false, + "viz": true + } + } + ] + } + ] + }, + "gridPos": { + "h": 8, + "w": 12, + "x": 12, + "y": 53 + }, + "id": 96, + "options": { + "legend": { + "calcs": [], + "displayMode": "table", + "placement": "bottom" + }, + "tooltip": { + "mode": "single", + "sort": "none" + } + }, + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "sum by (relnamenew) (label_replace(rate(pg_stat_user_tables_n_dead_tup{} [5m]), \"relnamenew\", \"$1\", \"relname\", \"(.*[^_0-9])(_[0-9]+)*\"))", + "hide": false, + "interval": "", + "legendFormat": "{{ relnamenew }}", + "refId": "B" + }, + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "", + "hide": false, + "interval": "", + "legendFormat": "", + "refId": "A" + } + ], + "title": "Dead Tuples (rate)", + "transformations": [], + "type": "timeseries" + }, + { + "description": "", + "fieldConfig": { + "defaults": { + "color": { + "mode": "palette-classic" + }, + "custom": { + "axisLabel": "", + "axisPlacement": "auto", + "barAlignment": 0, + "drawStyle": "line", + "fillOpacity": 0, + "gradientMode": "none", + "hideFrom": { + "legend": false, + "tooltip": false, + "viz": false + }, + "lineInterpolation": "linear", + "lineWidth": 1, + "pointSize": 5, + "scaleDistribution": { + "type": "linear" + }, + "showPoints": "auto", + "spanNulls": false, + "stacking": { + "group": "A", + "mode": "none" + }, + "thresholdsStyle": { + "mode": "off" + } + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "red", + "value": 80 + } + ] + } + }, + "overrides": [ + { + "__systemRef": "hideSeriesFrom", + "matcher": { + "id": "byNames", + "options": { + "mode": "exclude", + "names": [ + "Value" + ], + "prefix": "All except:", + "readOnly": true + } + }, + "properties": [ + { + "id": "custom.hideFrom", + "value": { + "legend": false, + "tooltip": false, + "viz": true + } + } + ] + } + ] + }, + "gridPos": { + "h": 8, + "w": 12, + "x": 0, + "y": 61 + }, + "id": 100, + "options": { + "legend": { + "calcs": [], + "displayMode": "table", + "placement": "bottom" + }, + "tooltip": { + "mode": "single", + "sort": "none" + } + }, + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "sum by (relnamenew) (label_replace(rate(pg_stat_user_tables_n_tup_upd{} [5m]), \"relnamenew\", \"$1\", \"relname\", \"(.*[^_0-9])(_[0-9]+)*\"))", + "hide": false, + "interval": "", + "legendFormat": "{{ relnamenew }}", + "refId": "B" + } + ], + "title": "Updates per Second (HOT Included)", + "transformations": [], + "type": "timeseries" + }, + { + "description": "", + "fieldConfig": { + "defaults": { + "color": { + "mode": "palette-classic" + }, + "custom": { + "axisLabel": "", + "axisPlacement": "auto", + "barAlignment": 0, + "drawStyle": "line", + "fillOpacity": 0, + "gradientMode": "none", + "hideFrom": { + "legend": false, + "tooltip": false, + "viz": false + }, + "lineInterpolation": "linear", + "lineWidth": 1, + "pointSize": 5, + "scaleDistribution": { + "type": "linear" + }, + "showPoints": "auto", + "spanNulls": false, + "stacking": { + "group": "A", + "mode": "none" + }, + "thresholdsStyle": { + "mode": "off" + } + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "red", + "value": 80 + } + ] + } + }, + "overrides": [ + { + "__systemRef": "hideSeriesFrom", + "matcher": { + "id": "byNames", + "options": { + "mode": "exclude", + "names": [ + "Value" + ], + "prefix": "All except:", + "readOnly": true + } + }, + "properties": [ + { + "id": "custom.hideFrom", + "value": { + "legend": false, + "tooltip": false, + "viz": true + } + } + ] + } + ] + }, + "gridPos": { + "h": 8, + "w": 12, + "x": 12, + "y": 61 + }, + "id": 99, + "options": { + "legend": { + "calcs": [], + "displayMode": "table", + "placement": "bottom" + }, + "tooltip": { + "mode": "single", + "sort": "none" + } + }, + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "sum by (relnamenew) (label_replace(rate(pg_stat_user_tables_n_tup_hot_upd{} [5m]), \"relnamenew\", \"$1\", \"relname\", \"(.*[^_0-9])(_[0-9]+)*\"))", + "hide": false, + "interval": "", + "legendFormat": "{{ relnamenew }}", + "refId": "B" + } + ], + "title": "Hot Updates per Second", + "transformations": [], + "type": "timeseries" + }, + { + "description": "", + "fieldConfig": { + "defaults": { + "color": { + "mode": "palette-classic" + }, + "custom": { + "axisLabel": "", + "axisPlacement": "auto", + "barAlignment": 0, + "drawStyle": "line", + "fillOpacity": 0, + "gradientMode": "none", + "hideFrom": { + "legend": false, + "tooltip": false, + "viz": false + }, + "lineInterpolation": "linear", + "lineWidth": 1, + "pointSize": 5, + "scaleDistribution": { + "type": "linear" + }, + "showPoints": "auto", + "spanNulls": false, + "stacking": { + "group": "A", + "mode": "none" + }, + "thresholdsStyle": { + "mode": "off" + } + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "red", + "value": 80 + } + ] + } + }, + "overrides": [ + { + "__systemRef": "hideSeriesFrom", + "matcher": { + "id": "byNames", + "options": { + "mode": "exclude", + "names": [ + "Value" + ], + "prefix": "All except:", + "readOnly": true + } + }, + "properties": [ + { + "id": "custom.hideFrom", + "value": { + "legend": false, + "tooltip": false, + "viz": true + } + } + ] + } + ] + }, + "gridPos": { + "h": 8, + "w": 12, + "x": 0, + "y": 69 + }, + "id": 97, + "options": { + "legend": { + "calcs": [], + "displayMode": "table", + "placement": "bottom" + }, + "tooltip": { + "mode": "single", + "sort": "none" + } + }, + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "sum by (relnamenew) (label_replace(rate(pg_stat_user_tables_autovacuum_count{} [5m]), \"relnamenew\", \"$1\", \"relname\", \"(.*[^_0-9])(_[0-9]+)*\"))", + "hide": false, + "interval": "", + "legendFormat": "{{ relnamenew }}", + "refId": "B" + } + ], + "title": "Autovaccums per Second", + "transformations": [], + "type": "timeseries" + }, + { + "description": "", + "fieldConfig": { + "defaults": { + "color": { + "mode": "palette-classic" + }, + "custom": { + "axisLabel": "", + "axisPlacement": "auto", + "barAlignment": 0, + "drawStyle": "line", + "fillOpacity": 0, + "gradientMode": "none", + "hideFrom": { + "legend": false, + "tooltip": false, + "viz": false + }, + "lineInterpolation": "linear", + "lineWidth": 1, + "pointSize": 5, + "scaleDistribution": { + "type": "linear" + }, + "showPoints": "auto", + "spanNulls": false, + "stacking": { + "group": "A", + "mode": "none" + }, + "thresholdsStyle": { + "mode": "off" + } + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "red", + "value": 80 + } + ] + } + }, + "overrides": [ + { + "__systemRef": "hideSeriesFrom", + "matcher": { + "id": "byNames", + "options": { + "mode": "exclude", + "names": [ + "Value" + ], + "prefix": "All except:", + "readOnly": true + } + }, + "properties": [ + { + "id": "custom.hideFrom", + "value": { + "legend": false, + "tooltip": false, + "viz": true + } + } + ] + } + ] + }, + "gridPos": { + "h": 8, + "w": 12, + "x": 12, + "y": 69 + }, + "id": 101, + "options": { + "legend": { + "calcs": [], + "displayMode": "table", + "placement": "bottom" + }, + "tooltip": { + "mode": "single", + "sort": "none" + } + }, + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "${DS_PROMETHEUS}" + }, + "exemplar": true, + "expr": "sum by (relnamenew) (label_replace(rate(pg_stat_user_tables_autoanalyze_count{} [5m]), \"relnamenew\", \"$1\", \"relname\", \"(.*[^_0-9])(_[0-9]+)*\"))", + "hide": false, + "interval": "", + "legendFormat": "{{ relnamenew }}", + "refId": "B" + } + ], + "title": "Autoanalyzes per Second", + "transformations": [], + "type": "timeseries" + }, + { + "collapsed": false, + "gridPos": { + "h": 1, + "w": 24, + "x": 0, + "y": 77 }, "id": 50, "panels": [], @@ -1897,7 +2959,7 @@ "h": 6, "w": 17, "x": 0, - "y": 35 + "y": 78 }, "hiddenSeries": false, "id": 46, @@ -1920,7 +2982,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -2018,7 +3080,7 @@ "h": 6, "w": 7, "x": 17, - "y": 35 + "y": 78 }, "hiddenSeries": false, "id": 28, @@ -2039,7 +3101,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -2119,7 +3181,7 @@ "h": 7, "w": 17, "x": 0, - "y": 41 + "y": 84 }, "hiddenSeries": false, "id": 30, @@ -2142,7 +3204,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -2210,7 +3272,7 @@ "h": 7, "w": 7, "x": 17, - "y": 41 + "y": 84 }, "hiddenSeries": false, "id": 40, @@ -2231,7 +3293,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -2299,7 +3361,7 @@ "h": 9, "w": 24, "x": 0, - "y": 48 + "y": 91 }, "hiddenSeries": false, "id": 38, @@ -2321,7 +3383,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -2395,7 +3457,7 @@ "h": 7, "w": 20, "x": 0, - "y": 57 + "y": 100 }, "hiddenSeries": false, "id": 80, @@ -2419,7 +3481,7 @@ "alertThreshold": true }, "percentage": false, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "pointradius": 5, "points": false, "renderer": "flot", @@ -2802,7 +3864,7 @@ "h": 7, "w": 4, "x": 20, - "y": 57 + "y": 100 }, "id": 78, "links": [], @@ -2822,7 +3884,7 @@ "text": {}, "textMode": "auto" }, - "pluginVersion": "8.4.3", + "pluginVersion": "8.4.6", "targets": [ { "datasource": { @@ -2830,7 +3892,7 @@ "uid": "${DS_PROMETHEUS}" }, "dsType": "prometheus", - "exemplar": true, + "exemplar": false, "expr": "sum(irate(pg_stat_database_xact_commit{datname=~\"taler(.*)\",instance=~\"$instance\", server=\"$server\"}[5m])) + sum(irate(pg_stat_database_xact_rollback{datname=~\"taler(.*)\",instance=~\"$instance\", server=\"$server\"}[5m]))", "format": "time_series", "groupBy": [ @@ -2847,6 +3909,7 @@ "type": "fill" } ], + "instant": true, "interval": "", "intervalFactor": 2, "legendFormat": "", @@ -2888,7 +3951,7 @@ "type": "stat" } ], - "refresh": "1m", + "refresh": "30s", "schemaVersion": 35, "style": "dark", "tags": [ @@ -2980,6 +4043,6 @@ "timezone": "", "title": "Database", "uid": "2FTtdeOnk", - "version": 99, + "version": 113, "weekStart": "" }
\ No newline at end of file diff --git a/additional/grafana/transactions.json b/additional/grafana/transactions.json index a9f0d7e..56fd0e1 100644 --- a/additional/grafana/transactions.json +++ b/additional/grafana/transactions.json @@ -1,67 +1,4 @@ { - "__inputs": [ - { - "name": "DS_PROMETHEUS", - "label": "Prometheus", - "description": "", - "type": "datasource", - "pluginId": "prometheus", - "pluginName": "Prometheus" - }, - { - "name": "DS_LOKI", - "label": "Loki", - "description": "", - "type": "datasource", - "pluginId": "loki", - "pluginName": "Loki" - } - ], - "__elements": [], - "__requires": [ - { - "type": "panel", - "id": "bargauge", - "name": "Bar gauge", - "version": "" - }, - { - "type": "panel", - "id": "gauge", - "name": "Gauge", - "version": "" - }, - { - "type": "grafana", - "id": "grafana", - "name": "Grafana", - "version": "8.4.6" - }, - { - "type": "datasource", - "id": "loki", - "name": "Loki", - "version": "1.0.0" - }, - { - "type": "datasource", - "id": "prometheus", - "name": "Prometheus", - "version": "1.0.0" - }, - { - "type": "panel", - "id": "stat", - "name": "Stat", - "version": "" - }, - { - "type": "panel", - "id": "timeseries", - "name": "Time series", - "version": "" - } - ], "annotations": { "list": [ { @@ -85,7 +22,7 @@ "editable": true, "fiscalYearStartMonth": 0, "graphTooltip": 1, - "id": null, + "id": 18, "links": [], "liveNow": false, "panels": [ @@ -154,7 +91,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum(node_systemd_unit_state{name=~\"taler-wallet@(.*).service\", state=\"active\"})", @@ -219,7 +156,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "((count(go_info{instance=~\"wallet(.*)\"}) * 100) - sum((avg by(instance) (irate(node_cpu_seconds_total{mode=\"idle\", instance=~\"wallet(.*)\"}[5m])) * 100))) / count(go_info{instance=~\"wallet(.*)\"})", @@ -280,7 +217,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "count(go_info{instance=~\"wallet(.*)\"})", @@ -342,7 +279,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "count(go_info{instance=~\"exchange(.*)\"})", @@ -402,7 +339,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum(node_systemd_unit_state{name=~\"taler-exchange-http(.*).service\", state=\"active\"})", @@ -473,7 +410,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum(node_systemd_unit_state{name=~\"taler-exchange-wirewatch(.*).service\", state=\"active\"})", @@ -545,7 +482,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum(node_systemd_unit_state{name=~\"taler-exchange-closer(.*).service\", state=\"active\"})", @@ -692,7 +629,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "node_systemd_unit_state{name=\"taler-exchange-secmod-cs.service\", state=\"active\"}", @@ -827,7 +764,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "count(go_info{instance=~\"(.*).proxy.*\"})", @@ -897,7 +834,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum(node_systemd_unit_state{name=~\"taler-exchange-aggregator(.*).service\", state=\"active\"})", @@ -967,7 +904,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum(node_systemd_unit_state{name=~\"taler-exchange-transfer(.*).service\", state=\"active\"})", @@ -1042,7 +979,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "node_systemd_unit_state{name=\"taler-exchange-secmod-eddsa.service\", state=\"active\"}", @@ -1118,7 +1055,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "node_systemd_unit_state{name=\"taler-fakebank.service\", state=\"active\"}", @@ -1264,7 +1201,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum by (__name__) (rate(taler_requests_total_requests{endpoint=\"coins-deposit\", status=\"200\"}[2m]) or vector(0)) + on(__name__) sum by (__name__) (rate(taler_requests_total_requests{endpoint=\"reserves-withdraw\", status=\"200\"} [2m]) or vector(0)) + on (__name__) sum by (__name__) (rate(taler_exchange_batch_withdraw_num_coins{} [2m]) or vector(0))", @@ -1352,7 +1289,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum by (__name__) (rate(taler_requests_total_requests{endpoint=\"coins-deposit\", status=\"200\"}[2m]) or vector(0)) + on(__name__) sum by (__name__) (rate(taler_requests_total_requests{endpoint=\"reserves-withdraw\", status=\"200\"} [2m]) or vector(0)) + on (__name__) sum by (__name__) (rate(taler_exchange_batch_withdraw_num_coins{} [2m]) or vector(0))", @@ -1436,7 +1373,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum by(__name__) (rate(taler_requests_total_requests{endpoint=\"reserves-withdraw\", status=\"200\"} [2m]) or vector(0)) + on () sum by (__name__) (rate(taler_exchange_batch_withdraw_num_coins{} [2m]) or vector(0))", @@ -1448,7 +1385,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum(rate(taler_requests_total_requests{endpoint=\"coins-deposit\", status=\"200\"}[2m]))", @@ -1515,7 +1452,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "(sum(rate(taler_requests_total_requests{endpoint=\"reserves-batch-withdraw\"}[5s])) or vector(0)) > bool 0", @@ -1527,7 +1464,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "(sum(rate(taler_requests_total_requests{endpoint=\"reserves-withdraw\"}[5s])) or vector(0)) > bool 0", @@ -1591,7 +1528,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum by (__name__) (rate(taler_requests_total_requests{endpoint=\"reserves-withdraw\", status=\"200\"} [5m]) or vector(0)) + on (__name__) sum by (__name__) (rate(taler_exchange_batch_withdraw_num_coins{} [5m]) or vector(0))", @@ -1655,7 +1592,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sum (rate(taler_requests_total_requests{endpoint=\"coins-deposit\", status=\"200\"} [5m] ))", @@ -1670,6 +1607,69 @@ "type": "stat" }, { + "fieldConfig": { + "defaults": { + "color": { + "mode": "thresholds" + }, + "mappings": [], + "thresholds": { + "mode": "absolute", + "steps": [ + { + "color": "green", + "value": null + }, + { + "color": "text", + "value": 0 + } + ] + } + }, + "overrides": [] + }, + "gridPos": { + "h": 4, + "w": 5, + "x": 0, + "y": 20 + }, + "id": 80, + "options": { + "colorMode": "none", + "graphMode": "none", + "justifyMode": "center", + "orientation": "auto", + "reduceOptions": { + "calcs": [ + "lastNotNull" + ], + "fields": "", + "values": false + }, + "textMode": "auto" + }, + "pluginVersion": "8.4.6", + "targets": [ + { + "datasource": { + "type": "prometheus", + "uid": "mZHmoevnk" + }, + "exemplar": false, + "expr": "count (label_replace(rate(pg_stat_user_tables_vacuum_count{relname=~\"reserves_[0-9]+\"} [5m]), \"relnamenew\", \"$1\", \"relname\", \"(.*[^_0-9])(_[0-9]+)*\"))", + "instant": true, + "interval": "", + "legendFormat": "", + "refId": "A" + } + ], + "title": "Partitions", + "transformations": [], + "type": "stat" + }, + { "description": "", "fieldConfig": { "defaults": { @@ -1732,7 +1732,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "(sum by (__name__) (rate(taler_requests_total_requests{endpoint=\"coins-deposit\", status=\"200\"} [5m]) or vector(0))) / on (__name__) (sum by (__name__) (rate(taler_requests_total_requests{endpoint=\"reserves-withdraw\", status=\"200\"} [5m]) or vector(0)) + on (__name__) sum by (__name__) (rate(taler_exchange_batch_withdraw_num_coins{} [5m]) or vector(0)))", @@ -1758,7 +1758,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "description": "Total successful requests to withdraw a whole reserve and to /deposit per second, measured at the nginx proxy and over the whole displayed time range. (Requests to /withdraw are grouped into reserves they belong to before they get counted.)", "fieldConfig": { @@ -1806,7 +1806,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "expr": "count without(uri) (sum by(uri) (count_over_time({job=\"proxy\", endpoint=~\"coins-deposit|reserves-withdraw\", status=\"200\"} | logfmt [2m]))) / 120", "instant": true, @@ -1820,7 +1820,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "description": "Total successful requests to withdraw all coins of a reserve per second, measured at the nginx proxy in a 10 minute interval. (Requests to /withdraw are grouped into reserves they belong to before they get counted.)", "fieldConfig": { @@ -1869,7 +1869,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "expr": "(count without(uri) (sum by(uri) (count_over_time({job=\"proxy\", endpoint=\"reserves-withdraw\", status=\"200\"} | logfmt [10m])))) / 600", "instant": true, @@ -1884,7 +1884,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "description": "Total successful requests to withdraw a whole reserve and to /deposit per second, measured at the nginx proxy and over the whole displayed time range. (Requests to /withdraw are grouped into reserves they belong to before they get counted.)", "fieldConfig": { @@ -1958,7 +1958,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "expr": "count without(uri) (sum by(uri) (count_over_time({job=\"proxy\", endpoint=~\"reserves-withdraw|coins-deposit\", status=\"200\"} | logfmt [2m]))) / (2*60)", "legendFormat": "TPS", @@ -2017,7 +2017,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": true, "expr": "sum (rate(taler_requests_total_requests{endpoint=\"coins-deposit\", status=\"200\"} [5m] ))", @@ -2033,7 +2033,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "description": "", "fieldConfig": { @@ -2084,7 +2084,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "expr": "(sum(count_over_time({job=\"proxy\", endpoint=\"coins-deposit\", status=\"200\"} [10m]))) / (count without(uri) (sum by(uri) (count_over_time({job=\"proxy\", endpoint=\"reserves-withdraw\", status=\"200\"} | logfmt [10m]))))", "instant": true, @@ -2115,7 +2115,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "description": "Average time to withdraw all reserved coins in one iteration, measured by the wallets.", "fieldConfig": { @@ -2192,7 +2192,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "expr": "avg_over_time({app=\"taler-wallet-cli\", job=\"wallet\", script=\"benchmark\"} |~ \"withdraw\" | logfmt | unwrap time [2m]) by (app)", "instant": false, @@ -2290,7 +2290,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "description": "Average time to deposit coins measured by wallet - for all deposits in one iteration", "fieldConfig": { @@ -2367,7 +2367,7 @@ { "datasource": { "type": "loki", - "uid": "${DS_LOKI}" + "uid": "Mp8p16v7z" }, "expr": "avg_over_time({app=\"taler-wallet-cli\", job=\"wallet\", script=\"benchmark\"} |~ \"deposit \" | logfmt | unwrap time [2m]) by (app)", "legendFormat": "deposit", @@ -2508,7 +2508,7 @@ { "datasource": { "type": "prometheus", - "uid": "${DS_PROMETHEUS}" + "uid": "mZHmoevnk" }, "exemplar": false, "expr": "sort_desc(sum by (account) (taler_fakebank_account_payments{account!=\"Exchange\"}))", @@ -2542,6 +2542,6 @@ "timezone": "", "title": "Transactions", "uid": "83vvgKKnk", - "version": 166, + "version": 168, "weekStart": "" }
\ No newline at end of file |