sample-dashboard/Ruby On Rails Performance.json in influxdb-rails-1.0.1.beta3 vs sample-dashboard/Ruby On Rails Performance.json in influxdb-rails-1.0.1
- old
+ new
@@ -1,10 +1,10 @@
{
"__inputs": [
{
- "name": "DS_INFLUXDB",
- "label": "InfluxDB",
+ "name": "DS_INFLUXDB-RAILS",
+ "label": "InfluxDB-Rails",
"description": "",
"type": "datasource",
"pluginId": "influxdb",
"pluginName": "InfluxDB"
}
@@ -12,11 +12,11 @@
"__requires": [
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
- "version": "6.2.4"
+ "version": "7.1.1"
},
{
"type": "panel",
"id": "graph",
"name": "Graph",
@@ -28,19 +28,13 @@
"name": "InfluxDB",
"version": "1.0.0"
},
{
"type": "panel",
- "id": "singlestat",
- "name": "Singlestat",
+ "id": "stat",
+ "name": "Stat",
"version": ""
- },
- {
- "type": "panel",
- "id": "table",
- "name": "Table",
- "version": ""
}
],
"annotations": {
"list": [
{
@@ -52,87 +46,85 @@
"name": "Annotations & Alerts",
"type": "dashboard"
}
]
},
- "description": "Ruby on Rails Performance Insights based on influxdb and influxdb-rails",
+ "description": "Insights based on influxdb-rails",
"editable": true,
"gnetId": 10428,
"graphTooltip": 0,
"id": null,
- "iteration": 1571758610473,
- "links": [],
+ "iteration": 1616428241231,
+ "links": [
+ {
+ "$$hashKey": "object:269",
+ "icon": "external link",
+ "includeVars": true,
+ "keepTime": true,
+ "tags": [
+ "influxdb-rails"
+ ],
+ "targetBlank": false,
+ "type": "dashboards"
+ }
+ ],
"panels": [
{
"cacheTimeout": null,
- "colorBackground": false,
- "colorValue": true,
- "colors": [
- "#299c46",
- "rgba(237, 129, 40, 0.89)",
- "#d44a3a"
- ],
- "datasource": "${DS_INFLUXDB}",
- "description": "",
- "format": "ms",
- "gauge": {
- "maxValue": 100,
- "minValue": 0,
- "show": false,
- "thresholdLabels": false,
- "thresholdMarkers": true
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "displayName": "Requests",
+ "mappings": [],
+ "nullValueMode": "connected",
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ }
+ ]
+ },
+ "unit": "short"
+ },
+ "overrides": []
},
- "id": 10,
+ "gridPos": {
+ "h": 3,
+ "w": 4,
+ "x": 0,
+ "y": 0
+ },
+ "id": 16,
"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": true
+ "options": {
+ "colorMode": "value",
+ "graphMode": "none",
+ "justifyMode": "center",
+ "orientation": "horizontal",
+ "reduceOptions": {
+ "calcs": [
+ "sum"
+ ],
+ "fields": "",
+ "values": false
+ },
+ "textMode": "auto"
},
- "tableColumn": "",
+ "pluginVersion": "7.1.1",
"targets": [
{
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
- },
- {
- "params": [
- "null"
- ],
- "type": "fill"
}
],
"hide": false,
"measurement": "rails",
"orderByTime": "ASC",
@@ -141,17 +133,17 @@
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "controller"
+ "request_id"
],
"type": "field"
},
{
"params": [],
- "type": "mean"
+ "type": "count"
}
]
],
"tags": [
{
@@ -160,97 +152,144 @@
"value": "process_action"
}
]
}
],
- "thresholds": "200,300",
- "title": "Average Controller Action Time",
- "type": "singlestat",
- "valueFontSize": "80%",
- "valueMaps": [
- {
- "op": "=",
- "text": "N/A",
- "value": "null"
- }
- ],
- "valueName": "avg"
+ "title": "Requests served",
+ "type": "stat"
},
{
- "cacheTimeout": null,
- "colorBackground": false,
- "colorValue": true,
- "colors": [
- "#299c46",
- "rgba(237, 129, 40, 0.89)",
- "#d44a3a"
- ],
- "datasource": "${DS_INFLUXDB}",
- "format": "ms",
- "gauge": {
- "maxValue": 100,
- "minValue": 0,
- "show": false,
- "thresholdLabels": false,
- "thresholdMarkers": true
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ }
+ ]
+ }
+ },
+ "overrides": []
},
"gridPos": {
"h": 3,
- "w": 6,
- "x": 6,
+ "w": 4,
+ "x": 4,
"y": 0
},
- "id": 12,
- "interval": null,
- "links": [],
- "mappingType": 1,
- "mappingTypes": [
- {
- "name": "value to text",
- "value": 1
+ "id": 26,
+ "options": {
+ "colorMode": "value",
+ "graphMode": "none",
+ "justifyMode": "auto",
+ "orientation": "auto",
+ "reduceOptions": {
+ "calcs": [
+ "sum"
+ ],
+ "fields": "",
+ "values": false
},
- {
- "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": true
+ "textMode": "auto"
},
- "tableColumn": "",
+ "pluginVersion": "7.1.1",
"targets": [
{
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
- },
+ }
+ ],
+ "measurement": "rails",
+ "orderByTime": "ASC",
+ "policy": "default",
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "value"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "count"
+ }
+ ]
+ ],
+ "tags": [
{
+ "key": "hook",
+ "operator": "=",
+ "value": "perform"
+ }
+ ]
+ }
+ ],
+ "timeFrom": null,
+ "timeShift": null,
+ "title": "Jobs Executed",
+ "type": "stat"
+ },
+ {
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "mappings": [],
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "green",
+ "value": null
+ }
+ ]
+ }
+ },
+ "overrides": []
+ },
+ "gridPos": {
+ "h": 3,
+ "w": 4,
+ "x": 8,
+ "y": 0
+ },
+ "id": 27,
+ "options": {
+ "colorMode": "value",
+ "graphMode": "none",
+ "justifyMode": "auto",
+ "orientation": "auto",
+ "reduceOptions": {
+ "calcs": [
+ "sum"
+ ],
+ "fields": "",
+ "values": false
+ },
+ "textMode": "auto"
+ },
+ "pluginVersion": "7.1.1",
+ "targets": [
+ {
+ "groupBy": [
+ {
"params": [
- "null"
+ "$per"
],
- "type": "fill"
+ "type": "time"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
@@ -258,122 +297,117 @@
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "db"
+ "value"
],
"type": "field"
},
{
"params": [],
- "type": "mean"
+ "type": "count"
}
]
],
"tags": [
{
"key": "hook",
"operator": "=",
- "value": "process_action"
+ "value": "deliver"
}
]
}
],
- "thresholds": "50,100",
- "title": "Average Database Query Time",
- "type": "singlestat",
- "valueFontSize": "80%",
- "valueMaps": [
- {
- "op": "=",
- "text": "N/A",
- "value": "null"
- }
- ],
- "valueName": "avg"
+ "timeFrom": null,
+ "timeShift": null,
+ "title": "Mails Sent",
+ "type": "stat"
},
{
"cacheTimeout": null,
- "colorBackground": false,
- "colorValue": true,
- "colors": [
- "#299c46",
- "rgba(237, 129, 40, 0.89)",
- "#d44a3a"
- ],
- "datasource": "${DS_INFLUXDB}",
- "format": "ms",
- "gauge": {
- "maxValue": 100,
- "minValue": 0,
- "show": false,
- "thresholdLabels": false,
- "thresholdMarkers": true
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "description": "",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "displayName": "Response Time",
+ "mappings": [],
+ "nullValueMode": "connected",
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "#299c46",
+ "value": null
+ },
+ {
+ "color": "yellow",
+ "value": 150
+ },
+ {
+ "color": "red",
+ "value": 300
+ }
+ ]
+ },
+ "unit": "ms"
+ },
+ "overrides": []
},
"gridPos": {
"h": 3,
- "w": 6,
+ "w": 4,
"x": 12,
"y": 0
},
- "id": 14,
+ "id": 10,
"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": true
+ "options": {
+ "colorMode": "value",
+ "graphMode": "none",
+ "justifyMode": "center",
+ "orientation": "horizontal",
+ "reduceOptions": {
+ "calcs": [
+ "mean"
+ ],
+ "fields": "",
+ "values": false
+ },
+ "textMode": "auto"
},
- "tableColumn": "",
+ "pluginVersion": "7.1.1",
"targets": [
{
"groupBy": [
{
"params": [
- "$interval"
+ "$per"
],
"type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
}
],
+ "hide": false,
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "view"
+ "controller"
],
"type": "field"
},
{
"params": [],
@@ -388,104 +422,100 @@
"value": "process_action"
}
]
}
],
- "thresholds": "50,100",
- "title": "Average View Rendering Time",
- "type": "singlestat",
- "valueFontSize": "80%",
- "valueMaps": [
- {
- "op": "=",
- "text": "N/A",
- "value": "null"
- }
- ],
- "valueName": "avg"
+ "title": "Average Response",
+ "type": "stat"
},
{
"cacheTimeout": null,
- "colorBackground": false,
- "colorValue": false,
- "colors": [
- "#299c46",
- "rgba(237, 129, 40, 0.89)",
- "#d44a3a"
- ],
- "datasource": "${DS_INFLUXDB}",
- "decimals": null,
- "format": "short",
- "gauge": {
- "maxValue": 100,
- "minValue": 0,
- "show": false,
- "thresholdLabels": false,
- "thresholdMarkers": true
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "displayName": "Response Time",
+ "mappings": [],
+ "nullValueMode": "connected",
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "#299c46",
+ "value": null
+ },
+ {
+ "color": "rgba(237, 129, 40, 0.89)",
+ "value": 50
+ },
+ {
+ "color": "#d44a3a",
+ "value": 100
+ }
+ ]
+ },
+ "unit": "ms"
+ },
+ "overrides": []
},
"gridPos": {
"h": 3,
- "w": 6,
- "x": 18,
+ "w": 4,
+ "x": 16,
"y": 0
},
- "id": 16,
+ "id": 12,
"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": "center",
+ "orientation": "horizontal",
+ "reduceOptions": {
+ "calcs": [
+ "mean"
+ ],
+ "fields": "",
+ "values": false
+ },
+ "textMode": "auto"
},
- "tableColumn": "",
+ "pluginVersion": "7.1.1",
"targets": [
{
- "groupBy": [],
- "hide": false,
+ "groupBy": [
+ {
+ "params": [
+ "$per"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "request_id"
+ "db"
],
"type": "field"
},
{
"params": [],
- "type": "count"
+ "type": "mean"
}
]
],
"tags": [
{
@@ -494,131 +524,176 @@
"value": "process_action"
}
]
}
],
- "thresholds": "",
- "title": "Total Number of Requests",
- "type": "singlestat",
- "valueFontSize": "80%",
- "valueMaps": [
- {
- "op": "=",
- "text": "N/A",
- "value": "null"
- }
- ],
- "valueName": "current"
+ "title": "Average Database Response",
+ "type": "stat"
},
{
- "aliasColors": {
- "rails.controller.mean": "#1f78c1"
+ "cacheTimeout": null,
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "displayName": "Response Time",
+ "mappings": [],
+ "nullValueMode": "connected",
+ "thresholds": {
+ "mode": "absolute",
+ "steps": [
+ {
+ "color": "#299c46",
+ "value": null
+ },
+ {
+ "color": "rgba(237, 129, 40, 0.89)",
+ "value": 1500
+ },
+ {
+ "color": "#d44a3a",
+ "value": 3000
+ }
+ ]
+ },
+ "unit": "ms"
+ },
+ "overrides": []
},
- "bars": false,
- "dashLength": 10,
- "dashes": false,
- "datasource": "${DS_INFLUXDB}",
- "description": "Time spent in controller actions",
- "fill": 1,
"gridPos": {
- "h": 9,
- "w": 8,
- "x": 0,
- "y": 3
+ "h": 3,
+ "w": 4,
+ "x": 20,
+ "y": 0
},
- "id": 6,
- "legend": {
- "alignAsTable": false,
- "avg": false,
- "current": false,
- "max": false,
- "min": false,
- "rightSide": false,
- "show": false,
- "total": false,
- "values": false
- },
- "lines": true,
- "linewidth": 1,
+ "id": 28,
+ "interval": null,
"links": [],
- "nullPointMode": "null",
- "options": {},
- "paceLength": 10,
- "percentage": false,
- "pointradius": 5,
- "points": false,
- "renderer": "flot",
- "seriesOverrides": [
- {
- "alias": "Maximum",
- "fillBelowTo": "Minimum",
- "lines": false
+ "maxDataPoints": 100,
+ "options": {
+ "colorMode": "value",
+ "graphMode": "none",
+ "justifyMode": "center",
+ "orientation": "horizontal",
+ "reduceOptions": {
+ "calcs": [
+ "mean"
+ ],
+ "fields": "",
+ "values": false
},
- {
- "alias": "Minimum",
- "lines": false
- }
- ],
- "spaceLength": 10,
- "stack": false,
- "steppedLine": false,
+ "textMode": "auto"
+ },
+ "pluginVersion": "7.1.1",
"targets": [
{
- "alias": "Maximum",
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
},
{
"params": [
- "0"
+ "null"
],
"type": "fill"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
- "refId": "C",
+ "refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "controller"
+ "value"
],
"type": "field"
},
{
"params": [],
- "type": "max"
+ "type": "mean"
}
]
],
"tags": [
{
"key": "hook",
"operator": "=",
- "value": "process_action"
+ "value": "perform"
}
]
+ }
+ ],
+ "title": "Average Job Execution",
+ "type": "stat"
+ },
+ {
+ "aliasColors": {
+ "Error": "dark-red",
+ "Success": "semi-dark-green"
+ },
+ "bars": true,
+ "dashLength": 10,
+ "dashes": false,
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "description": "Requests Served",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {}
},
+ "overrides": []
+ },
+ "fill": 1,
+ "fillGradient": 0,
+ "gridPos": {
+ "h": 7,
+ "w": 12,
+ "x": 0,
+ "y": 3
+ },
+ "hiddenSeries": false,
+ "id": 18,
+ "legend": {
+ "avg": false,
+ "current": false,
+ "max": false,
+ "min": false,
+ "show": true,
+ "total": false,
+ "values": false
+ },
+ "lines": false,
+ "linewidth": 1,
+ "links": [],
+ "nullPointMode": "null",
+ "percentage": false,
+ "pluginVersion": "7.1.1",
+ "pointradius": 2,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "spaceLength": 10,
+ "stack": false,
+ "steppedLine": false,
+ "targets": [
{
- "alias": "Mean",
+ "alias": "Success",
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
},
{
"params": [
- "0"
+ "previous"
],
"type": "fill"
}
],
"measurement": "rails",
@@ -634,34 +709,40 @@
],
"type": "field"
},
{
"params": [],
- "type": "mean"
+ "type": "count"
}
]
],
"tags": [
{
"key": "hook",
"operator": "=",
"value": "process_action"
+ },
+ {
+ "condition": "AND",
+ "key": "status",
+ "operator": "=",
+ "value": "200"
}
]
},
{
- "alias": "Minimum",
+ "alias": "Error",
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
},
{
"params": [
- "0"
+ "previous"
],
"type": "fill"
}
],
"measurement": "rails",
@@ -677,28 +758,34 @@
],
"type": "field"
},
{
"params": [],
- "type": "min"
+ "type": "count"
}
]
],
"tags": [
{
"key": "hook",
"operator": "=",
"value": "process_action"
+ },
+ {
+ "condition": "AND",
+ "key": "status",
+ "operator": "!=",
+ "value": "200"
}
]
}
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
- "title": "Controller Action Runtime",
+ "title": "Requests per $per",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
@@ -710,18 +797,20 @@
"show": true,
"values": []
},
"yaxes": [
{
- "format": "dtdurationms",
+ "$$hashKey": "object:477",
+ "format": "short",
"label": null,
- "logBase": 2,
+ "logBase": 1,
"max": null,
"min": null,
"show": true
},
{
+ "$$hashKey": "object:478",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
@@ -732,40 +821,52 @@
"align": false,
"alignLevel": null
}
},
{
- "aliasColors": {},
+ "aliasColors": {
+ "rails.controller.mean": "#1f78c1"
+ },
"bars": false,
"dashLength": 10,
"dashes": false,
- "datasource": "${DS_INFLUXDB}",
- "description": "Time spent in executing database queries",
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "description": "Time spent in controller actions",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {}
+ },
+ "overrides": []
+ },
"fill": 1,
+ "fillGradient": 0,
"gridPos": {
- "h": 9,
- "w": 8,
- "x": 8,
+ "h": 7,
+ "w": 12,
+ "x": 12,
"y": 3
},
- "id": 2,
+ "hiddenSeries": false,
+ "id": 6,
"legend": {
+ "alignAsTable": false,
"avg": false,
"current": false,
"max": false,
"min": false,
- "show": false,
+ "rightSide": false,
+ "show": true,
"total": false,
"values": false
},
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
- "options": {},
"paceLength": 10,
"percentage": false,
+ "pluginVersion": "7.1.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
@@ -781,41 +882,88 @@
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
- "alias": "Maximum",
+ "alias": "P99",
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
},
{
"params": [
- "0"
+ "null"
],
"type": "fill"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "controller"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [
+ "99"
+ ],
+ "type": "percentile"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "hook",
+ "operator": "=",
+ "value": "process_action"
+ }
+ ]
+ },
+ {
+ "alias": "P95",
+ "groupBy": [
+ {
+ "params": [
+ "$per"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "rails",
+ "orderByTime": "ASC",
+ "policy": "default",
"refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "db"
+ "controller"
],
"type": "field"
},
{
- "params": [],
- "type": "max"
+ "params": [
+ "95"
+ ],
+ "type": "percentile"
}
]
],
"tags": [
{
@@ -824,41 +972,41 @@
"value": "process_action"
}
]
},
{
- "alias": "Mean",
+ "alias": "P50",
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
},
{
"params": [
- "0"
+ "null"
],
"type": "fill"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
- "refId": "A",
+ "refId": "C",
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "db"
+ "controller"
],
"type": "field"
},
{
"params": [],
- "type": "mean"
+ "type": "median"
}
]
],
"tags": [
{
@@ -867,41 +1015,41 @@
"value": "process_action"
}
]
},
{
- "alias": "Minimum",
+ "alias": "Mean",
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
},
{
"params": [
- "0"
+ "null"
],
"type": "fill"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
- "refId": "C",
+ "refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "db"
+ "controller"
],
"type": "field"
},
{
"params": [],
- "type": "min"
+ "type": "mean"
}
]
],
"tags": [
{
@@ -914,11 +1062,11 @@
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
- "title": "Database Query Runtime",
+ "title": "Controller Action Performance",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
@@ -930,64 +1078,209 @@
"show": true,
"values": []
},
"yaxes": [
{
- "format": "dtdurationms",
+ "$$hashKey": "object:2305",
+ "format": "ms",
"label": null,
"logBase": 2,
"max": null,
"min": null,
"show": true
},
{
+ "$$hashKey": "object:2306",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
- "show": true
+ "show": false
}
],
"yaxis": {
"align": false,
"alignLevel": null
}
},
{
"aliasColors": {
- "rails.view.mean": "#eab839"
+ "Error": "dark-red",
+ "Success": "semi-dark-green"
},
- "bars": false,
+ "bars": true,
"dashLength": 10,
"dashes": false,
- "datasource": "${DS_INFLUXDB}",
- "description": "Time spent in rendering views",
- "fill": 0,
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "description": "Records Instantiated",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "displayName": "Records Instantiated"
+ },
+ "overrides": []
+ },
+ "fill": 1,
+ "fillGradient": 0,
"gridPos": {
- "h": 9,
- "w": 8,
- "x": 16,
- "y": 3
+ "h": 6,
+ "w": 12,
+ "x": 0,
+ "y": 10
},
- "id": 4,
+ "hiddenSeries": false,
+ "id": 24,
"legend": {
"avg": false,
"current": false,
"max": false,
"min": false,
"show": false,
"total": false,
"values": false
},
+ "lines": false,
+ "linewidth": 1,
+ "links": [],
+ "nullPointMode": "null",
+ "percentage": false,
+ "pluginVersion": "7.1.1",
+ "pointradius": 2,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "spaceLength": 10,
+ "stack": false,
+ "steppedLine": false,
+ "targets": [
+ {
+ "alias": "",
+ "groupBy": [
+ {
+ "params": [
+ "$per"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "previous"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "rails",
+ "orderByTime": "ASC",
+ "policy": "default",
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "record_count"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "sum"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "hook",
+ "operator": "=",
+ "value": "instantiation"
+ }
+ ]
+ }
+ ],
+ "thresholds": [],
+ "timeFrom": null,
+ "timeRegions": [],
+ "timeShift": null,
+ "title": "Instantiation per $per",
+ "tooltip": {
+ "shared": true,
+ "sort": 0,
+ "value_type": "individual"
+ },
+ "type": "graph",
+ "xaxis": {
+ "buckets": null,
+ "mode": "time",
+ "name": null,
+ "show": true,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "$$hashKey": "object:477",
+ "format": "short",
+ "label": null,
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ },
+ {
+ "$$hashKey": "object:478",
+ "format": "short",
+ "label": null,
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ }
+ ],
+ "yaxis": {
+ "align": false,
+ "alignLevel": null
+ }
+ },
+ {
+ "aliasColors": {},
+ "bars": false,
+ "dashLength": 10,
+ "dashes": false,
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "description": "Time spent in executing database queries",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {}
+ },
+ "overrides": []
+ },
+ "fill": 1,
+ "fillGradient": 0,
+ "gridPos": {
+ "h": 6,
+ "w": 12,
+ "x": 12,
+ "y": 10
+ },
+ "hiddenSeries": false,
+ "id": 2,
+ "legend": {
+ "avg": false,
+ "current": false,
+ "max": false,
+ "min": false,
+ "show": true,
+ "total": false,
+ "values": false
+ },
"lines": true,
"linewidth": 1,
"links": [],
"nullPointMode": "null",
- "options": {},
"paceLength": 10,
"percentage": false,
+ "pluginVersion": "7.1.1",
"pointradius": 5,
"points": false,
"renderer": "flot",
"seriesOverrides": [
{
@@ -1003,41 +1296,43 @@
"spaceLength": 10,
"stack": false,
"steppedLine": false,
"targets": [
{
- "alias": "Maximum",
+ "alias": "P99",
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
},
{
"params": [
- "0"
+ "null"
],
"type": "fill"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
- "refId": "C",
+ "refId": "A",
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "view"
+ "db"
],
"type": "field"
},
{
- "params": [],
- "type": "max"
+ "params": [
+ "99"
+ ],
+ "type": "percentile"
}
]
],
"tags": [
{
@@ -1046,41 +1341,86 @@
"value": "process_action"
}
]
},
{
- "alias": "Mean",
+ "alias": "P95",
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
},
{
"params": [
- "0"
+ "null"
],
"type": "fill"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
- "refId": "A",
+ "refId": "B",
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "view"
+ "db"
],
"type": "field"
},
{
+ "params": [
+ "95"
+ ],
+ "type": "percentile"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "hook",
+ "operator": "=",
+ "value": "process_action"
+ }
+ ]
+ },
+ {
+ "alias": "P50",
+ "groupBy": [
+ {
+ "params": [
+ "$per"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "rails",
+ "orderByTime": "ASC",
+ "policy": "default",
+ "refId": "C",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "db"
+ ],
+ "type": "field"
+ },
+ {
"params": [],
- "type": "mean"
+ "type": "median"
}
]
],
"tags": [
{
@@ -1089,41 +1429,41 @@
"value": "process_action"
}
]
},
{
- "alias": "Minimum",
+ "alias": "Mean",
"groupBy": [
{
"params": [
- "$__interval"
+ "$per"
],
"type": "time"
},
{
"params": [
- "0"
+ "null"
],
"type": "fill"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
- "refId": "B",
+ "refId": "D",
"resultFormat": "time_series",
"select": [
[
{
"params": [
- "view"
+ "db"
],
"type": "field"
},
{
"params": [],
- "type": "min"
+ "type": "mean"
}
]
],
"tags": [
{
@@ -1136,11 +1476,11 @@
],
"thresholds": [],
"timeFrom": null,
"timeRegions": [],
"timeShift": null,
- "title": "View Rendering Runtime",
+ "title": "Database Query Performance",
"tooltip": {
"shared": true,
"sort": 0,
"value_type": "individual"
},
@@ -1152,18 +1492,20 @@
"show": true,
"values": []
},
"yaxes": [
{
+ "$$hashKey": "object:2533",
"format": "dtdurationms",
"label": null,
"logBase": 2,
"max": null,
"min": null,
"show": true
},
{
+ "$$hashKey": "object:2534",
"format": "short",
"label": null,
"logBase": 1,
"max": null,
"min": null,
@@ -1174,577 +1516,420 @@
"align": false,
"alignLevel": null
}
},
{
- "columns": [],
- "datasource": "${DS_INFLUXDB}",
- "description": "Data for the selected range by controller action.\n\n- Count: Number of occurrences\n- Mean: Average time spent\n- Median: Median time spent\n- Maximum: Slowest occurrence\n\n[Average vs. Median?](https://www.differencebetween.com/difference-between-mean-and-median/)",
- "fontSize": "100%",
+ "aliasColors": {
+ "Failed": "red",
+ "Jobs": "green"
+ },
+ "bars": true,
+ "dashLength": 10,
+ "dashes": false,
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "description": "Jobs Performed",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "links": []
+ },
+ "overrides": []
+ },
+ "fill": 1,
+ "fillGradient": 0,
"gridPos": {
- "h": 13,
+ "h": 6,
"w": 12,
"x": 0,
- "y": 12
+ "y": 16
},
- "id": 18,
- "links": [],
- "options": {},
- "pageSize": null,
- "scroll": true,
- "showHeader": true,
- "sort": {
- "col": 5,
- "desc": true
+ "hiddenSeries": false,
+ "id": 20,
+ "legend": {
+ "alignAsTable": false,
+ "avg": false,
+ "current": false,
+ "max": false,
+ "min": false,
+ "show": true,
+ "total": false,
+ "values": false
},
- "styles": [
- {
- "alias": "Time",
- "dateFormat": "YYYY-MM-DD HH:mm:ss",
- "pattern": "Time",
- "type": "hidden"
- },
- {
- "alias": "Mean",
- "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": "mean",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
- },
- {
- "alias": "Count",
- "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": 0,
- "mappingType": 1,
- "pattern": "count",
- "thresholds": [],
- "type": "number",
- "unit": "short"
- },
- {
- "alias": "Median",
- "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": "median",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
- },
- {
- "alias": "Controller Action",
- "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,
- "link": true,
- "linkTargetBlank": true,
- "linkTooltip": "View data per this Controller Action",
- "linkUrl": "/d/$ACTION_DASHBOARD_UID/ruby-on-rails-performance-per-action?var-Action=${__cell}&from=$__from&to=$__to",
- "mappingType": 1,
- "pattern": "method",
- "thresholds": [],
- "type": "number",
- "unit": "short"
- },
- {
- "alias": "Maximum",
- "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": "max",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
- },
- {
- "alias": "",
- "colorMode": null,
- "colors": [
- "rgba(245, 54, 54, 0.9)",
- "rgba(237, 129, 40, 0.89)",
- "rgba(50, 172, 45, 0.97)"
- ],
- "decimals": 2,
- "pattern": "/.*/",
- "thresholds": [],
- "type": "number",
- "unit": "short"
- }
- ],
+ "lines": false,
+ "linewidth": 1,
+ "links": [],
+ "nullPointMode": "null as zero",
+ "paceLength": 10,
+ "percentage": false,
+ "pluginVersion": "7.1.1",
+ "pointradius": 2,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "spaceLength": 10,
+ "stack": false,
+ "steppedLine": false,
"targets": [
{
+ "alias": "Success",
"groupBy": [
{
"params": [
- "method"
+ "$per"
],
- "type": "tag"
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
}
],
- "limit": "",
+ "hide": false,
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
- "resultFormat": "table",
+ "resultFormat": "time_series",
"select": [
[
{
"params": [
- "controller"
+ "value"
],
"type": "field"
},
{
"params": [],
"type": "count"
}
- ],
+ ]
+ ],
+ "tags": [
+ {
+ "key": "hook",
+ "operator": "=",
+ "value": "perform"
+ },
+ {
+ "condition": "AND",
+ "key": "state",
+ "operator": "=",
+ "value": "succeeded"
+ }
+ ]
+ },
+ {
+ "alias": "Failed",
+ "groupBy": [
+ {
+ "params": [
+ "$per"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "rails",
+ "orderByTime": "ASC",
+ "policy": "default",
+ "refId": "B",
+ "resultFormat": "time_series",
+ "select": [
[
{
"params": [
- "controller"
+ "value"
],
"type": "field"
},
{
"params": [],
- "type": "mean"
+ "type": "count"
}
- ],
- [
- {
- "params": [
- "controller"
- ],
- "type": "field"
- },
- {
- "params": [],
- "type": "median"
- }
- ],
- [
- {
- "params": [
- "controller"
- ],
- "type": "field"
- },
- {
- "params": [],
- "type": "max"
- }
]
],
"tags": [
{
"key": "hook",
"operator": "=",
- "value": "process_action"
+ "value": "perform"
+ },
+ {
+ "condition": "AND",
+ "key": "state",
+ "operator": "=",
+ "value": "failed"
}
]
}
],
- "title": "By Controller Action",
- "transform": "table",
- "type": "table"
+ "thresholds": [],
+ "timeFrom": null,
+ "timeRegions": [],
+ "timeShift": null,
+ "title": "Jobs per $per",
+ "tooltip": {
+ "shared": true,
+ "sort": 0,
+ "value_type": "individual"
+ },
+ "type": "graph",
+ "xaxis": {
+ "buckets": null,
+ "mode": "time",
+ "name": null,
+ "show": true,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "$$hashKey": "object:737",
+ "format": "short",
+ "label": null,
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ },
+ {
+ "$$hashKey": "object:738",
+ "format": "short",
+ "label": null,
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": false
+ }
+ ],
+ "yaxis": {
+ "align": false,
+ "alignLevel": null
+ }
},
{
- "columns": [],
- "datasource": "${DS_INFLUXDB}",
- "description": "Data for the selected range by database query.\n\n- Count: Number of occurrences\n- Mean: Average time spent\n- Median: Median time spent\n- Maximum: Slowest occurrence\n\n[Average vs. Median?](https://www.differencebetween.com/difference-between-mean-and-median/)",
- "fontSize": "100%",
+ "aliasColors": {
+ "rails.view.mean": "#eab839"
+ },
+ "bars": false,
+ "dashLength": 10,
+ "dashes": false,
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "description": "Time spent in executing jobs",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {}
+ },
+ "overrides": []
+ },
+ "fill": 1,
+ "fillGradient": 0,
"gridPos": {
- "h": 13,
+ "h": 6,
"w": 12,
"x": 12,
- "y": 12
+ "y": 16
},
- "id": 29,
- "links": [],
- "options": {},
- "pageSize": null,
- "scroll": true,
- "showHeader": true,
- "sort": {
- "col": 6,
- "desc": true
+ "hiddenSeries": false,
+ "id": 23,
+ "legend": {
+ "avg": false,
+ "current": false,
+ "max": false,
+ "min": false,
+ "show": true,
+ "total": false,
+ "values": false
},
- "styles": [
+ "lines": true,
+ "linewidth": 1,
+ "links": [],
+ "nullPointMode": "null",
+ "paceLength": 10,
+ "percentage": false,
+ "pluginVersion": "7.1.1",
+ "pointradius": 5,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [
{
- "alias": "Time",
- "dateFormat": "YYYY-MM-DD HH:mm:ss",
- "pattern": "Time",
- "type": "hidden"
- },
- {
- "alias": "Count",
- "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": null,
- "mappingType": 1,
- "pattern": "count",
- "thresholds": [],
- "type": "number",
- "unit": "short"
- },
- {
- "alias": "Mean",
- "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": "mean",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
- },
- {
- "alias": "Median",
- "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": "median",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
- },
- {
- "alias": "Controller Action",
- "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,
- "link": true,
- "linkTargetBlank": true,
- "linkTooltip": "View data per this Controller Action",
- "linkUrl": "/d/$ACTION_DASHBOARD_UID/ruby-on-rails-performance-per-action?var-Action=${__cell}&from=$__from&to=$__to",
- "mappingType": 1,
- "pattern": "location",
- "thresholds": [],
- "type": "number",
- "unit": "short"
- },
- {
- "alias": "Name of the operation",
- "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",
- "thresholds": [],
- "type": "number",
- "unit": "short"
- },
- {
"alias": "Maximum",
- "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": "max",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
+ "fillBelowTo": "Minimum",
+ "lines": false
},
{
- "alias": "",
- "colorMode": null,
- "colors": [
- "rgba(245, 54, 54, 0.9)",
- "rgba(237, 129, 40, 0.89)",
- "rgba(50, 172, 45, 0.97)"
- ],
- "decimals": 2,
- "pattern": "/.*/",
- "thresholds": [],
- "type": "number",
- "unit": "short"
+ "alias": "Minimum",
+ "lines": false
}
],
+ "spaceLength": 10,
+ "stack": false,
+ "steppedLine": false,
"targets": [
{
+ "alias": "P99",
"groupBy": [
{
"params": [
- "name"
+ "$per"
],
- "type": "tag"
+ "type": "time"
},
{
"params": [
- "location"
+ "null"
],
- "type": "tag"
+ "type": "fill"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
- "resultFormat": "table",
+ "resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
- "params": [],
- "type": "count"
- }
- ],
- [
- {
"params": [
- "value"
+ "99"
],
- "type": "field"
- },
- {
- "params": [],
- "type": "mean"
+ "type": "percentile"
}
- ],
+ ]
+ ],
+ "tags": [
+ {
+ "key": "hook",
+ "operator": "=",
+ "value": "perform"
+ }
+ ]
+ },
+ {
+ "alias": "P95",
+ "groupBy": [
+ {
+ "params": [
+ "$per"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "rails",
+ "orderByTime": "ASC",
+ "policy": "default",
+ "refId": "B",
+ "resultFormat": "time_series",
+ "select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
- "params": [],
- "type": "median"
- }
- ],
- [
- {
"params": [
- "value"
+ "95"
],
- "type": "field"
- },
- {
- "params": [],
- "type": "max"
+ "type": "percentile"
}
]
],
"tags": [
{
"key": "hook",
"operator": "=",
- "value": "sql"
+ "value": "perform"
}
]
- }
- ],
- "title": "By Database Query",
- "transform": "table",
- "type": "table"
- },
- {
- "columns": [],
- "datasource": "${DS_INFLUXDB}",
- "description": "Data for the selected range by view rendering.\n\n- Count: Number of occurrences\n- Mean: Average time spent\n- Median: Median time spent\n- Maximum: Slowest occurrence\n\n[Average vs. Median?](https://www.differencebetween.com/difference-between-mean-and-median/)",
- "fontSize": "100%",
- "gridPos": {
- "h": 13,
- "w": 12,
- "x": 0,
- "y": 25
- },
- "id": 27,
- "links": [],
- "options": {},
- "pageSize": null,
- "scroll": true,
- "showHeader": true,
- "sort": {
- "col": 5,
- "desc": true
- },
- "styles": [
- {
- "alias": "Time",
- "dateFormat": "YYYY-MM-DD HH:mm:ss",
- "pattern": "Time",
- "type": "hidden"
},
{
- "alias": "Count",
- "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": 0,
- "mappingType": 1,
- "pattern": "count",
- "thresholds": [],
- "type": "number",
- "unit": "short"
- },
- {
- "alias": "Mean",
- "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": "mean",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
- },
- {
- "alias": "Median",
- "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": "median",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
- },
- {
- "alias": "Maximum",
- "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": "max",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
- },
- {
- "alias": "View",
- "colorMode": null,
- "colors": [
- "rgba(245, 54, 54, 0.9)",
- "rgba(237, 129, 40, 0.89)",
- "rgba(50, 172, 45, 0.97)"
- ],
- "decimals": 2,
- "pattern": "/.*/",
- "thresholds": [],
- "type": "number",
- "unit": "short"
- }
- ],
- "targets": [
- {
+ "alias": "P50",
"groupBy": [
{
"params": [
- "filename"
+ "$per"
],
- "type": "tag"
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
}
],
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
- "refId": "A",
- "resultFormat": "table",
+ "query": "SELECT percentile(\"view\", 50) FROM \"rails\" WHERE (\"hook\" = 'process_action') AND $timeFilter GROUP BY time(1m) fill(null)",
+ "rawQuery": false,
+ "refId": "C",
+ "resultFormat": "time_series",
"select": [
[
{
"params": [
"value"
],
"type": "field"
},
{
"params": [],
- "type": "count"
+ "type": "median"
}
- ],
+ ]
+ ],
+ "tags": [
+ {
+ "key": "hook",
+ "operator": "=",
+ "value": "perform"
+ }
+ ]
+ },
+ {
+ "alias": "Mean",
+ "groupBy": [
+ {
+ "params": [
+ "$per"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "rails",
+ "orderByTime": "ASC",
+ "policy": "default",
+ "refId": "D",
+ "resultFormat": "time_series",
+ "select": [
[
{
"params": [
"value"
],
@@ -1752,268 +1937,291 @@
},
{
"params": [],
"type": "mean"
}
- ],
- [
- {
- "params": [
- "value"
- ],
- "type": "field"
- },
- {
- "params": [],
- "type": "median"
- }
- ],
- [
- {
- "params": [
- "value"
- ],
- "type": "field"
- },
- {
- "params": [],
- "type": "max"
- }
]
],
"tags": [
{
"key": "hook",
"operator": "=",
- "value": "render_template"
+ "value": "perform"
}
]
}
],
- "title": "By View Rendering",
- "transform": "table",
- "type": "table"
- },
- {
- "columns": [],
- "datasource": "${DS_INFLUXDB}",
- "description": "Data for the selected range by request ID.\n\n- Maximum: Slowest occurrence",
- "fontSize": "100%",
- "gridPos": {
- "h": 13,
- "w": 12,
- "x": 12,
- "y": 25
+ "thresholds": [],
+ "timeFrom": null,
+ "timeRegions": [],
+ "timeShift": null,
+ "title": "ActiveJob Performance",
+ "tooltip": {
+ "shared": true,
+ "sort": 0,
+ "value_type": "individual"
},
- "id": 33,
- "links": [],
- "options": {},
- "pageSize": null,
- "scroll": true,
- "showHeader": true,
- "sort": {
- "col": 4,
- "desc": true
+ "type": "graph",
+ "xaxis": {
+ "buckets": null,
+ "mode": "time",
+ "name": null,
+ "show": true,
+ "values": []
},
- "styles": [
+ "yaxes": [
{
- "alias": "Finished",
- "dateFormat": "YYYY-MM-DD HH:mm:ss",
- "pattern": "Time",
- "type": "hidden"
+ "$$hashKey": "object:3057",
+ "format": "ms",
+ "label": null,
+ "logBase": 2,
+ "max": null,
+ "min": null,
+ "show": true
},
{
- "alias": "Started",
- "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,
- "pattern": "started",
- "thresholds": [],
- "type": "hidden",
- "unit": "short"
- },
- {
- "alias": "Maximum",
- "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": "max",
- "thresholds": [],
- "type": "number",
- "unit": "ms"
- },
- {
- "alias": "Request ID",
- "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,
- "link": true,
- "linkTargetBlank": false,
- "linkTooltip": "View data per this Request",
- "linkUrl": "/d/$REQUEST_DASHBOARD_UID/ruby-on-rails-performance-per-request?var-request_id=${__cell}&from=${__cell_2}&to=${__cell_0}&var-method=${__cell_1}",
- "mappingType": 1,
- "pattern": "request_id",
- "thresholds": [],
- "type": "string",
- "unit": "short"
- },
- {
- "alias": "Controller Action",
- "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,
- "link": true,
- "linkTargetBlank": true,
- "linkTooltip": "View data per this Controller Action",
- "linkUrl": "/d/$ACTION_DASHBOARD_UID/ruby-on-rails-performance-per-action?var-Action=${__cell}&from=$__from&to=$__to",
- "mappingType": 1,
- "pattern": "method",
- "thresholds": [],
- "type": "number",
- "unit": "short"
+ "$$hashKey": "object:3058",
+ "format": "short",
+ "label": null,
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": false
}
],
+ "yaxis": {
+ "align": false,
+ "alignLevel": null
+ }
+ },
+ {
+ "aliasColors": {},
+ "bars": true,
+ "dashLength": 10,
+ "dashes": false,
+ "datasource": "${DS_INFLUXDB-RAILS}",
+ "description": "Emails Sent",
+ "fieldConfig": {
+ "defaults": {
+ "custom": {},
+ "displayName": "Emails"
+ },
+ "overrides": []
+ },
+ "fill": 1,
+ "fillGradient": 0,
+ "gridPos": {
+ "h": 6,
+ "w": 12,
+ "x": 0,
+ "y": 22
+ },
+ "hiddenSeries": false,
+ "id": 22,
+ "legend": {
+ "avg": false,
+ "current": false,
+ "max": false,
+ "min": false,
+ "show": false,
+ "total": false,
+ "values": false
+ },
+ "lines": false,
+ "linewidth": 2,
+ "nullPointMode": "connected",
+ "percentage": false,
+ "pluginVersion": "7.1.1",
+ "pointradius": 2,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "spaceLength": 10,
+ "stack": false,
+ "steppedLine": false,
"targets": [
{
+ "alias": "",
"groupBy": [
{
"params": [
- "method"
+ "$per"
],
- "type": "tag"
+ "type": "time"
}
],
- "limit": "20",
"measurement": "rails",
"orderByTime": "ASC",
"policy": "default",
"refId": "A",
- "resultFormat": "table",
+ "resultFormat": "time_series",
"select": [
[
{
"params": [
- "started"
+ "value"
],
"type": "field"
- }
- ],
- [
- {
- "params": [
- "request_id"
- ],
- "type": "field"
- }
- ],
- [
- {
- "params": [
- "controller"
- ],
- "type": "field"
},
{
"params": [],
- "type": "max"
+ "type": "count"
}
]
],
"tags": [
{
"key": "hook",
"operator": "=",
- "value": "process_action"
+ "value": "deliver"
}
]
}
],
- "title": "By Request ID",
- "transform": "table",
- "type": "table"
+ "thresholds": [],
+ "timeFrom": null,
+ "timeRegions": [],
+ "timeShift": null,
+ "title": "Mails per $per",
+ "tooltip": {
+ "shared": true,
+ "sort": 0,
+ "value_type": "individual"
+ },
+ "type": "graph",
+ "xaxis": {
+ "buckets": null,
+ "mode": "time",
+ "name": null,
+ "show": true,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "$$hashKey": "object:282",
+ "format": "short",
+ "label": null,
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ },
+ {
+ "$$hashKey": "object:283",
+ "decimals": 0,
+ "format": "Misc",
+ "label": null,
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": false
+ }
+ ],
+ "yaxis": {
+ "align": false,
+ "alignLevel": null
+ }
}
],
"refresh": "5m",
- "schemaVersion": 18,
+ "schemaVersion": 26,
"style": "dark",
"tags": [
- "performance",
- "ruby on rails",
- "influxdb"
+ "Performance",
+ "Ruby on Rails",
+ "influxdb-rails"
],
"templating": {
"list": [
{
- "allValue": null,
+ "auto": true,
+ "auto_count": "50",
+ "auto_min": "",
"current": {
- "text": "H8S9fSVWz",
- "value": "H8S9fSVWz"
+ "selected": false,
+ "text": "auto",
+ "value": "$__auto_interval_per"
},
- "hide": 2,
- "includeAll": false,
+ "hide": 0,
"label": null,
- "multi": false,
- "name": "REQUEST_DASHBOARD_UID",
+ "name": "per",
"options": [
{
"selected": true,
- "text": "H8S9fSVWz",
- "value": "H8S9fSVWz"
- }
- ],
- "query": "H8S9fSVWz",
- "skipUrlSync": false,
- "type": "custom"
- },
- {
- "current": {
- "value": "Gpp3B1Pik",
- "text": "Gpp3B1Pik"
- },
- "hide": 2,
- "label": null,
- "name": "ACTION_DASHBOARD_UID",
- "options": [
+ "text": "auto",
+ "value": "$__auto_interval_per"
+ },
{
- "value": "Gpp3B1Pik",
- "text": "Gpp3B1Pik"
+ "selected": false,
+ "text": "1m",
+ "value": "1m"
+ },
+ {
+ "selected": false,
+ "text": "5m",
+ "value": "5m"
+ },
+ {
+ "selected": false,
+ "text": "10m",
+ "value": "10m"
+ },
+ {
+ "selected": false,
+ "text": "30m",
+ "value": "30m"
+ },
+ {
+ "selected": false,
+ "text": "1h",
+ "value": "1h"
+ },
+ {
+ "selected": false,
+ "text": "6h",
+ "value": "6h"
+ },
+ {
+ "selected": false,
+ "text": "12h",
+ "value": "12h"
+ },
+ {
+ "selected": false,
+ "text": "1d",
+ "value": "1d"
+ },
+ {
+ "selected": false,
+ "text": "7d",
+ "value": "7d"
+ },
+ {
+ "selected": false,
+ "text": "14d",
+ "value": "14d"
+ },
+ {
+ "selected": false,
+ "text": "30d",
+ "value": "30d"
}
],
- "query": "Gpp3B1Pik",
+ "query": "1m,5m,10m,30m,1h,6h,12h,1d,7d,14d,30d",
+ "queryValue": "",
+ "refresh": 2,
"skipUrlSync": false,
- "type": "constant"
+ "type": "interval"
}
]
},
"time": {
"from": "now-1h",
"to": "now"
},
"timepicker": {
"refresh_intervals": [
- "5s",
"10s",
"30s",
"1m",
"5m",
"15m",
@@ -2033,9 +2241,9 @@
"7d",
"30d"
]
},
"timezone": "",
- "title": "Ruby On Rails Performance Overview",
- "uid": "K2CJtIVZz",
- "version": 1
-}
+ "title": "Performance",
+ "uid": "influxdb-rails-overview",
+ "version": 24
+}
\ No newline at end of file