[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[taler-grid5k] 46/48: fix db dashboard
From: |
gnunet |
Subject: |
[taler-grid5k] 46/48: fix db dashboard |
Date: |
Sat, 28 May 2022 12:12:06 +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 df3da27e5cccb1a3c77256ffb8f5dda32094438c
Author: Boss Marco <bossm8@bfh.ch>
AuthorDate: Wed May 25 20:20:25 2022 +0200
fix db dashboard
---
additional/grafana/database.json | 24 ++++++++++++------------
1 file changed, 12 insertions(+), 12 deletions(-)
diff --git a/additional/grafana/database.json b/additional/grafana/database.json
index c655b7f..985ab20 100644
--- a/additional/grafana/database.json
+++ b/additional/grafana/database.json
@@ -73,7 +73,7 @@
"gnetId": 6742,
"graphTooltip": 1,
"id": null,
- "iteration": 1653478495749,
+ "iteration": 1653494175678,
"links": [],
"liveNow": false,
"panels": [
@@ -1929,7 +1929,7 @@
"uid": "${DS_PROMETHEUS}"
},
"exemplar": true,
- "expr": "rate(pg_wait_events_count{} [5m])",
+ "expr": "rate(pg_wait_events_count{instance=\"$instance\",
server=\"$server\"} [5m])",
"interval": "",
"legendFormat": "",
"refId": "A"
@@ -2081,7 +2081,7 @@
"uid": "${DS_PROMETHEUS}"
},
"exemplar": true,
- "expr": "sum by (wait_event_type, wait_event)
(rate(pg_wait_events_count{} [5m]))",
+ "expr": "sum by (wait_event_type, wait_event)
(rate(pg_wait_events_count{instance=\"$instance\", server=\"$server\"} [5m]))",
"interval": "",
"legendFormat": "{{wait_event}} ({{ wait_event_type }})",
"refId": "A"
@@ -2206,7 +2206,7 @@
"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]+)*\"))",
+ "expr": "sum by (relnamenew)
(label_replace(rate(pg_stat_user_tables_seq_scan{server=\"$server\",
instance=\"$instance\"} [5m]), \"relnamenew\", \"$1\", \"relname\",
\"(.*[^_0-9])(_[0-9]+)*\"))",
"hide": false,
"interval": "",
"legendFormat": "{{ relnamenew }}",
@@ -2319,7 +2319,7 @@
"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]+)*\"))",
+ "expr": "sum by (relnamenew)
(label_replace(rate(pg_stat_user_tables_idx_scan{instance=\"$instance\",
server=\"$server\"} [5m]), \"relnamenew\", \"$1\", \"relname\",
\"(.*[^_0-9])(_[0-9]+)*\"))",
"hide": false,
"interval": "",
"legendFormat": "{{ relnamenew }}",
@@ -2432,7 +2432,7 @@
"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]+)*\"))",
+ "expr": "sum by (relnamenew)
(label_replace(rate(pg_stat_user_tables_n_live_tup{instance=\"$instance\",
server=\"$server\"} [5m]), \"relnamenew\", \"$1\", \"relname\",
\"(.*[^_0-9])(_[0-9]+)*\"))",
"hide": false,
"interval": "",
"legendFormat": "{{ relnamenew }}",
@@ -2545,7 +2545,7 @@
"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]+)*\"))",
+ "expr": "sum by (relnamenew)
(label_replace(rate(pg_stat_user_tables_n_dead_tup{instance=\"$instance\",
server=\"$server\"} [5m]), \"relnamenew\", \"$1\", \"relname\",
\"(.*[^_0-9])(_[0-9]+)*\"))",
"hide": false,
"interval": "",
"legendFormat": "{{ relnamenew }}",
@@ -2670,7 +2670,7 @@
"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]+)*\"))",
+ "expr": "sum by (relnamenew)
(label_replace(rate(pg_stat_user_tables_n_tup_upd{instance=\"$instance\",
server=\"$server\"} [5m]), \"relnamenew\", \"$1\", \"relname\",
\"(.*[^_0-9])(_[0-9]+)*\"))",
"hide": false,
"interval": "",
"legendFormat": "{{ relnamenew }}",
@@ -2783,7 +2783,7 @@
"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]+)*\"))",
+ "expr": "sum by (relnamenew)
(label_replace(rate(pg_stat_user_tables_n_tup_hot_upd{instance=\"$instance\",
server=\"$server\"} [5m]), \"relnamenew\", \"$1\", \"relname\",
\"(.*[^_0-9])(_[0-9]+)*\"))",
"hide": false,
"interval": "",
"legendFormat": "{{ relnamenew }}",
@@ -2896,7 +2896,7 @@
"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]+)*\"))",
+ "expr": "sum by (relnamenew)
(label_replace(rate(pg_stat_user_tables_autovacuum_count{instance=\"$instance\",
server=\"$server\"} [5m]), \"relnamenew\", \"$1\", \"relname\",
\"(.*[^_0-9])(_[0-9]+)*\"))",
"hide": false,
"interval": "",
"legendFormat": "{{ relnamenew }}",
@@ -3009,7 +3009,7 @@
"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]+)*\"))",
+ "expr": "sum by (relnamenew)
(label_replace(rate(pg_stat_user_tables_autoanalyze_count{instance=\"$instance\",
server=\"$server\"} [5m]), \"relnamenew\", \"$1\", \"relname\",
\"(.*[^_0-9])(_[0-9]+)*\"))",
"hide": false,
"interval": "",
"legendFormat": "{{ relnamenew }}",
@@ -4132,6 +4132,6 @@
"timezone": "",
"title": "Database",
"uid": "2FTtdeOnk",
- "version": 115,
+ "version": 118,
"weekStart": ""
}
\ No newline at end of file
--
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.
- [taler-grid5k] 20/48: add auditor in db monitoring, (continued)
- [taler-grid5k] 20/48: add auditor in db monitoring, gnunet, 2022/05/28
- [taler-grid5k] 37/48: custom metrics of postgres exporter only work when selecting a db in the url, gnunet, 2022/05/28
- [taler-grid5k] 45/48: update dashboards, gnunet, 2022/05/28
- [taler-grid5k] 38/48: add relabel to prometheus, gnunet, 2022/05/28
- [taler-grid5k] 35/48: wallet build broken, gnunet, 2022/05/28
- [taler-grid5k] 48/48: integrate final changes from setup, gnunet, 2022/05/28
- [taler-grid5k] 25/48: auditor db in /tmp of G5k, gnunet, 2022/05/28
- [taler-grid5k] 40/48: not working, gnunet, 2022/05/28
- [taler-grid5k] 27/48: different updates, gnunet, 2022/05/28
- [taler-grid5k] 29/48: nginx query params break loki, gnunet, 2022/05/28
- [taler-grid5k] 46/48: fix db dashboard,
gnunet <=
- [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