Adding scraping relation to Mongodb Exporter
[osm/devops.git] / installers / charm / mongodb-exporter / files / mongodb_exporter_dashboard.json
1 {
2   "annotations": {
3     "list": [
4       {
5         "builtIn": 1,
6         "datasource": "-- Grafana --",
7         "enable": true,
8         "hide": true,
9         "iconColor": "rgba(0, 211, 255, 1)",
10         "name": "Annotations & Alerts",
11         "type": "dashboard"
12       }
13     ]
14   },
15   "description": "MongoDB Prometheus Exporter Dashboard.",
16   "editable": true,
17   "gnetId": 2583,
18   "graphTooltip": 1,
19   "id": 9,
20   "iteration": 1577555358996,
21   "links": [],
22   "panels": [
23     {
24       "collapsed": false,
25       "gridPos": {
26         "h": 1,
27         "w": 24,
28         "x": 0,
29         "y": 0
30       },
31       "id": 22,
32       "panels": [],
33       "repeat": "env",
34       "title": "Health",
35       "type": "row"
36     },
37     {
38       "cacheTimeout": null,
39       "colorBackground": false,
40       "colorValue": true,
41       "colors": [
42         "rgba(245, 54, 54, 0.9)",
43         "rgba(237, 129, 40, 0.89)",
44         "rgba(50, 172, 45, 0.97)"
45       ],
46       "datasource": "prometheus - Juju generated source",
47       "decimals": null,
48       "format": "s",
49       "gauge": {
50         "maxValue": 100,
51         "minValue": 0,
52         "show": false,
53         "thresholdLabels": false,
54         "thresholdMarkers": true
55       },
56       "gridPos": {
57         "h": 4,
58         "w": 12,
59         "x": 0,
60         "y": 1
61       },
62       "id": 10,
63       "interval": null,
64       "links": [],
65       "mappingType": 1,
66       "mappingTypes": [
67         {
68           "name": "value to text",
69           "value": 1
70         },
71         {
72           "name": "range to text",
73           "value": 2
74         }
75       ],
76       "maxDataPoints": 100,
77       "nullPointMode": "connected",
78       "nullText": null,
79       "options": {},
80       "postfix": "",
81       "postfixFontSize": "50%",
82       "prefix": "",
83       "prefixFontSize": "50%",
84       "rangeMaps": [
85         {
86           "from": "null",
87           "text": "N/A",
88           "to": "null"
89         }
90       ],
91       "sparkline": {
92         "fillColor": "rgba(31, 118, 189, 0.18)",
93         "full": false,
94         "lineColor": "rgb(31, 120, 193)",
95         "show": false
96       },
97       "tableColumn": "",
98       "targets": [
99         {
100           "expr": "mongodb_instance_uptime_seconds{instance=~\"$instance\"}",
101           "format": "time_series",
102           "intervalFactor": 2,
103           "legendFormat": "",
104           "refId": "A",
105           "step": 1800
106         }
107       ],
108       "thresholds": "0,360",
109       "title": "Uptime",
110       "type": "singlestat",
111       "valueFontSize": "80%",
112       "valueMaps": [
113         {
114           "op": "=",
115           "text": "N/A",
116           "value": "null"
117         }
118       ],
119       "valueName": "current"
120     },
121     {
122       "cacheTimeout": null,
123       "colorBackground": false,
124       "colorValue": false,
125       "colors": [
126         "rgba(245, 54, 54, 0.9)",
127         "rgba(237, 129, 40, 0.89)",
128         "rgba(50, 172, 45, 0.97)"
129       ],
130       "datasource": "prometheus - Juju generated source",
131       "format": "none",
132       "gauge": {
133         "maxValue": 100,
134         "minValue": 0,
135         "show": false,
136         "thresholdLabels": false,
137         "thresholdMarkers": true
138       },
139       "gridPos": {
140         "h": 4,
141         "w": 12,
142         "x": 12,
143         "y": 1
144       },
145       "id": 1,
146       "interval": null,
147       "links": [],
148       "mappingType": 1,
149       "mappingTypes": [
150         {
151           "name": "value to text",
152           "value": 1
153         },
154         {
155           "name": "range to text",
156           "value": 2
157         }
158       ],
159       "maxDataPoints": 100,
160       "nullPointMode": "connected",
161       "nullText": null,
162       "options": {},
163       "postfix": "",
164       "postfixFontSize": "50%",
165       "prefix": "",
166       "prefixFontSize": "50%",
167       "rangeMaps": [
168         {
169           "from": "null",
170           "text": "N/A",
171           "to": "null"
172         }
173       ],
174       "sparkline": {
175         "fillColor": "rgba(31, 118, 189, 0.18)",
176         "full": true,
177         "lineColor": "rgb(31, 120, 193)",
178         "show": true
179       },
180       "tableColumn": "",
181       "targets": [
182         {
183           "expr": "mongodb_connections{instance=~\"$instance\",state=\"current\"}",
184           "format": "time_series",
185           "intervalFactor": 2,
186           "legendFormat": "",
187           "metric": "mongodb_connections",
188           "refId": "A",
189           "step": 1800
190         }
191       ],
192       "thresholds": "",
193       "title": "Open Connections",
194       "type": "singlestat",
195       "valueFontSize": "80%",
196       "valueMaps": [
197         {
198           "op": "=",
199           "text": "N/A",
200           "value": "null"
201         }
202       ],
203       "valueName": "avg"
204     },
205     {
206       "collapsed": false,
207       "gridPos": {
208         "h": 1,
209         "w": 24,
210         "x": 0,
211         "y": 5
212       },
213       "id": 20,
214       "panels": [],
215       "repeat": "env",
216       "title": "Operations",
217       "type": "row"
218     },
219     {
220       "aliasColors": {},
221       "bars": false,
222       "dashLength": 10,
223       "dashes": false,
224       "datasource": "prometheus - Juju generated source",
225       "fill": 1,
226       "fillGradient": 0,
227       "gridPos": {
228         "h": 6,
229         "w": 10,
230         "x": 0,
231         "y": 6
232       },
233       "id": 7,
234       "legend": {
235         "avg": false,
236         "current": false,
237         "max": false,
238         "min": false,
239         "show": true,
240         "total": false,
241         "values": false
242       },
243       "lines": true,
244       "linewidth": 1,
245       "links": [],
246       "nullPointMode": "null",
247       "options": {
248         "dataLinks": []
249       },
250       "percentage": false,
251       "pointradius": 5,
252       "points": false,
253       "renderer": "flot",
254       "seriesOverrides": [],
255       "spaceLength": 10,
256       "stack": false,
257       "steppedLine": false,
258       "targets": [
259         {
260           "expr": "rate(mongodb_op_counters_total{instance=~\"$instance\"}[$interval])",
261           "format": "time_series",
262           "interval": "",
263           "intervalFactor": 2,
264           "legendFormat": "{{type}}",
265           "refId": "A",
266           "step": 240
267         }
268       ],
269       "thresholds": [],
270       "timeFrom": null,
271       "timeRegions": [],
272       "timeShift": null,
273       "title": "Query Operations",
274       "tooltip": {
275         "shared": true,
276         "sort": 0,
277         "value_type": "individual"
278       },
279       "type": "graph",
280       "xaxis": {
281         "buckets": null,
282         "mode": "time",
283         "name": null,
284         "show": true,
285         "values": []
286       },
287       "yaxes": [
288         {
289           "format": "ops",
290           "label": null,
291           "logBase": 1,
292           "max": null,
293           "min": null,
294           "show": true
295         },
296         {
297           "format": "short",
298           "label": null,
299           "logBase": 1,
300           "max": null,
301           "min": null,
302           "show": true
303         }
304       ],
305       "yaxis": {
306         "align": false,
307         "alignLevel": null
308       }
309     },
310     {
311       "aliasColors": {},
312       "bars": false,
313       "dashLength": 10,
314       "dashes": false,
315       "datasource": "prometheus - Juju generated source",
316       "fill": 1,
317       "fillGradient": 0,
318       "gridPos": {
319         "h": 6,
320         "w": 8,
321         "x": 10,
322         "y": 6
323       },
324       "id": 9,
325       "legend": {
326         "avg": false,
327         "current": false,
328         "max": false,
329         "min": false,
330         "show": true,
331         "total": false,
332         "values": false
333       },
334       "lines": true,
335       "linewidth": 1,
336       "links": [],
337       "nullPointMode": "null",
338       "options": {
339         "dataLinks": []
340       },
341       "percentage": false,
342       "pointradius": 5,
343       "points": false,
344       "renderer": "flot",
345       "seriesOverrides": [
346         {
347           "alias": "returned",
348           "yaxis": 1
349         }
350       ],
351       "spaceLength": 10,
352       "stack": false,
353       "steppedLine": false,
354       "targets": [
355         {
356           "expr": "rate(mongodb_mongod_metrics_document_total{instance=~\"$instance\"}[$interval])",
357           "format": "time_series",
358           "interval": "",
359           "intervalFactor": 2,
360           "legendFormat": "{{state}}",
361           "refId": "A",
362           "step": 240
363         }
364       ],
365       "thresholds": [],
366       "timeFrom": null,
367       "timeRegions": [],
368       "timeShift": null,
369       "title": "Document Operations",
370       "tooltip": {
371         "shared": true,
372         "sort": 0,
373         "value_type": "individual"
374       },
375       "type": "graph",
376       "xaxis": {
377         "buckets": null,
378         "mode": "time",
379         "name": null,
380         "show": true,
381         "values": []
382       },
383       "yaxes": [
384         {
385           "format": "short",
386           "label": null,
387           "logBase": 1,
388           "max": null,
389           "min": null,
390           "show": true
391         },
392         {
393           "format": "short",
394           "label": null,
395           "logBase": 1,
396           "max": null,
397           "min": null,
398           "show": true
399         }
400       ],
401       "yaxis": {
402         "align": false,
403         "alignLevel": null
404       }
405     },
406     {
407       "aliasColors": {},
408       "bars": false,
409       "dashLength": 10,
410       "dashes": false,
411       "datasource": "prometheus - Juju generated source",
412       "fill": 1,
413       "fillGradient": 0,
414       "gridPos": {
415         "h": 6,
416         "w": 6,
417         "x": 18,
418         "y": 6
419       },
420       "id": 8,
421       "legend": {
422         "avg": false,
423         "current": false,
424         "max": false,
425         "min": false,
426         "show": true,
427         "total": false,
428         "values": false
429       },
430       "lines": true,
431       "linewidth": 1,
432       "links": [],
433       "nullPointMode": "null",
434       "options": {
435         "dataLinks": []
436       },
437       "percentage": false,
438       "pointradius": 5,
439       "points": false,
440       "renderer": "flot",
441       "seriesOverrides": [],
442       "spaceLength": 10,
443       "stack": false,
444       "steppedLine": false,
445       "targets": [
446         {
447           "expr": "rate(mongodb_mongod_metrics_query_executor_total{instance=~\"$instance\"}[$interval])",
448           "format": "time_series",
449           "interval": "",
450           "intervalFactor": 2,
451           "legendFormat": "{{state}}",
452           "refId": "A",
453           "step": 600
454         }
455       ],
456       "thresholds": [],
457       "timeFrom": null,
458       "timeRegions": [],
459       "timeShift": null,
460       "title": "Document Query Executor",
461       "tooltip": {
462         "shared": true,
463         "sort": 0,
464         "value_type": "individual"
465       },
466       "type": "graph",
467       "xaxis": {
468         "buckets": null,
469         "mode": "time",
470         "name": null,
471         "show": true,
472         "values": []
473       },
474       "yaxes": [
475         {
476           "format": "short",
477           "label": null,
478           "logBase": 1,
479           "max": null,
480           "min": null,
481           "show": true
482         },
483         {
484           "format": "short",
485           "label": null,
486           "logBase": 1,
487           "max": null,
488           "min": null,
489           "show": true
490         }
491       ],
492       "yaxis": {
493         "align": false,
494         "alignLevel": null
495       }
496     },
497     {
498       "collapsed": false,
499       "gridPos": {
500         "h": 1,
501         "w": 24,
502         "x": 0,
503         "y": 12
504       },
505       "id": 23,
506       "panels": [],
507       "repeat": null,
508       "title": "Resources",
509       "type": "row"
510     },
511     {
512       "aliasColors": {},
513       "bars": false,
514       "dashLength": 10,
515       "dashes": false,
516       "datasource": "prometheus - Juju generated source",
517       "fill": 1,
518       "fillGradient": 0,
519       "gridPos": {
520         "h": 6,
521         "w": 12,
522         "x": 0,
523         "y": 13
524       },
525       "id": 4,
526       "legend": {
527         "alignAsTable": false,
528         "avg": false,
529         "current": true,
530         "hideEmpty": false,
531         "hideZero": false,
532         "max": false,
533         "min": false,
534         "rightSide": false,
535         "show": true,
536         "total": false,
537         "values": true
538       },
539       "lines": true,
540       "linewidth": 1,
541       "links": [],
542       "nullPointMode": "null",
543       "options": {
544         "dataLinks": []
545       },
546       "percentage": false,
547       "pointradius": 5,
548       "points": false,
549       "renderer": "flot",
550       "seriesOverrides": [],
551       "spaceLength": 10,
552       "stack": false,
553       "steppedLine": false,
554       "targets": [
555         {
556           "expr": "mongodb_memory{instance=~\"$instance\",type=~\"resident|virtual\"}",
557           "format": "time_series",
558           "interval": "",
559           "intervalFactor": 2,
560           "legendFormat": "{{type}}",
561           "refId": "A",
562           "step": 240
563         }
564       ],
565       "thresholds": [],
566       "timeFrom": null,
567       "timeRegions": [],
568       "timeShift": null,
569       "title": "Memory",
570       "tooltip": {
571         "shared": false,
572         "sort": 0,
573         "value_type": "individual"
574       },
575       "type": "graph",
576       "xaxis": {
577         "buckets": null,
578         "mode": "time",
579         "name": null,
580         "show": true,
581         "values": [
582           "total"
583         ]
584       },
585       "yaxes": [
586         {
587           "format": "decmbytes",
588           "label": "MB",
589           "logBase": 1,
590           "max": null,
591           "min": null,
592           "show": true
593         },
594         {
595           "format": "short",
596           "label": null,
597           "logBase": 1,
598           "max": null,
599           "min": null,
600           "show": true
601         }
602       ],
603       "yaxis": {
604         "align": false,
605         "alignLevel": null
606       }
607     },
608     {
609       "aliasColors": {},
610       "bars": false,
611       "dashLength": 10,
612       "dashes": false,
613       "datasource": "prometheus - Juju generated source",
614       "fill": 1,
615       "fillGradient": 0,
616       "gridPos": {
617         "h": 6,
618         "w": 12,
619         "x": 12,
620         "y": 13
621       },
622       "id": 5,
623       "legend": {
624         "avg": false,
625         "current": false,
626         "max": false,
627         "min": false,
628         "show": true,
629         "total": false,
630         "values": false
631       },
632       "lines": true,
633       "linewidth": 1,
634       "links": [],
635       "nullPointMode": "null",
636       "options": {
637         "dataLinks": []
638       },
639       "percentage": false,
640       "pointradius": 5,
641       "points": false,
642       "renderer": "flot",
643       "seriesOverrides": [],
644       "spaceLength": 10,
645       "stack": false,
646       "steppedLine": false,
647       "targets": [
648         {
649           "expr": "rate(mongodb_network_bytes_total{instance=~\"$instance\"}[$interval])",
650           "format": "time_series",
651           "interval": "",
652           "intervalFactor": 2,
653           "legendFormat": "{{state}}",
654           "metric": "mongodb_metrics_operation_total",
655           "refId": "A",
656           "step": 240
657         }
658       ],
659       "thresholds": [],
660       "timeFrom": null,
661       "timeRegions": [],
662       "timeShift": null,
663       "title": "Network I/O",
664       "tooltip": {
665         "shared": true,
666         "sort": 0,
667         "value_type": "individual"
668       },
669       "type": "graph",
670       "xaxis": {
671         "buckets": null,
672         "mode": "time",
673         "name": null,
674         "show": true,
675         "values": []
676       },
677       "yaxes": [
678         {
679           "format": "decbytes",
680           "label": null,
681           "logBase": 1,
682           "max": null,
683           "min": null,
684           "show": true
685         },
686         {
687           "format": "short",
688           "label": null,
689           "logBase": 1,
690           "max": null,
691           "min": null,
692           "show": true
693         }
694       ],
695       "yaxis": {
696         "align": false,
697         "alignLevel": null
698       }
699     }
700   ],
701   "refresh": "5s",
702   "schemaVersion": 19,
703   "style": "dark",
704   "tags": [],
705   "templating": {
706     "list": [
707       {
708         "allValue": null,
709         "current": {
710           "text": "All",
711           "value": "$__all"
712         },
713         "datasource": "prometheus - Juju generated source",
714         "definition": "",
715         "hide": 0,
716         "includeAll": true,
717         "label": "instance",
718         "multi": true,
719         "name": "instance",
720         "options": [],
721         "query": "label_values(mongodb_connections, instance)",
722         "refresh": 1,
723         "regex": "",
724         "skipUrlSync": false,
725         "sort": 1,
726         "tagValuesQuery": "/.*-(.*?)-.*/",
727         "tags": [],
728         "tagsQuery": "label_values(mongodb_connections, instance)",
729         "type": "query",
730         "useTags": false
731       },
732       {
733         "auto": true,
734         "auto_count": 30,
735         "auto_min": "10s",
736         "current": {
737           "text": "auto",
738           "value": "$__auto_interval_interval"
739         },
740         "hide": 0,
741         "label": null,
742         "name": "interval",
743         "options": [
744           {
745             "selected": true,
746             "text": "auto",
747             "value": "$__auto_interval_interval"
748           },
749           {
750             "selected": false,
751             "text": "1m",
752             "value": "1m"
753           },
754           {
755             "selected": false,
756             "text": "10m",
757             "value": "10m"
758           },
759           {
760             "selected": false,
761             "text": "30m",
762             "value": "30m"
763           },
764           {
765             "selected": false,
766             "text": "1h",
767             "value": "1h"
768           },
769           {
770             "selected": false,
771             "text": "6h",
772             "value": "6h"
773           },
774           {
775             "selected": false,
776             "text": "12h",
777             "value": "12h"
778           },
779           {
780             "selected": false,
781             "text": "1d",
782             "value": "1d"
783           },
784           {
785             "selected": false,
786             "text": "7d",
787             "value": "7d"
788           },
789           {
790             "selected": false,
791             "text": "14d",
792             "value": "14d"
793           },
794           {
795             "selected": false,
796             "text": "30d",
797             "value": "30d"
798           }
799         ],
800         "query": "1m,10m,30m,1h,6h,12h,1d,7d,14d,30d",
801         "refresh": 2,
802         "skipUrlSync": false,
803         "type": "interval"
804       }
805     ]
806   },
807   "time": {
808     "from": "now/d",
809     "to": "now"
810   },
811   "timepicker": {
812     "refresh_intervals": [
813       "5s",
814       "10s",
815       "30s",
816       "1m",
817       "5m",
818       "15m",
819       "30m",
820       "1h",
821       "2h",
822       "1d"
823     ],
824     "time_options": [
825       "5m",
826       "15m",
827       "1h",
828       "6h",
829       "12h",
830       "24h",
831       "2d",
832       "7d",
833       "30d"
834     ]
835   },
836   "timezone": "browser",
837   "title": "MongoDB",
838   "uid": "HEK4NbtZk",
839   "version": 2
840 }