Skip to content

Instantly share code, notes, and snippets.

@dplate

dplate/mongodb_dashboard

Created October 30, 2014 07:34
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dplate/e7493b88f6159ddb52fb to your computer and use it in GitHub Desktop.
Save dplate/e7493b88f6159ddb52fb to your computer and use it in GitHub Desktop.
Download ZIP
Kibana MongoDB Dashboard
Raw
mongodb_dashboard
{
"title": "MongoDb",
"services": {
"query": {
"idQueue": [
3
],
"list": {
"0": {
"id": 0,
"color": "#6D1F62",
"query": "@fields.mongoCommand:\"getmore\"",
"alias": "GetMore",
"pin": false,
"type": "lucene"
},
"1": {
"id": 1,
"color": "#65C5DB",
"query": "@fields.mongoCommand:\"update\"",
"alias": "Update",
"pin": false,
"type": "lucene"
},
"2": {
"id": 2,
"color": "#BA43A9",
"query": "@fields.mongoCommand:\"command\"",
"alias": "Command",
"pin": false,
"type": "lucene"
},
"4": {
"id": 4,
"color": "#0A50A1",
"query": "@fields.mongoCommand:\"query\"",
"alias": "Query",
"pin": false,
"type": "lucene"
},
"5": {
"id": 5,
"color": "#7EB26D",
"query": "@fields.mongoElapsedTime:[0 TO 100]",
"alias": "<100ms",
"pin": false,
"type": "lucene"
},
"6": {
"id": 6,
"color": "#EAB839",
"query": "@fields.mongoElapsedTime:[100 TO 200]",
"alias": "<200ms",
"pin": false,
"type": "lucene"
},
"7": {
"id": 7,
"color": "#C15C17",
"query": "@fields.mongoElapsedTime:[200 TO 500]",
"alias": "<500ms",
"pin": false,
"type": "lucene"
},
"8": {
"id": 8,
"color": "#BF1B00",
"query": "@fields.mongoElapsedTime:[500 TO *]",
"alias": ">500ms",
"pin": false,
"type": "lucene"
}
},
"ids": [
4,
0,
1,
2,
5,
6,
7,
8
]
},
"filter": {
"idQueue": [
2,
3,
4,
5,
6
],
"list": {
"0": {
"from": "2014-10-30T06:30:32.478Z",
"to": "2014-10-30T07:30:32.479Z",
"field": "@timestamp",
"type": "time",
"mandate": "must",
"active": true,
"alias": "",
"id": 0
},
"1": {
"type": "field",
"field": "@type",
"query": "\"mongodb\"",
"mandate": "must",
"active": true,
"alias": "",
"id": 1
}
},
"ids": [
1,
0
]
}
},
"rows": [
{
"title": "Timespan",
"height": "20px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"error": "",
"span": 4,
"editable": true,
"type": "timepicker",
"loadingEditor": false,
"status": "Stable",
"mode": "relative",
"time_options": [
"5m",
"15m",
"1h",
"6h",
"12h",
"24h",
"2d",
"7d",
"30d"
],
"timespan": "1h",
"timefield": "@timestamp",
"timeformat": "",
"refresh": {
"enable": false,
"interval": 30,
"min": 3
},
"filter_id": 0
}
]
},
{
"title": "Total elapsed time",
"height": "150px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"span": 12,
"editable": true,
"type": "histogram",
"loadingEditor": false,
"mode": "total",
"time_field": "@timestamp",
"queries": {
"mode": "selected",
"ids": [
5,
6,
7,
8
]
},
"value_field": "@fields.mongoElapsedTime",
"auto_int": true,
"resolution": 100,
"interval": "30s",
"intervals": [
"auto",
"1s",
"1m",
"5m",
"10m",
"30m",
"1h",
"3h",
"12h",
"1d",
"1w",
"1M",
"1y"
],
"fill": 10,
"linewidth": 0,
"timezone": "browser",
"spyable": true,
"zoomlinks": true,
"bars": false,
"stack": true,
"points": false,
"lines": true,
"legend": true,
"x-axis": true,
"y-axis": false,
"percentage": false,
"interactive": true,
"options": true,
"tooltip": {
"value_type": "individual",
"query_as_alias": false
},
"title": "Elapsed time per performance class"
}
]
},
{
"title": "Requests",
"height": "350px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"loading": false,
"error": false,
"span": 12,
"editable": true,
"group": [
"default"
],
"type": "table",
"status": "Stable",
"query": "*",
"size": 10,
"pages": 5,
"offset": 0,
"sort": [
"@timestamp",
"desc"
],
"style": {
"font-size": "9pt"
},
"overflow": "min-height",
"fields": [
"@timestamp",
"@fields.mongoDatabase",
"@fields.mongoCommand",
"@fields.mongoStatement",
"@fields.mongoElapsedTime"
],
"highlight": [],
"sortable": true,
"header": true,
"paging": true,
"spyable": true,
"queries": {
"mode": "selected",
"ids": [
4,
0,
1,
2
]
},
"field_list": false,
"trimFactor": 300,
"normTimes": true,
"title": "All commands"
}
]
},
{
"title": "Top",
"height": "150px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"error": false,
"span": 3,
"editable": true,
"type": "table",
"loadingEditor": false,
"status": "Stable",
"queries": {
"mode": "selected",
"ids": [
4,
0,
1,
2
]
},
"size": 10,
"pages": 1,
"offset": 0,
"sort": [
"@fields.mongoElapsedTime",
"desc"
],
"group": "default",
"style": {
"font-size": "9pt"
},
"overflow": "min-height",
"fields": [
null,
"@fields.mongoElapsedTime",
"@fields.mongoDatabase"
],
"highlight": [],
"sortable": true,
"header": false,
"paging": false,
"field_list": false,
"trimFactor": 300,
"normTimes": true,
"spyable": false,
"title": "Slowest commands"
},
{
"error": false,
"span": 3,
"editable": true,
"type": "table",
"loadingEditor": false,
"status": "Stable",
"queries": {
"mode": "selected",
"ids": [
4,
0,
1,
2
]
},
"size": 10,
"pages": 1,
"offset": 0,
"sort": [
"@fields.mongoResultLength",
"desc"
],
"group": "default",
"style": {
"font-size": "9pt"
},
"overflow": "min-height",
"fields": [
"@fields.mongoResultLength",
"@fields.mongoDatabase"
],
"highlight": [],
"sortable": true,
"header": false,
"paging": false,
"field_list": false,
"trimFactor": 300,
"normTimes": true,
"spyable": true,
"title": "Most data returned"
},
{
"error": false,
"span": 3,
"editable": true,
"type": "table",
"loadingEditor": false,
"status": "Stable",
"queries": {
"mode": "selected",
"ids": [
4,
0,
1,
2
]
},
"size": 10,
"pages": 1,
"offset": 0,
"sort": [
"@fields.mongoNumberScanned",
"desc"
],
"group": "default",
"style": {
"font-size": "9pt"
},
"overflow": "min-height",
"fields": [
"@fields.mongoNumberScanned",
"@fields.mongoDatabase"
],
"highlight": [],
"sortable": true,
"header": false,
"paging": false,
"field_list": false,
"trimFactor": 300,
"normTimes": true,
"spyable": true,
"title": "Most scanned lines"
},
{
"error": false,
"span": 3,
"editable": true,
"type": "column",
"loadingEditor": false,
"panels": [
{
"loading": false,
"error": false,
"sizeable": false,
"span": 12,
"height": "150px",
"editable": true,
"type": "terms",
"field": "@fields.mongoCommand",
"size": 10,
"order": "count",
"chart": "pie",
"counter_pos": "none",
"donut": true,
"labels": true,
"queries": {
"mode": "selected",
"ids": [
4,
0,
1,
2
]
},
"exclude": [],
"missing": true,
"other": true,
"style": {
"font-size": "10pt"
},
"tilt": false,
"arrangement": "horizontal",
"spyable": true,
"title": "Command types"
},
{
"loading": false,
"sizeable": false,
"span": 12,
"height": "150px",
"editable": true,
"type": "hits",
"chart": "pie",
"counter_pos": "none",
"donut": true,
"labels": true,
"queries": {
"mode": "selected",
"ids": [
5,
6,
7,
8
]
},
"style": {
"font-size": "10pt"
},
"arrangement": "horizontal",
"tilt": false,
"spyable": true,
"title": "Performance classes"
}
],
"title": ""
}
]
},
{
"title": "Queries",
"height": "50px",
"editable": true,
"collapse": true,
"collapsable": true,
"panels": [
{
"loading": false,
"error": false,
"span": 12,
"editable": true,
"group": [
"default"
],
"type": "query",
"status": "Experimental",
"label": "Search",
"query": "*",
"history": [
"@fields.mongoElapsedTime:[500 TO *]",
"@fields.mongoElapsedTime:[200 TO 500]",
"@fields.mongoElapsedTime:[100 TO 200]",
"@fields.mongoElapsedTime:[50 TO 100]",
"@fields.mongoCommand:\"query\"",
"@fields.mongoCommand:\"command\"",
"@fields.mongoCommand:\"update\"",
"@fields.mongoCommand:\"getmore\"",
"@fields.mongoElapsedTime:[0 TO 50]",
"@fields.mongoElapsedTime:[0 TO 100]"
],
"remember": 10,
"pinned": true
}
]
},
{
"title": "Filters",
"height": "150px",
"editable": true,
"collapse": false,
"collapsable": true,
"panels": [
{
"error": false,
"span": 12,
"editable": true,
"type": "filtering",
"loadingEditor": false
}
]
}
],
"editable": true,
"index": {
"interval": "day",
"pattern": "[logstash-]YYYY.MM.DD",
"default": "logstash-*"
},
"style": "light",
"failover": false,
"panel_hints": true,
"loader": {
"save_gist": false,
"save_elasticsearch": true,
"save_local": true,
"save_default": true,
"save_temp": true,
"save_temp_ttl_enable": true,
"save_temp_ttl": "30d",
"load_gist": true,
"load_elasticsearch": true,
"load_elasticsearch_size": 20,
"load_local": true,
"hide": false
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment