Skip to content

Instantly share code, notes, and snippets.

@hatamiarash7

hatamiarash7/MongoDB.json

Created October 12, 2019 19:55
Show Gist options
  • Save hatamiarash7/7d92357af1832b80225c22b73ad7f78f to your computer and use it in GitHub Desktop.
Save hatamiarash7/7d92357af1832b80225c22b73ad7f78f to your computer and use it in GitHub Desktop.
Download ZIP
Chronograf MongoDB Dashboard
Raw
MongoDB.json
{
"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