sample-dashboard/provisioning/performance-request.json in influxdb-rails-1.0.1.beta3 vs sample-dashboard/provisioning/performance-request.json in influxdb-rails-1.0.1
- old
+ new
@@ -1,46 +1,52 @@
{
"__inputs": [
{
- "name": "DS_INFLUXDB",
- "label": "InfluxDB",
+ "name": "DS_INFLUXDB-RAILS",
+ "label": "InfluxDB-Rails",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
}
],
"__requires": [
{
+ "type": "panel",
+ "id": "bargauge",
+ "name": "Bar gauge",
+ "version": ""
+ },
+ {
"type": "grafana",
"id": "grafana",
"name": "Grafana",
- "version": "6.2.4"
+ "version": "7.1.1"
},
{
"type": "datasource",
"id": "influxdb",
"name": "InfluxDB",
"version": "1.0.0"
},
{
"type": "panel",
- "id": "singlestat",
- "name": "Singlestat",
+ "id": "stat",
+ "name": "Stat",
"version": ""
},
{
"type": "panel",
- "id": "table",
- "name": "Table",
+ "id": "table-old",
+ "name": "Table (old)",
"version": ""
},
{
"type": "panel",
"id": "text",
"name": "Text",
- "version": ""
+ "version": "7.1.0"
}
],
"annotations": {
"list": [
{
@@ -52,95 +58,116 @@
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
- "description": "Ruby on Rails Request Performance Insights based on influxdb-rails",
+ "description": "",
"editable": true,
"gnetId": 10429,
"graphTooltip": 0,
"id": null,
- "iteration": 1571753874432,
- "links": [],
+ "iteration": 1616428738654,
+ "links": [
+ {
+ "$$hashKey": "object:392",
+ "icon": "external link",
+ "tags": [
+ "influxdb-rails"
+ ],
+ "type": "dashboards"
+ }
+ ],
"panels": [
{
"content": "## Details for $method ($request_id)",
+ "datasource": "InfluxDB",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {}
+ },
+ "overrides": []
+ },
"gridPos": {
"h": 2,
"w": 24,
"x": 0,
"y": 0
},
"id": 4,
"links": [],
"mode": "markdown",
- "options": {},
+ "options": {
+ "content": "## Details for $method ($request_id)",
+ "mode": "markdown"
+ },
+ "pluginVersion": "7.1.0",
"title": "",
"type": "text"
},
{
"cacheTimeout": null,
- "colorBackground": false,
- "colorPrefix": false,
- "colorValue": true,
- "colors": [
- "#299c46",
- "rgba(237, 129, 40, 0.89)",
- "#d44a3a"
- ],
"datasource": "InfluxDB",
"description": "",
- "format": "ms",
- "gauge": {
- "maxValue": 100,
- "minValue": 0,
- "show": false,
- "thresholdLabels": false,
- "thresholdMarkers": true
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "mappings": [
+ {
+ "id": 0,
+ "op": "=",
+ "text": "N/A",
+ "type": 1,
+ "value": "null"
+ }
+ ],
+ "nullValueMode": "connected",
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "#299c46",
+ "value": null
+ },
+ {
+ "color": "rgba(237, 129, 40, 0.89)",
+ "value": 200
+ },
+ {
+ "color": "#d44a3a",
+ "value": 300
+ }
+ ]
+ },
+ "unit": "ms"
+ },
+ "overrides": []
},
"gridPos": {
"h": 3,
"w": 8,
"x": 0,
"y": 2
},
"id": 2,
"interval": null,
"links": [],
- "mappingType": 1,
- "mappingTypes": [
- {
- "name": "value to text",
- "value": 1
- },
- {
- "name": "range to text",
- "value": 2
- }
- ],
"maxDataPoints": 100,
- "nullPointMode": "connected",
- "nullText": null,
- "options": {},
- "postfix": "",
- "postfixFontSize": "50%",
- "prefix": "",
- "prefixFontSize": "50%",
- "rangeMaps": [
- {
- "from": "null",
- "text": "N/A",
- "to": "null"
- }
- ],
- "sparkline": {
- "fillColor": "rgba(31, 118, 189, 0.18)",
- "full": false,
- "lineColor": "rgb(31, 120, 193)",
- "show": false
+ "options": {
+ "colorMode": "value",
+ "graphMode": "none",
+ "justifyMode": "auto",
+ "orientation": "horizontal",
+ "reduceOptions": {
+ "calcs": [
+ "sum"
+ ],
+ "fields": "",
+ "values": false
+ },
+ "textMode": "auto"
},
- "tableColumn": "",
+ "pluginVersion": "7.1.1",
"targets": [
{
"groupBy": [],
"measurement": "rails",
"orderByTime": "ASC",
@@ -170,83 +197,75 @@
"value": "process_action"
}
]
}
],
- "thresholds": "200,300",
"title": "Total Controller Action Runtime",
- "type": "singlestat",
- "valueFontSize": "80%",
- "valueMaps": [
- {
- "op": "=",
- "text": "N/A",
- "value": "null"
- }
- ],
- "valueName": "total"
+ "type": "stat"
},
{
"cacheTimeout": null,
- "colorBackground": false,
- "colorValue": true,
- "colors": [
- "#299c46",
- "rgba(237, 129, 40, 0.89)",
- "#d44a3a"
- ],
"datasource": "InfluxDB",
- "format": "ms",
- "gauge": {
- "maxValue": 100,
- "minValue": 0,
- "show": false,
- "thresholdLabels": false,
- "thresholdMarkers": true
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "mappings": [
+ {
+ "id": 0,
+ "op": "=",
+ "text": "N/A",
+ "type": 1,
+ "value": "null"
+ }
+ ],
+ "nullValueMode": "connected",
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "#299c46",
+ "value": null
+ },
+ {
+ "color": "rgba(237, 129, 40, 0.89)",
+ "value": 200
+ },
+ {
+ "color": "#d44a3a",
+ "value": 300
+ }
+ ]
+ },
+ "unit": "ms"
+ },
+ "overrides": []
},
"gridPos": {
"h": 3,
"w": 8,
"x": 8,
"y": 2
},
"id": 6,
"interval": null,
"links": [],
- "mappingType": 1,
- "mappingTypes": [
- {
- "name": "value to text",
- "value": 1
- },
- {
- "name": "range to text",
- "value": 2
- }
- ],
"maxDataPoints": 100,
- "nullPointMode": "connected",
- "nullText": null,
- "options": {},
- "postfix": "",
- "postfixFontSize": "50%",
- "prefix": "",
- "prefixFontSize": "50%",
- "rangeMaps": [
- {
- "from": "null",
- "text": "N/A",
- "to": "null"
- }
- ],
- "sparkline": {
- "fillColor": "rgba(31, 118, 189, 0.18)",
- "full": false,
- "lineColor": "rgb(31, 120, 193)",
- "show": false
+ "options": {
+ "colorMode": "value",
+ "graphMode": "none",
+ "justifyMode": "auto",
+ "orientation": "horizontal",
+ "reduceOptions": {
+ "calcs": [
+ "mean"
+ ],
+ "fields": "",
+ "values": false
+ },
+ "textMode": "auto"
},
- "tableColumn": "",
+ "pluginVersion": "7.1.1",
"targets": [
{
"groupBy": [],
"measurement": "rails",
"orderByTime": "ASC",
@@ -276,83 +295,75 @@
"value": "process_action"
}
]
}
],
- "thresholds": "200,300",
"title": "Total Database Query Runtime",
- "type": "singlestat",
- "valueFontSize": "80%",
- "valueMaps": [
- {
- "op": "=",
- "text": "N/A",
- "value": "null"
- }
- ],
- "valueName": "avg"
+ "type": "stat"
},
{
"cacheTimeout": null,
- "colorBackground": false,
- "colorValue": true,
- "colors": [
- "#299c46",
- "rgba(237, 129, 40, 0.89)",
- "#d44a3a"
- ],
"datasource": "InfluxDB",
- "format": "ms",
- "gauge": {
- "maxValue": 100,
- "minValue": 0,
- "show": false,
- "thresholdLabels": false,
- "thresholdMarkers": true
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "mappings": [
+ {
+ "id": 0,
+ "op": "=",
+ "text": "0",
+ "type": 1,
+ "value": "null"
+ }
+ ],
+ "nullValueMode": "connected",
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "#299c46",
+ "value": null
+ },
+ {
+ "color": "rgba(237, 129, 40, 0.89)",
+ "value": 200
+ },
+ {
+ "color": "#d44a3a",
+ "value": 300
+ }
+ ]
+ },
+ "unit": "ms"
+ },
+ "overrides": []
},
"gridPos": {
"h": 3,
"w": 8,
"x": 16,
"y": 2
},
"id": 8,
"interval": null,
"links": [],
- "mappingType": 1,
- "mappingTypes": [
- {
- "name": "value to text",
- "value": 1
- },
- {
- "name": "range to text",
- "value": 2
- }
- ],
"maxDataPoints": 100,
- "nullPointMode": "connected",
- "nullText": null,
- "options": {},
- "postfix": "",
- "postfixFontSize": "50%",
- "prefix": "",
- "prefixFontSize": "50%",
- "rangeMaps": [
- {
- "from": "null",
- "text": "N/A",
- "to": "null"
- }
- ],
- "sparkline": {
- "fillColor": "rgba(31, 118, 189, 0.18)",
- "full": false,
- "lineColor": "rgb(31, 120, 193)",
- "show": false
+ "options": {
+ "colorMode": "value",
+ "graphMode": "none",
+ "justifyMode": "auto",
+ "orientation": "horizontal",
+ "reduceOptions": {
+ "calcs": [
+ "mean"
+ ],
+ "fields": "",
+ "values": false
+ },
+ "textMode": "auto"
},
- "tableColumn": "",
+ "pluginVersion": "7.1.1",
"targets": [
{
"groupBy": [],
"measurement": "rails",
"orderByTime": "ASC",
@@ -382,53 +393,52 @@
"value": "render_template"
}
]
}
],
- "thresholds": "200,300",
"title": "Total View Rendering Runtime",
- "type": "singlestat",
- "valueFontSize": "80%",
- "valueMaps": [
- {
- "op": "=",
- "text": "N/A",
- "value": "null"
- }
- ],
- "valueName": "avg"
+ "type": "stat"
},
{
"columns": [],
"datasource": "InfluxDB",
"description": "Database queries in this request.\n\n- Count: Number of occurrences\n- Mean: Average time spent in this query\n- Maximum: Slowest occurrence\n- Total: Total amount of time spent in this query",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {}
+ },
+ "overrides": []
+ },
"fontSize": "100%",
"gridPos": {
- "h": 8,
- "w": 24,
+ "h": 7,
+ "w": 12,
"x": 0,
"y": 5
},
"id": 12,
"links": [],
- "options": {},
"pageSize": null,
"scroll": true,
"showHeader": true,
"sort": {
- "col": 4,
+ "col": 5,
"desc": true
},
"styles": [
{
+ "$$hashKey": "object:554",
"alias": "Time",
+ "align": "auto",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"pattern": "Time",
"type": "hidden"
},
{
+ "$$hashKey": "object:555",
"alias": "Count",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -440,27 +450,40 @@
"thresholds": [],
"type": "number",
"unit": "short"
},
{
+ "$$hashKey": "object:556",
"alias": "Query",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
],
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"decimals": 2,
"mappingType": 1,
"pattern": "name",
+ "preserveFormat": false,
+ "sanitize": false,
"thresholds": [],
- "type": "number",
- "unit": "short"
+ "type": "string",
+ "unit": "short",
+ "valueMaps": [
+ {
+ "$$hashKey": "object:823",
+ "text": "Unkown",
+ "value": ""
+ }
+ ]
},
{
+ "$$hashKey": "object:557",
"alias": "Mean",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -472,11 +495,13 @@
"thresholds": [],
"type": "number",
"unit": "ms"
},
{
+ "$$hashKey": "object:558",
"alias": "Maximum",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -488,11 +513,13 @@
"thresholds": [],
"type": "number",
"unit": "ms"
},
{
+ "$$hashKey": "object:559",
"alias": "Total",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -504,11 +531,13 @@
"thresholds": [],
"type": "number",
"unit": "ms"
},
{
+ "$$hashKey": "object:560",
"alias": "",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -600,42 +629,149 @@
]
}
],
"title": "Database Queries",
"transform": "table",
- "type": "table"
+ "type": "table-old"
},
{
+ "cacheTimeout": null,
+ "datasource": "InfluxDB",
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ },
+ {
+ "color": "yellow",
+ "value": 100
+ },
+ {
+ "color": "red",
+ "value": 200
+ }
+ ]
+ },
+ "unit": "short"
+ },
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 7,
+ "w": 12,
+ "x": 12,
+ "y": 5
+ },
+ "id": 17,
+ "interval": null,
+ "links": [],
+ "maxDataPoints": 3,
+ "options": {
+ "displayMode": "lcd",
+ "orientation": "horizontal",
+ "reduceOptions": {
+ "calcs": [
+ "mean"
+ ],
+ "fields": "",
+ "values": true
+ },
+ "showUnfilled": true
+ },
+ "pluginVersion": "7.1.1",
+ "targets": [
+ {
+ "alias": "$tag_class_name",
+ "groupBy": [
+ {
+ "params": [
+ "class_name"
+ ],
+ "type": "tag"
+ }
+ ],
+ "measurement": "rails",
+ "orderByTime": "ASC",
+ "policy": "default",
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "record_count"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "count"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "request_id",
+ "operator": "=~",
+ "value": "/^$request_id$/"
+ },
+ {
+ "condition": "AND",
+ "key": "hook",
+ "operator": "=",
+ "value": "instantiation"
+ }
+ ]
+ }
+ ],
+ "title": "Record Instantiation",
+ "type": "bargauge"
+ },
+ {
"columns": [],
"datasource": "InfluxDB",
"description": "Views rendered in this request.\n\n- Count: Number of occurrences\n- Mean: Average time spent in this query\n- Maximum: Slowest occurrence",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {}
+ },
+ "overrides": []
+ },
"fontSize": "100%",
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
- "y": 13
+ "y": 12
},
"id": 10,
"links": [],
- "options": {},
"pageSize": null,
"scroll": true,
"showHeader": true,
"sort": {
"col": 4,
"desc": true
},
"styles": [
{
"alias": "Time",
+ "align": "auto",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"pattern": "Time",
"type": "hidden"
},
{
"alias": "Count",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -648,10 +784,11 @@
"type": "number",
"unit": "short"
},
{
"alias": "Mean",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -664,10 +801,11 @@
"type": "number",
"unit": "ms"
},
{
"alias": "Maximum",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -680,10 +818,11 @@
"type": "number",
"unit": "ms"
},
{
"alias": "File",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -763,42 +902,49 @@
]
}
],
"title": "Views Rendered",
"transform": "table",
- "type": "table"
+ "type": "table-old"
},
{
"columns": [],
"datasource": "InfluxDB",
"description": "Partials rendered in this request.\n\n- Count: Number of occurrences\n- Mean: Average time spent in this partial\n- Maximum: Slowest occurrence\n- Total: Total time spent in this partial",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {}
+ },
+ "overrides": []
+ },
"fontSize": "100%",
"gridPos": {
"h": 9,
"w": 12,
"x": 12,
- "y": 13
+ "y": 12
},
"id": 16,
"links": [],
- "options": {},
"pageSize": null,
"scroll": true,
"showHeader": true,
"sort": {
- "col": 4,
+ "col": 5,
"desc": true
},
"styles": [
{
"alias": "Time",
+ "align": "auto",
"dateFormat": "YYYY-MM-DD HH:mm:ss",
"pattern": "Time",
"type": "hidden"
},
{
"alias": "Count",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -811,10 +957,11 @@
"type": "number",
"unit": "short"
},
{
"alias": "File",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -827,10 +974,11 @@
"type": "string",
"unit": "short"
},
{
"alias": "Mean",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -843,10 +991,11 @@
"type": "number",
"unit": "ms"
},
{
"alias": "Maximum",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -859,10 +1008,11 @@
"type": "number",
"unit": "ms"
},
{
"alias": "Total",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -875,10 +1025,11 @@
"type": "number",
"unit": "ms"
},
{
"alias": "",
+ "align": "auto",
"colorMode": null,
"colors": [
"rgba(245, 54, 54, 0.9)",
"rgba(237, 129, 40, 0.89)",
"rgba(50, 172, 45, 0.97)"
@@ -970,20 +1121,19 @@
]
}
],
"title": "Partials Rendered",
"transform": "table",
- "type": "table"
+ "type": "table-old"
}
],
"refresh": false,
- "schemaVersion": 18,
+ "schemaVersion": 26,
"style": "dark",
"tags": [
- "performance",
- "ruby on rails",
- "influxdb"
+ "Performance",
+ "Ruby on Rails"
],
"templating": {
"list": [
{
"current": {
@@ -998,11 +1148,11 @@
"selected": false,
"text": "",
"value": ""
}
],
- "query": "",
+ "query": "ba3c5e76-d15a-40fb-bb0c-a6dc0220fa8c",
"skipUrlSync": false,
"type": "textbox"
},
{
"current": {
@@ -1017,11 +1167,11 @@
"selected": false,
"text": "",
"value": ""
}
],
- "query": "",
+ "query": "Webui::PackageController#meta",
"skipUrlSync": false,
"type": "textbox"
}
]
},
@@ -1045,9 +1195,9 @@
"7d",
"30d"
]
},
"timezone": "",
- "title": "Ruby On Rails Performance (per Request)",
- "uid": "H8S9fSVWz",
- "version": 1
-}
+ "title": "Performance (per Request)",
+ "uid": "influxdb-rails-request",
+ "version": 9
+}
\ No newline at end of file