Created
October 12, 2019 19:55
-
-
Save hatamiarash7/7d92357af1832b80225c22b73ad7f78f to your computer and use it in GitHub Desktop.
Chronograf MongoDB Dashboard
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "meta": { | |
| "chronografVersion": "1.7.14", | |
| "sources": { | |
| "1": { | |
| "name": "Influx 1", | |
| "link": "/chronograf/v1/sources/1" | |
| } | |
| } | |
| }, | |
| "dashboard": { | |
| "id": 14, | |
| "cells": [ | |
| { | |
| "i": "497e8f43-1513-4244-9f90-c221f89dec96", | |
| "x": 0, | |
| "y": 4, | |
| "w": 4, | |
| "h": 4, | |
| "name": "MongoDB – Read/Second", | |
| "queries": [ | |
| { | |
| "query": "SELECT mean(queries_per_sec) AS queries_per_second, mean(getmores_per_sec) AS getmores_per_second FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "label": "reads/s", | |
| "queryConfig": { | |
| "database": "", | |
| "measurement": "", | |
| "retentionPolicy": "", | |
| "fields": [], | |
| "tags": {}, | |
| "groupBy": { | |
| "time": "", | |
| "tags": [] | |
| }, | |
| "areTagsAccepted": false, | |
| "rawText": "SELECT mean(queries_per_sec) AS queries_per_second, mean(getmores_per_sec) AS getmores_per_second FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "range": null, | |
| "shifts": null | |
| }, | |
| "source": "/chronograf/v1/sources/1", | |
| "type": "influxql" | |
| } | |
| ], | |
| "axes": { | |
| "x": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y2": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| } | |
| }, | |
| "type": "line", | |
| "colors": [], | |
| "legend": {}, | |
| "tableOptions": { | |
| "verticalTimeAxis": true, | |
| "sortBy": { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| }, | |
| "wrapping": "truncate", | |
| "fixFirstColumn": true | |
| }, | |
| "fieldOptions": [ | |
| { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| } | |
| ], | |
| "timeFormat": "MM/DD/YYYY HH:mm:ss", | |
| "decimalPlaces": { | |
| "isEnforced": true, | |
| "digits": 2 | |
| }, | |
| "note": "", | |
| "noteVisibility": "default", | |
| "links": { | |
| "self": "/chronograf/v1/dashboards/14/cells/497e8f43-1513-4244-9f90-c221f89dec96" | |
| } | |
| }, | |
| { | |
| "i": "29cf9cab-8071-4344-913e-eccab52a727b", | |
| "x": 4, | |
| "y": 4, | |
| "w": 4, | |
| "h": 4, | |
| "name": "MongoDB – Writes/Second", | |
| "queries": [ | |
| { | |
| "query": "SELECT mean(inserts_per_sec) AS inserts_per_second, mean(updates_per_sec) AS updates_per_second, mean(deletes_per_sec) AS deletes_per_second FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "label": "writes/s", | |
| "queryConfig": { | |
| "database": "", | |
| "measurement": "", | |
| "retentionPolicy": "", | |
| "fields": [], | |
| "tags": {}, | |
| "groupBy": { | |
| "time": "", | |
| "tags": [] | |
| }, | |
| "areTagsAccepted": false, | |
| "rawText": "SELECT mean(inserts_per_sec) AS inserts_per_second, mean(updates_per_sec) AS updates_per_second, mean(deletes_per_sec) AS deletes_per_second FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "range": null, | |
| "shifts": null | |
| }, | |
| "source": "/chronograf/v1/sources/1", | |
| "type": "influxql" | |
| } | |
| ], | |
| "axes": { | |
| "x": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y2": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| } | |
| }, | |
| "type": "line", | |
| "colors": [], | |
| "legend": {}, | |
| "tableOptions": { | |
| "verticalTimeAxis": true, | |
| "sortBy": { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| }, | |
| "wrapping": "truncate", | |
| "fixFirstColumn": true | |
| }, | |
| "fieldOptions": [ | |
| { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| } | |
| ], | |
| "timeFormat": "MM/DD/YYYY HH:mm:ss", | |
| "decimalPlaces": { | |
| "isEnforced": true, | |
| "digits": 2 | |
| }, | |
| "note": "", | |
| "noteVisibility": "default", | |
| "links": { | |
| "self": "/chronograf/v1/dashboards/14/cells/29cf9cab-8071-4344-913e-eccab52a727b" | |
| } | |
| }, | |
| { | |
| "i": "265627dd-bcd4-4ded-a943-a96b5e496c1a", | |
| "x": 0, | |
| "y": 0, | |
| "w": 4, | |
| "h": 4, | |
| "name": "MongoDB – Active Connections", | |
| "queries": [ | |
| { | |
| "query": "SELECT mean(open_connections) AS open_connections FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "label": "count", | |
| "queryConfig": { | |
| "database": "", | |
| "measurement": "", | |
| "retentionPolicy": "", | |
| "fields": [], | |
| "tags": {}, | |
| "groupBy": { | |
| "time": "", | |
| "tags": [] | |
| }, | |
| "areTagsAccepted": false, | |
| "rawText": "SELECT mean(open_connections) AS open_connections FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "range": null, | |
| "shifts": null | |
| }, | |
| "source": "/chronograf/v1/sources/1", | |
| "type": "influxql" | |
| } | |
| ], | |
| "axes": { | |
| "x": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y2": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| } | |
| }, | |
| "type": "line", | |
| "colors": [], | |
| "legend": {}, | |
| "tableOptions": { | |
| "verticalTimeAxis": true, | |
| "sortBy": { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| }, | |
| "wrapping": "truncate", | |
| "fixFirstColumn": true | |
| }, | |
| "fieldOptions": [ | |
| { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| } | |
| ], | |
| "timeFormat": "MM/DD/YYYY HH:mm:ss", | |
| "decimalPlaces": { | |
| "isEnforced": true, | |
| "digits": 2 | |
| }, | |
| "note": "", | |
| "noteVisibility": "default", | |
| "links": { | |
| "self": "/chronograf/v1/dashboards/14/cells/265627dd-bcd4-4ded-a943-a96b5e496c1a" | |
| } | |
| }, | |
| { | |
| "i": "357d6995-1883-4e0e-9bab-435f7ee2bb72", | |
| "x": 8, | |
| "y": 4, | |
| "w": 4, | |
| "h": 4, | |
| "name": "MongoDB – Reads/Writes Waiting in Queue", | |
| "queries": [ | |
| { | |
| "query": "SELECT max(queued_reads) AS queued_reads, max(queued_writes) AS queued_writes FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "label": "count", | |
| "queryConfig": { | |
| "database": "", | |
| "measurement": "", | |
| "retentionPolicy": "", | |
| "fields": [], | |
| "tags": {}, | |
| "groupBy": { | |
| "time": "", | |
| "tags": [] | |
| }, | |
| "areTagsAccepted": false, | |
| "rawText": "SELECT max(queued_reads) AS queued_reads, max(queued_writes) AS queued_writes FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "range": null, | |
| "shifts": null | |
| }, | |
| "source": "/chronograf/v1/sources/1", | |
| "type": "influxql" | |
| } | |
| ], | |
| "axes": { | |
| "x": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y2": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| } | |
| }, | |
| "type": "line", | |
| "colors": [], | |
| "legend": {}, | |
| "tableOptions": { | |
| "verticalTimeAxis": true, | |
| "sortBy": { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| }, | |
| "wrapping": "truncate", | |
| "fixFirstColumn": true | |
| }, | |
| "fieldOptions": [ | |
| { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| } | |
| ], | |
| "timeFormat": "MM/DD/YYYY HH:mm:ss", | |
| "decimalPlaces": { | |
| "isEnforced": true, | |
| "digits": 2 | |
| }, | |
| "note": "", | |
| "noteVisibility": "default", | |
| "links": { | |
| "self": "/chronograf/v1/dashboards/14/cells/357d6995-1883-4e0e-9bab-435f7ee2bb72" | |
| } | |
| }, | |
| { | |
| "i": "4f793a77-d835-4a3a-b30b-23a20564e4dc", | |
| "x": 0, | |
| "y": 8, | |
| "w": 4, | |
| "h": 4, | |
| "name": "MongoDB – Network Bytes/Second", | |
| "queries": [ | |
| { | |
| "query": "SELECT mean(net_in_bytes) AS net_in_bytes, mean(net_out_bytes) AS net_out_bytes FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "label": "bytes/s", | |
| "queryConfig": { | |
| "database": "", | |
| "measurement": "", | |
| "retentionPolicy": "", | |
| "fields": [], | |
| "tags": {}, | |
| "groupBy": { | |
| "time": "", | |
| "tags": [] | |
| }, | |
| "areTagsAccepted": false, | |
| "rawText": "SELECT mean(net_in_bytes) AS net_in_bytes, mean(net_out_bytes) AS net_out_bytes FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "range": null, | |
| "shifts": null | |
| }, | |
| "source": "/chronograf/v1/sources/1", | |
| "type": "influxql" | |
| } | |
| ], | |
| "axes": { | |
| "x": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y2": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| } | |
| }, | |
| "type": "line", | |
| "colors": [], | |
| "legend": {}, | |
| "tableOptions": { | |
| "verticalTimeAxis": true, | |
| "sortBy": { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| }, | |
| "wrapping": "truncate", | |
| "fixFirstColumn": true | |
| }, | |
| "fieldOptions": [ | |
| { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| } | |
| ], | |
| "timeFormat": "MM/DD/YYYY HH:mm:ss", | |
| "decimalPlaces": { | |
| "isEnforced": true, | |
| "digits": 2 | |
| }, | |
| "note": "", | |
| "noteVisibility": "default", | |
| "links": { | |
| "self": "/chronograf/v1/dashboards/14/cells/4f793a77-d835-4a3a-b30b-23a20564e4dc" | |
| } | |
| }, | |
| { | |
| "i": "e3f7b1b1-f104-40f1-8dc0-0b2a130bbf72", | |
| "x": 8, | |
| "y": 0, | |
| "w": 4, | |
| "h": 4, | |
| "name": "MongoDB – Commands", | |
| "queries": [ | |
| { | |
| "query": "SELECT mean(commands_per_sec) AS commands_per_second FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "label": "commands/s", | |
| "queryConfig": { | |
| "database": "", | |
| "measurement": "", | |
| "retentionPolicy": "", | |
| "fields": [], | |
| "tags": {}, | |
| "groupBy": { | |
| "time": "", | |
| "tags": [] | |
| }, | |
| "areTagsAccepted": false, | |
| "rawText": "SELECT mean(commands_per_sec) AS commands_per_second FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "range": null, | |
| "shifts": null | |
| }, | |
| "source": "/chronograf/v1/sources/1", | |
| "type": "influxql" | |
| } | |
| ], | |
| "axes": { | |
| "x": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y2": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| } | |
| }, | |
| "type": "line", | |
| "colors": [], | |
| "legend": {}, | |
| "tableOptions": { | |
| "verticalTimeAxis": true, | |
| "sortBy": { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| }, | |
| "wrapping": "truncate", | |
| "fixFirstColumn": true | |
| }, | |
| "fieldOptions": [ | |
| { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| } | |
| ], | |
| "timeFormat": "MM/DD/YYYY HH:mm:ss", | |
| "decimalPlaces": { | |
| "isEnforced": true, | |
| "digits": 2 | |
| }, | |
| "note": "", | |
| "noteVisibility": "default", | |
| "links": { | |
| "self": "/chronograf/v1/dashboards/14/cells/e3f7b1b1-f104-40f1-8dc0-0b2a130bbf72" | |
| } | |
| }, | |
| { | |
| "i": "39c06a14-907d-491f-88a5-5510b5679da9", | |
| "x": 4, | |
| "y": 0, | |
| "w": 4, | |
| "h": 4, | |
| "name": "MongoDB – Memory Usage (MB)", | |
| "queries": [ | |
| { | |
| "query": "SELECT mean(vsize_megabytes) AS virtual_memory_megabytes, mean(resident_megabytes) AS resident_memory_megabytes FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "label": "MB", | |
| "queryConfig": { | |
| "database": "", | |
| "measurement": "", | |
| "retentionPolicy": "", | |
| "fields": [], | |
| "tags": {}, | |
| "groupBy": { | |
| "time": "", | |
| "tags": [] | |
| }, | |
| "areTagsAccepted": false, | |
| "rawText": "SELECT mean(vsize_megabytes) AS virtual_memory_megabytes, mean(resident_megabytes) AS resident_memory_megabytes FROM \"telegraf\".\"autogen\".\"mongodb\" WHERE time > :dashboardTime: AND \"host\" = :host: GROUP BY time(:interval:)", | |
| "range": null, | |
| "shifts": null | |
| }, | |
| "source": "/chronograf/v1/sources/1", | |
| "type": "influxql" | |
| } | |
| ], | |
| "axes": { | |
| "x": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| }, | |
| "y2": { | |
| "bounds": [ | |
| "", | |
| "" | |
| ], | |
| "label": "", | |
| "prefix": "", | |
| "suffix": "", | |
| "base": "10", | |
| "scale": "linear" | |
| } | |
| }, | |
| "type": "line", | |
| "colors": [], | |
| "legend": {}, | |
| "tableOptions": { | |
| "verticalTimeAxis": true, | |
| "sortBy": { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| }, | |
| "wrapping": "truncate", | |
| "fixFirstColumn": true | |
| }, | |
| "fieldOptions": [ | |
| { | |
| "internalName": "time", | |
| "displayName": "", | |
| "visible": true | |
| } | |
| ], | |
| "timeFormat": "MM/DD/YYYY HH:mm:ss", | |
| "decimalPlaces": { | |
| "isEnforced": true, | |
| "digits": 2 | |
| }, | |
| "note": "", | |
| "noteVisibility": "default", | |
| "links": { | |
| "self": "/chronograf/v1/dashboards/14/cells/39c06a14-907d-491f-88a5-5510b5679da9" | |
| } | |
| } | |
| ], | |
| "templates": [ | |
| { | |
| "tempVar": ":host:", | |
| "values": [ | |
| { | |
| "value": "shetabhub.local", | |
| "type": "tagValue", | |
| "selected": true | |
| } | |
| ], | |
| "id": "6fd9f3cb-4e17-4221-84d2-083d6bb84f49", | |
| "type": "tagValues", | |
| "label": "", | |
| "query": { | |
| "influxql": "SHOW TAG VALUES ON :database: FROM :measurement: WITH KEY=:tagKey:", | |
| "db": "telegraf", | |
| "measurement": "mongodb", | |
| "tagKey": "host", | |
| "fieldKey": "" | |
| }, | |
| "links": { | |
| "self": "/chronograf/v1/dashboards/14/templates/6fd9f3cb-4e17-4221-84d2-083d6bb84f49" | |
| } | |
| } | |
| ], | |
| "name": "MongoDB", | |
| "organization": "default", | |
| "links": { | |
| "self": "/chronograf/v1/dashboards/14", | |
| "cells": "/chronograf/v1/dashboards/14/cells", | |
| "templates": "/chronograf/v1/dashboards/14/templates" | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment