[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-grid5k] 44/48: added new panels for db statistics
From: |
gnunet |
Subject: |
[taler-grid5k] 44/48: added new panels for db statistics |
Date: |
Sat, 28 May 2022 12:12:04 +0200 |
This is an automated email from the git hooks/post-receive script.
marco-boss pushed a commit to branch master
in repository grid5k.
commit 2c3d3c1680868343d26b37a9e00f092bcc5582b0
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Wed May 25 13:45:50 2022 +0200
added new panels for db statistics
---
additional/grafana/database.json | 1491 +++++++++++++++++++++++++++++-----
additional/grafana/transactions.json | 202 ++---
2 files changed, 1378 insertions(+), 315 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",
@@ -35,6 +35,12 @@
"name": "Stat",
"version": ""
},
+ {
+ "type": "panel",
+ "id": "table",
+ "name": "Table",
+ "version": ""
+ },
{
"type": "panel",
"id": "timeseries",
@@ -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,192 +1876,1248 @@
}
},
{
- "collapsed": false,
- "gridPos": {
- "h": 1,
- "w": 24,
- "x": 0,
- "y": 34
- },
- "id": 50,
- "panels": [],
- "title": "Misc",
- "type": "row"
- },
- {
- "aliasColors": {},
- "bars": false,
- "dashLength": 10,
- "dashes": false,
- "datasource": {
- "type": "prometheus",
- "uid": "${DS_PROMETHEUS}"
+ "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": []
},
- "fill": 1,
- "fillGradient": 0,
"gridPos": {
- "h": 6,
- "w": 17,
+ "h": 10,
+ "w": 12,
"x": 0,
- "y": 35
- },
- "hiddenSeries": false,
- "id": 46,
- "legend": {
- "alignAsTable": true,
- "avg": true,
- "current": true,
- "max": true,
- "min": true,
- "rightSide": true,
- "show": true,
- "total": false,
- "values": true
+ "y": 34
},
- "lines": true,
- "linewidth": 1,
- "links": [],
- "nullPointMode": "null",
+ "id": 103,
"options": {
- "alertThreshold": true
+ "footer": {
+ "fields": "",
+ "reducer": [
+ "sum"
+ ],
+ "show": false
+ },
+ "frameIndex": 6,
+ "showHeader": true
},
- "percentage": false,
- "pluginVersion": "8.4.3",
- "pointradius": 5,
- "points": false,
- "renderer": "flot",
- "seriesOverrides": [],
- "spaceLength": 10,
- "stack": false,
- "steppedLine": false,
+ "pluginVersion": "8.4.6",
"targets": [
{
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
+ },
"exemplar": true,
- "expr":
"irate(pg_stat_bgwriter_buffers_backend{instance=\"$instance\",
server=\"$server\"}[5m])",
- "format": "time_series",
+ "expr": "rate(pg_wait_events_count{} [5m])",
"interval": "",
- "intervalFactor": 1,
- "legendFormat": "buffers_backend",
+ "legendFormat": "",
"refId": "A"
+ }
+ ],
+ "title": "Wait Events",
+ "transformations": [
+ {
+ "id": "labelsToFields",
+ "options": {
+ "keepLabels": [
+ "wait_event",
+ "wait_event_type"
+ ]
+ }
},
{
- "exemplar": true,
- "expr":
"irate(pg_stat_bgwriter_buffers_alloc{instance=\"$instance\",
server=\"$server\"}[5m])",
- "format": "time_series",
- "interval": "",
- "intervalFactor": 1,
- "legendFormat": "buffers_alloc",
- "refId": "B"
- },
- {
- "exemplar": true,
- "expr":
"irate(pg_stat_bgwriter_buffers_backend_fsync{instance=\"$instance\",
server=\"$server\"}[5m])",
- "format": "time_series",
- "interval": "",
- "intervalFactor": 1,
- "legendFormat": "backend_fsync",
- "refId": "C"
+ "id": "groupBy",
+ "options": {
+ "fields": {
+ "Value": {
+ "aggregations": [
+ "sum"
+ ],
+ "operation": "aggregate"
+ },
+ "wait_event": {
+ "aggregations": [],
+ "operation": "groupby"
+ },
+ "wait_event_type": {
+ "aggregations": [],
+ "operation": "groupby"
+ }
+ }
+ }
},
{
- "exemplar": true,
- "expr":
"irate(pg_stat_bgwriter_buffers_checkpoint{instance=\"$instance\",
server=\"$server\"}[5m])",
- "format": "time_series",
- "interval": "",
- "intervalFactor": 1,
- "legendFormat": "buffers_checkpoint",
- "refId": "D"
+ "id": "merge",
+ "options": {}
},
{
- "exemplar": true,
- "expr":
"irate(pg_stat_bgwriter_buffers_clean{instance=\"$instance\",
server=\"$server\"}[5m])",
- "format": "time_series",
- "interval": "",
- "intervalFactor": 1,
- "legendFormat": "buffers_clean",
- "refId": "E"
- }
- ],
- "thresholds": [],
- "timeRegions": [],
- "title": "Buffers (bgwriter)",
- "tooltip": {
- "shared": true,
- "sort": 0,
- "value_type": "individual"
- },
- "type": "graph",
- "xaxis": {
- "mode": "time",
- "show": true,
- "values": []
- },
- "yaxes": [
- {
- "$$hashKey": "object:97",
- "format": "short",
- "logBase": 1,
- "show": true
+ "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"
+ }
+ }
},
{
- "$$hashKey": "object:98",
- "format": "short",
- "logBase": 1,
- "show": true
+ "id": "sortBy",
+ "options": {
+ "fields": {},
+ "sort": [
+ {
+ "desc": true,
+ "field": "Count per Second"
+ }
+ ]
+ }
}
],
- "yaxis": {
- "align": false
- }
+ "type": "table"
},
{
- "aliasColors": {},
- "bars": false,
- "dashLength": 10,
- "dashes": false,
- "fill": 1,
- "fillGradient": 0,
+ "collapsed": false,
"gridPos": {
- "h": 6,
- "w": 7,
- "x": 17,
- "y": 35
- },
- "hiddenSeries": false,
- "id": 28,
- "legend": {
- "avg": false,
- "current": false,
- "max": false,
- "min": false,
- "show": true,
- "total": false,
- "values": false
- },
- "lines": true,
- "linewidth": 1,
- "links": [],
- "nullPointMode": "null",
- "options": {
- "alertThreshold": true
+ "h": 1,
+ "w": 24,
+ "x": 0,
+ "y": 44
},
- "percentage": false,
- "pluginVersion": "8.4.3",
- "pointradius": 5,
- "points": false,
- "renderer": "flot",
- "seriesOverrides": [],
- "spaceLength": 10,
- "stack": false,
- "steppedLine": false,
- "targets": [
- {
- "datasource": {
- "type": "prometheus",
- "uid": "${DS_PROMETHEUS}"
+ "id": 92,
+ "panels": [],
+ "title": "Table Statistics",
+ "type": "row"
+ },
+ {
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "color": {
+ "mode": "palette-classic"
},
- "exemplar": true,
- "expr": "irate(pg_stat_database_conflicts{instance=\"$instance\",
datname=~\"taler(.*)\", server=\"$server\"}[5m])",
- "format": "time_series",
+ "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": [],
+ "title": "Misc",
+ "type": "row"
+ },
+ {
+ "aliasColors": {},
+ "bars": false,
+ "dashLength": 10,
+ "dashes": false,
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
+ },
+ "fill": 1,
+ "fillGradient": 0,
+ "gridPos": {
+ "h": 6,
+ "w": 17,
+ "x": 0,
+ "y": 78
+ },
+ "hiddenSeries": false,
+ "id": 46,
+ "legend": {
+ "alignAsTable": true,
+ "avg": true,
+ "current": true,
+ "max": true,
+ "min": true,
+ "rightSide": true,
+ "show": true,
+ "total": false,
+ "values": true
+ },
+ "lines": true,
+ "linewidth": 1,
+ "links": [],
+ "nullPointMode": "null",
+ "options": {
+ "alertThreshold": true
+ },
+ "percentage": false,
+ "pluginVersion": "8.4.6",
+ "pointradius": 5,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "spaceLength": 10,
+ "stack": false,
+ "steppedLine": false,
+ "targets": [
+ {
+ "exemplar": true,
+ "expr":
"irate(pg_stat_bgwriter_buffers_backend{instance=\"$instance\",
server=\"$server\"}[5m])",
+ "format": "time_series",
+ "interval": "",
+ "intervalFactor": 1,
+ "legendFormat": "buffers_backend",
+ "refId": "A"
+ },
+ {
+ "exemplar": true,
+ "expr":
"irate(pg_stat_bgwriter_buffers_alloc{instance=\"$instance\",
server=\"$server\"}[5m])",
+ "format": "time_series",
+ "interval": "",
+ "intervalFactor": 1,
+ "legendFormat": "buffers_alloc",
+ "refId": "B"
+ },
+ {
+ "exemplar": true,
+ "expr":
"irate(pg_stat_bgwriter_buffers_backend_fsync{instance=\"$instance\",
server=\"$server\"}[5m])",
+ "format": "time_series",
+ "interval": "",
+ "intervalFactor": 1,
+ "legendFormat": "backend_fsync",
+ "refId": "C"
+ },
+ {
+ "exemplar": true,
+ "expr":
"irate(pg_stat_bgwriter_buffers_checkpoint{instance=\"$instance\",
server=\"$server\"}[5m])",
+ "format": "time_series",
+ "interval": "",
+ "intervalFactor": 1,
+ "legendFormat": "buffers_checkpoint",
+ "refId": "D"
+ },
+ {
+ "exemplar": true,
+ "expr":
"irate(pg_stat_bgwriter_buffers_clean{instance=\"$instance\",
server=\"$server\"}[5m])",
+ "format": "time_series",
+ "interval": "",
+ "intervalFactor": 1,
+ "legendFormat": "buffers_clean",
+ "refId": "E"
+ }
+ ],
+ "thresholds": [],
+ "timeRegions": [],
+ "title": "Buffers (bgwriter)",
+ "tooltip": {
+ "shared": true,
+ "sort": 0,
+ "value_type": "individual"
+ },
+ "type": "graph",
+ "xaxis": {
+ "mode": "time",
+ "show": true,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "$$hashKey": "object:97",
+ "format": "short",
+ "logBase": 1,
+ "show": true
+ },
+ {
+ "$$hashKey": "object:98",
+ "format": "short",
+ "logBase": 1,
+ "show": true
+ }
+ ],
+ "yaxis": {
+ "align": false
+ }
+ },
+ {
+ "aliasColors": {},
+ "bars": false,
+ "dashLength": 10,
+ "dashes": false,
+ "fill": 1,
+ "fillGradient": 0,
+ "gridPos": {
+ "h": 6,
+ "w": 7,
+ "x": 17,
+ "y": 78
+ },
+ "hiddenSeries": false,
+ "id": 28,
+ "legend": {
+ "avg": false,
+ "current": false,
+ "max": false,
+ "min": false,
+ "show": true,
+ "total": false,
+ "values": false
+ },
+ "lines": true,
+ "linewidth": 1,
+ "links": [],
+ "nullPointMode": "null",
+ "options": {
+ "alertThreshold": true
+ },
+ "percentage": false,
+ "pluginVersion": "8.4.6",
+ "pointradius": 5,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "spaceLength": 10,
+ "stack": false,
+ "steppedLine": false,
+ "targets": [
+ {
+ "datasource": {
+ "type": "prometheus",
+ "uid": "${DS_PROMETHEUS}"
+ },
+ "exemplar": true,
+ "expr": "irate(pg_stat_database_conflicts{instance=\"$instance\",
datname=~\"taler(.*)\", server=\"$server\"}[5m])",
+ "format": "time_series",
"interval": "",
"intervalFactor": 1,
"legendFormat": "conflicts",
@@ -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] ))",
@@ -1669,6 +1606,69 @@
"transformations": [],
"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": {
@@ -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
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
- [taler-grid5k] 36/48: optimistically increase file limit, (continued)
- [taler-grid5k] 36/48: optimistically increase file limit, gnunet, 2022/05/28
- [taler-grid5k] 28/48: log query parameters in nginx, gnunet, 2022/05/28
- [taler-grid5k] 41/48: add wait events, gnunet, 2022/05/28
- [taler-grid5k] 26/48: fix setup.sh, gnunet, 2022/05/28
- [taler-grid5k] 39/48: add relabel to prometheus, gnunet, 2022/05/28
- [taler-grid5k] 31/48: fix update of g5k repo, gnunet, 2022/05/28
- [taler-grid5k] 30/48: add some comments to auditor.sh, gnunet, 2022/05/28
- [taler-grid5k] 47/48: changes to rspec and dashboards, gnunet, 2022/05/28
- [taler-grid5k] 24/48: recover run.sh discard wget ouptup, gnunet, 2022/05/28
- [taler-grid5k] 34/48: increase bank size, gnunet, 2022/05/28
- [taler-grid5k] 44/48: added new panels for db statistics,
gnunet <=
- [taler-grid5k] 32/48: update bank, gnunet, 2022/05/28
- [taler-grid5k] 43/48: fix metric, gnunet, 2022/05/28
- [taler-grid5k] 42/48: fix metric, gnunet, 2022/05/28