Skip to content

Instantly share code, notes, and snippets.

@fatmcgav
Created October 20, 2015 16:26
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 fatmcgav/56eab3b31ce50207ac2a to your computer and use it in GitHub Desktop.
Save fatmcgav/56eab3b31ce50207ac2a to your computer and use it in GitHub Desktop.
Grafana InfluxDB 'found USER'
{
"id": 1,
"title": "New dashboard",
"originalTitle": "New dashboard",
"tags": [],
"style": "dark",
"timezone": "browser",
"editable": true,
"hideControls": false,
"sharedCrosshair": false,
"rows": [
{
"collapse": false,
"editable": true,
"height": "250px",
"panels": [
{
"aliasColors": {},
"bars": false,
"datasource": null,
"editable": true,
"error": false,
"fill": 1,
"grid": {
"leftLogBase": 1,
"leftMax": null,
"leftMin": null,
"rightLogBase": 1,
"rightMax": null,
"rightMin": null,
"threshold1": null,
"threshold1Color": "rgba(216, 200, 27, 0.27)",
"threshold2": null,
"threshold2Color": "rgba(234, 112, 112, 0.22)"
},
"id": 1,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 2,
"links": [],
"nullPointMode": "connected",
"percentage": false,
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [],
"span": 12,
"stack": false,
"steppedLine": false,
"targets": [
{
"fields": [
{
"func": "mean",
"name": "system"
},
{
"func": "mean",
"name": "iowait"
},
{
"func": "mean",
"name": "idle"
},
{
"func": "mean",
"name": "user"
}
],
"groupByTags": [
"host"
],
"measurement": "cpu",
"query": "SELECT mean(system), mean(iowait), mean(idle), mean(user) FROM \"cpu\" WHERE \"host\" =~ /sensu*/ AND $timeFilter GROUP BY time($interval), \"host\"",
"tags": [
{
"key": "host",
"operator": "=~",
"value": "/sensu*/"
}
]
}
],
"timeFrom": null,
"timeShift": null,
"title": "CPU Load",
"tooltip": {
"shared": true,
"value_type": "cumulative"
},
"type": "graph",
"x-axis": true,
"y-axis": true,
"y_formats": [
"short",
"short"
]
}
],
"title": "Row"
}
],
"nav": [
{
"collapse": false,
"enable": true,
"notice": false,
"now": true,
"refresh_intervals": [
"5s",
"10s",
"30s",
"1m",
"5m",
"15m",
"30m",
"1h",
"2h",
"1d"
],
"status": "Stable",
"time_options": [
"5m",
"15m",
"1h",
"6h",
"12h",
"24h",
"2d",
"7d",
"30d"
],
"type": "timepicker"
}
],
"time": {
"from": "now-6h",
"to": "now"
},
"templating": {
"list": []
},
"annotations": {
"list": []
},
"schemaVersion": 6,
"version": 0,
"links": []
}
[http] 2015/10/20 17:24:23 127.0.0.1 - admin [20/Oct/2015:17:24:23 +0100] GET /query?db=graphite&epoch=ms&q=SELECT+mean%28system%29%2C+mean%28iowait%29%2C+mean%28idle%29%2C+mean%28user%29+FROM+%22cpu%22+WHERE+%22host%22+%3D~+%2Fsensu%2A%2F+AND+time+%3E+now%28%29+-+6h+GROUP+BY+time%2810s%29%2C+%22host%22 HTTP/1.1 400 119 http://sensu.lt0772.local:3001/dashboard/db/new-dashboard Mozilla/5.0 (Macintosh; Intel Mac OS X 10_11_0) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.101 Safari/537.36 0663616e-7747-11e5-8053-000000000000 584.602µs
> select * from cpu limit 1
name: cpu
---------
time guest host idle iowait irq nice softirq steal system user
1445349415000000000 0 sensu 100 0 0 0 0 0 0 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment