summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBoss Marco <bossm8@bfh.ch>2022-05-25 13:45:50 +0200
committerBoss Marco <bossm8@bfh.ch>2022-05-25 13:45:50 +0200
commit2c3d3c1680868343d26b37a9e00f092bcc5582b0 (patch)
tree247a1d23ff067f494d3abae3a2339fb6286023da
parent1e9d072a65c6455ca26ceb19406c658b37fa57bf (diff)
downloadgrid5k-2c3d3c1680868343d26b37a9e00f092bcc5582b0.tar.gz
grid5k-2c3d3c1680868343d26b37a9e00f092bcc5582b0.tar.bz2
grid5k-2c3d3c1680868343d26b37a9e00f092bcc5582b0.zip
added new panels for db statistics
-rw-r--r--additional/grafana/database.json1181
-rw-r--r--additional/grafana/transactions.json202
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