You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@jmeter.apache.org by mc...@apache.org on 2017/06/08 12:53:52 UTC
svn commit: r1798053 - /jmeter/trunk/extras/GrafanaJMeterTemplate.json
Author: mchassagneux
Date: Thu Jun 8 12:53:52 2017
New Revision: 1798053
URL: http://svn.apache.org/viewvc?rev=1798053&view=rev
Log:
Add a Grafana Template
Bugzilla Id: 61167
Added:
jmeter/trunk/extras/GrafanaJMeterTemplate.json (with props)
Added: jmeter/trunk/extras/GrafanaJMeterTemplate.json
URL: http://svn.apache.org/viewvc/jmeter/trunk/extras/GrafanaJMeterTemplate.json?rev=1798053&view=auto
==============================================================================
--- jmeter/trunk/extras/GrafanaJMeterTemplate.json (added)
+++ jmeter/trunk/extras/GrafanaJMeterTemplate.json Thu Jun 8 12:53:52 2017
@@ -0,0 +1,1459 @@
+{
+ "id": 97,
+ "title": "JMeter Metric Template",
+ "tags": [],
+ "style": "dark",
+ "timezone": "browser",
+ "editable": true,
+ "sharedCrosshair": true,
+ "hideControls": false,
+ "time": {
+ "from": "2017-06-08T01:09:30.935Z",
+ "to": "2017-06-08T02:55:58.972Z"
+ },
+ "timepicker": {
+ "now": true,
+ "refresh_intervals": [
+ "10s",
+ "30s",
+ "1m",
+ "5m",
+ "15m",
+ "30m",
+ "1h",
+ "2h",
+ "1d"
+ ],
+ "time_options": [
+ "5m",
+ "15m",
+ "1h",
+ "6h",
+ "12h",
+ "24h",
+ "2d",
+ "7d",
+ "30d"
+ ]
+ },
+ "templating": {
+ "list": [
+ {
+ "allValue": ".*",
+ "datasource": "jmeterdb",
+ "hide": 0,
+ "includeAll": false,
+ "label": null,
+ "multi": true,
+ "name": "app",
+ "options": [],
+ "query": "SHOW TAG VALUES FROM \"process\" WITH KEY = \"application\"",
+ "refresh": 2,
+ "regex": "",
+ "sort": 1,
+ "tagValuesQuery": "",
+ "tagsQuery": "SHOW TAG VALUES FROM \"events\" WITH KEY = \"tags\"",
+ "type": "query"
+ },
+ {
+ "allFormat": "regex wildcard",
+ "auto": false,
+ "auto_count": 10,
+ "auto_min": "10s",
+ "current": {
+ "text": "1m",
+ "value": "1m"
+ },
+ "datasource": "jmeterdb",
+ "hide": 0,
+ "includeAll": true,
+ "label": "",
+ "multi": false,
+ "multiFormat": "glob",
+ "name": "granularity",
+ "options": [
+ {
+ "text": "1m",
+ "value": "1m",
+ "selected": true
+ },
+ {
+ "text": "5m",
+ "value": "5m",
+ "selected": false
+ },
+ {
+ "text": "1h",
+ "value": "1h",
+ "selected": false
+ },
+ {
+ "text": "5s",
+ "value": "5s",
+ "selected": false
+ },
+ {
+ "text": "15s",
+ "value": "15s",
+ "selected": false
+ },
+ {
+ "text": "30s",
+ "value": "30s",
+ "selected": false
+ }
+ ],
+ "query": "1m,5m,1h,5s,15s,30s",
+ "refresh": 2,
+ "regex": "",
+ "type": "interval"
+ },
+ {
+ "allValue": null,
+ "current": {
+ "text": "default",
+ "value": "default",
+ "tags": []
+ },
+ "datasource": "jmeterdb",
+ "hide": 0,
+ "includeAll": false,
+ "label": null,
+ "multi": false,
+ "name": "retention",
+ "options": [],
+ "query": "SHOW RETENTION POLICIES ON \"jmeterdb\"",
+ "refresh": 1,
+ "regex": "",
+ "sort": 0,
+ "tagValuesQuery": null,
+ "tagsQuery": null,
+ "type": "query"
+ },
+ {
+ "allValue": ".*",
+ "current": {
+ "value": [
+ "$__all"
+ ],
+ "text": "All"
+ },
+ "datasource": "jmeterdb",
+ "hide": 0,
+ "includeAll": true,
+ "label": null,
+ "multi": true,
+ "name": "transaction",
+ "options": [],
+ "query": "SHOW TAG VALUES FROM \"jmeter\" WITH KEY IN (\"transaction\",\"application\") where application =~ /$app/ and transaction !~ /all/",
+ "refresh": 2,
+ "regex": "",
+ "sort": 0,
+ "tagValuesQuery": null,
+ "tagsQuery": null,
+ "type": "query"
+ }
+ ]
+ },
+ "annotations": {
+ "list": [
+ {
+ "datasource": "jmeterdb",
+ "enable": true,
+ "iconColor": "rgb(237, 18, 18)",
+ "iconSize": 17,
+ "lineColor": "rgb(0, 21, 255)",
+ "name": "Annotation",
+ "query": "select text,tags,title from \"$retention\".\"events\" where application =~ /$app/ AND $timeFilter",
+ "showLine": true,
+ "textColumn": "text",
+ "titleColumn": "title",
+ "tagsColumn": "tags"
+ }
+ ]
+ },
+ "refresh": false,
+ "schemaVersion": 13,
+ "version": 0,
+ "links": [
+ {
+ "asDropdown": true,
+ "icon": "dashboard",
+ "includeVars": true,
+ "keepTime": true,
+ "tags": [],
+ "targetBlank": true,
+ "tooltip": "",
+ "type": "dashboards",
+ "url": ""
+ }
+ ],
+ "gnetId": null,
+ "rows": [
+ {
+ "title": "Jmeter Metrics",
+ "panels": [
+ {
+ "cacheTimeout": null,
+ "colorBackground": false,
+ "colorValue": false,
+ "colors": [
+ "rgba(245, 54, 54, 0.9)",
+ "rgba(237, 129, 40, 0.89)",
+ "rgba(50, 172, 45, 0.97)"
+ ],
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "format": "none",
+ "gauge": {
+ "maxValue": 100,
+ "minValue": 0,
+ "show": false,
+ "thresholdLabels": false,
+ "thresholdMarkers": true
+ },
+ "id": 19,
+ "interval": "$granularity",
+ "links": [],
+ "mappingType": 1,
+ "mappingTypes": [
+ {
+ "name": "value to text",
+ "value": 1
+ },
+ {
+ "name": "range to text",
+ "value": 2
+ }
+ ],
+ "maxDataPoints": 100,
+ "nullPointMode": "connected",
+ "nullText": null,
+ "postfix": " users",
+ "postfixFontSize": "50%",
+ "prefix": "",
+ "prefixFontSize": "50%",
+ "rangeMaps": [
+ {
+ "from": "null",
+ "text": "N/A",
+ "to": "null"
+ }
+ ],
+ "span": 4,
+ "sparkline": {
+ "fillColor": "rgba(31, 118, 189, 0.18)",
+ "full": true,
+ "lineColor": "rgb(31, 120, 193)",
+ "show": true
+ },
+ "targets": [
+ {
+ "dsType": "influxdb",
+ "groupBy": [
+ {
+ "params": [
+ "$granularity"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "jmeter",
+ "policy": "$retention",
+ "query": "SELECT last(\"startedT\") FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity) fill(null)",
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "meanAT"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "last"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ }
+ ]
+ }
+ ],
+ "thresholds": "",
+ "title": "Active Users",
+ "type": "singlestat",
+ "valueFontSize": "80%",
+ "valueMaps": [
+ {
+ "op": "=",
+ "text": "0",
+ "value": "null"
+ }
+ ],
+ "valueName": "current"
+ },
+ {
+ "cacheTimeout": null,
+ "colorBackground": false,
+ "colorValue": false,
+ "colors": [
+ "rgba(245, 54, 54, 0.9)",
+ "rgba(237, 129, 40, 0.89)",
+ "rgba(50, 172, 45, 0.97)"
+ ],
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "format": "none",
+ "gauge": {
+ "maxValue": 100,
+ "minValue": 0,
+ "show": false,
+ "thresholdLabels": false,
+ "thresholdMarkers": true
+ },
+ "id": 17,
+ "interval": "",
+ "links": [],
+ "mappingType": 1,
+ "mappingTypes": [
+ {
+ "name": "value to text",
+ "value": 1
+ },
+ {
+ "name": "range to text",
+ "value": 2
+ }
+ ],
+ "maxDataPoints": 100,
+ "nullPointMode": "connected",
+ "nullText": null,
+ "postfix": " TPS",
+ "postfixFontSize": "50%",
+ "prefix": "",
+ "prefixFontSize": "50%",
+ "rangeMaps": [
+ {
+ "from": "null",
+ "text": "N/A",
+ "to": "null"
+ }
+ ],
+ "span": 4,
+ "sparkline": {
+ "fillColor": "rgba(31, 118, 189, 0.18)",
+ "full": true,
+ "lineColor": "rgb(31, 120, 193)",
+ "show": true
+ },
+ "targets": [
+ {
+ "dsType": "influxdb",
+ "groupBy": [
+ {
+ "params": [
+ "$granularity"
+ ],
+ "type": "time"
+ }
+ ],
+ "measurement": "jmeter",
+ "policy": "default",
+ "query": "SELECT sum(\"hit\") / 30 FROM \"$retention\".\"jmeter\" WHERE \"application\" = '$app' AND \"transaction\" = 'all' AND $timeFilter GROUP BY time(30s)",
+ "rawQuery": true,
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "hit"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "last"
+ },
+ {
+ "params": [
+ " / 5"
+ ],
+ "type": "math"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ },
+ {
+ "condition": "AND",
+ "key": "transaction",
+ "operator": "=",
+ "value": "all"
+ }
+ ]
+ }
+ ],
+ "thresholds": "",
+ "title": "Currents hits per Second",
+ "type": "singlestat",
+ "valueFontSize": "80%",
+ "valueMaps": [
+ {
+ "op": "=",
+ "text": "0",
+ "value": "null"
+ }
+ ],
+ "valueName": "current"
+ },
+ {
+ "cacheTimeout": null,
+ "colorBackground": false,
+ "colorValue": true,
+ "colors": [
+ "rgba(50, 172, 45, 0.97)",
+ "rgba(237, 129, 40, 0.89)",
+ "rgba(245, 54, 54, 0.9)"
+ ],
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "format": "percentunit",
+ "gauge": {
+ "maxValue": 100,
+ "minValue": 0,
+ "show": false,
+ "thresholdLabels": false,
+ "thresholdMarkers": true
+ },
+ "id": 21,
+ "interval": "$granularity",
+ "links": [],
+ "mappingType": 1,
+ "mappingTypes": [
+ {
+ "name": "value to text",
+ "value": 1
+ },
+ {
+ "name": "range to text",
+ "value": 2
+ }
+ ],
+ "maxDataPoints": 100,
+ "nullPointMode": "connected",
+ "nullText": null,
+ "postfix": "",
+ "postfixFontSize": "50%",
+ "prefix": "",
+ "prefixFontSize": "50%",
+ "rangeMaps": [
+ {
+ "from": "null",
+ "text": "N/A",
+ "to": "null"
+ }
+ ],
+ "span": 4,
+ "sparkline": {
+ "fillColor": "rgba(31, 118, 189, 0.18)",
+ "full": true,
+ "lineColor": "rgb(31, 120, 193)",
+ "show": true
+ },
+ "targets": [
+ {
+ "dsType": "influxdb",
+ "groupBy": [],
+ "measurement": "jmeter",
+ "policy": "$retention",
+ "query": "SELECT sum(\"countError\") / sum(\"count\") FROM \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND \"transaction\" = 'all' AND $timeFilter",
+ "rawQuery": true,
+ "refId": "B",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "countError"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "sum"
+ },
+ {
+ "params": [
+ " / sum(\"count\")"
+ ],
+ "type": "math"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ },
+ {
+ "condition": "AND",
+ "key": "transaction",
+ "operator": "=",
+ "value": "all"
+ }
+ ]
+ }
+ ],
+ "thresholds": "0.1,0.2",
+ "title": "% Errors",
+ "type": "singlestat",
+ "valueFontSize": "80%",
+ "valueMaps": [
+ {
+ "op": "=",
+ "text": "0",
+ "value": "null"
+ }
+ ],
+ "valueName": "total"
+ },
+ {
+ "aliasColors": {},
+ "bars": false,
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "fill": 1,
+ "grid": {},
+ "id": 27,
+ "interval": "$granularity",
+ "legend": {
+ "avg": false,
+ "current": false,
+ "max": false,
+ "min": false,
+ "show": false,
+ "total": false,
+ "values": false
+ },
+ "lines": true,
+ "linewidth": 1,
+ "links": [],
+ "nullPointMode": "null as zero",
+ "percentage": false,
+ "pointradius": 5,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "span": 4,
+ "stack": false,
+ "steppedLine": true,
+ "targets": [
+ {
+ "alias": "Hits",
+ "dsType": "influxdb",
+ "groupBy": [
+ {
+ "params": [
+ "$granularity"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "jmeter",
+ "policy": "$retention",
+ "query": "SELECT last(\"hit\") / 5 FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity) fill(null)",
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "hit"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "last"
+ },
+ {
+ "params": [
+ " / 5"
+ ],
+ "type": "math"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ }
+ ]
+ }
+ ],
+ "thresholds": [],
+ "timeFrom": null,
+ "timeShift": null,
+ "title": "Hits per Second",
+ "tooltip": {
+ "msResolution": false,
+ "shared": true,
+ "sort": 0,
+ "value_type": "cumulative"
+ },
+ "type": "graph",
+ "xaxis": {
+ "mode": "time",
+ "name": null,
+ "show": false,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "format": "short",
+ "logBase": 1,
+ "max": null,
+ "min": 0,
+ "show": true
+ },
+ {
+ "format": "short",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ }
+ ]
+ },
+ {
+ "cacheTimeout": null,
+ "colorBackground": false,
+ "colorValue": false,
+ "colors": [
+ "rgba(245, 54, 54, 0.9)",
+ "rgba(237, 129, 40, 0.89)",
+ "rgba(50, 172, 45, 0.97)"
+ ],
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "format": "none",
+ "gauge": {
+ "maxValue": 100,
+ "minValue": 0,
+ "show": false,
+ "thresholdLabels": false,
+ "thresholdMarkers": true
+ },
+ "id": 22,
+ "interval": "$granularity",
+ "links": [],
+ "mappingType": 1,
+ "mappingTypes": [
+ {
+ "name": "value to text",
+ "value": 1
+ },
+ {
+ "name": "range to text",
+ "value": 2
+ }
+ ],
+ "maxDataPoints": 100,
+ "nullPointMode": "connected",
+ "nullText": null,
+ "postfix": "",
+ "postfixFontSize": "50%",
+ "prefix": "",
+ "prefixFontSize": "50%",
+ "rangeMaps": [
+ {
+ "from": "null",
+ "text": "N/A",
+ "to": "null"
+ }
+ ],
+ "span": 4,
+ "sparkline": {
+ "fillColor": "rgba(31, 118, 189, 0.18)",
+ "full": true,
+ "lineColor": "rgb(31, 120, 193)",
+ "show": true
+ },
+ "targets": [
+ {
+ "dsType": "influxdb",
+ "groupBy": [],
+ "measurement": "jmeter",
+ "policy": "$retention",
+ "query": "SELECT \"hit\" FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND \"statut\" = 'all' AND $timeFilter",
+ "rawQuery": false,
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "hit"
+ ],
+ "type": "field"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ },
+ {
+ "condition": "AND",
+ "key": "statut",
+ "operator": "=",
+ "value": "all"
+ }
+ ]
+ }
+ ],
+ "thresholds": "",
+ "title": "Total Hits",
+ "type": "singlestat",
+ "valueFontSize": "80%",
+ "valueMaps": [
+ {
+ "op": "=",
+ "text": "0",
+ "value": "null"
+ }
+ ],
+ "valueName": "total"
+ },
+ {
+ "aliasColors": {},
+ "bars": false,
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "fill": 1,
+ "grid": {},
+ "id": 28,
+ "interval": "$granularity",
+ "legend": {
+ "avg": false,
+ "current": false,
+ "max": false,
+ "min": false,
+ "show": false,
+ "total": false,
+ "values": false
+ },
+ "lines": true,
+ "linewidth": 1,
+ "links": [],
+ "nullPointMode": "null",
+ "percentage": false,
+ "pointradius": 5,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "span": 4,
+ "stack": false,
+ "steppedLine": true,
+ "targets": [
+ {
+ "alias": "Errors",
+ "dsType": "influxdb",
+ "groupBy": [
+ {
+ "params": [
+ "$granularity"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "0"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "jmeter",
+ "policy": "$retention",
+ "query": "SELECT mean(\"countError\") / 5 FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity) fill(0)",
+ "rawQuery": false,
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "countError"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "mean"
+ },
+ {
+ "params": [
+ " / 5"
+ ],
+ "type": "math"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ }
+ ]
+ }
+ ],
+ "thresholds": [],
+ "timeFrom": null,
+ "timeShift": null,
+ "title": "Errors per Second",
+ "tooltip": {
+ "msResolution": false,
+ "shared": true,
+ "sort": 0,
+ "value_type": "cumulative"
+ },
+ "type": "graph",
+ "xaxis": {
+ "mode": "time",
+ "name": null,
+ "show": false,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "format": "short",
+ "logBase": 1,
+ "max": null,
+ "min": 0,
+ "show": true
+ },
+ {
+ "format": "short",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ }
+ ]
+ }
+ ],
+ "showTitle": true,
+ "titleSize": "h6",
+ "height": "150px",
+ "repeat": null,
+ "repeatRowId": null,
+ "repeatIteration": null,
+ "collapse": false
+ },
+ {
+ "title": "Application Metrics",
+ "panels": [
+ {
+ "aliasColors": {},
+ "bars": false,
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "fill": 1,
+ "grid": {},
+ "height": "",
+ "id": 25,
+ "interval": "$granularity",
+ "legend": {
+ "alignAsTable": true,
+ "avg": true,
+ "current": true,
+ "hideEmpty": false,
+ "max": true,
+ "min": true,
+ "rightSide": false,
+ "show": true,
+ "total": false,
+ "values": true
+ },
+ "lines": true,
+ "linewidth": 1,
+ "links": [],
+ "minSpan": 12,
+ "nullPointMode": "null",
+ "percentage": false,
+ "pointradius": 5,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "span": 12,
+ "stack": false,
+ "steppedLine": true,
+ "targets": [
+ {
+ "alias": "$tag_transaction",
+ "dsType": "influxdb",
+ "groupBy": [
+ {
+ "params": [
+ "$granularity"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "transaction"
+ ],
+ "type": "tag"
+ }
+ ],
+ "hide": false,
+ "measurement": "jmeter",
+ "policy": "$retention",
+ "query": "SELECT mean(\"avg\") FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity), \"transaction\"",
+ "rawQuery": false,
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "avg"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "mean"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ },
+ {
+ "condition": "AND",
+ "key": "statut",
+ "operator": "=",
+ "value": "all"
+ }
+ ]
+ }
+ ],
+ "thresholds": [],
+ "timeFrom": null,
+ "timeShift": null,
+ "title": "Average Response Time",
+ "tooltip": {
+ "msResolution": false,
+ "shared": false,
+ "sort": 0,
+ "value_type": "cumulative"
+ },
+ "transparent": false,
+ "type": "graph",
+ "xaxis": {
+ "mode": "time",
+ "name": null,
+ "show": true,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "format": "ms",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ },
+ {
+ "format": "short",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ }
+ ]
+ },
+ {
+ "aliasColors": {},
+ "bars": false,
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "fill": 1,
+ "grid": {},
+ "height": "",
+ "id": 26,
+ "interval": "$granularity",
+ "legend": {
+ "alignAsTable": true,
+ "avg": true,
+ "current": true,
+ "hideEmpty": false,
+ "max": true,
+ "min": true,
+ "rightSide": false,
+ "show": true,
+ "sort": "current",
+ "sortDesc": true,
+ "total": false,
+ "values": true
+ },
+ "lines": true,
+ "linewidth": 1,
+ "links": [],
+ "minSpan": 12,
+ "nullPointMode": "null",
+ "percentage": false,
+ "pointradius": 5,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "span": 12,
+ "stack": false,
+ "steppedLine": true,
+ "targets": [
+ {
+ "alias": "$tag_transaction",
+ "dsType": "influxdb",
+ "groupBy": [
+ {
+ "params": [
+ "30s"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "transaction"
+ ],
+ "type": "tag"
+ }
+ ],
+ "measurement": "jmeter",
+ "policy": "$retention",
+ "query": "SELECT mean(\"count\") / 5 FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND \"transaction\" <> 'all' AND $timeFilter GROUP BY time($granularity), \"transaction\"",
+ "rawQuery": false,
+ "refId": "A",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "count"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "sum"
+ },
+ {
+ "params": [
+ " / 30"
+ ],
+ "type": "math"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ },
+ {
+ "condition": "AND",
+ "key": "transaction",
+ "operator": "<>",
+ "value": "all"
+ },
+ {
+ "condition": "AND",
+ "key": "statut",
+ "operator": "=",
+ "value": "all"
+ }
+ ]
+ }
+ ],
+ "thresholds": [],
+ "timeFrom": null,
+ "timeShift": null,
+ "title": "Transaction Per Second",
+ "tooltip": {
+ "msResolution": false,
+ "shared": false,
+ "sort": 0,
+ "value_type": "cumulative"
+ },
+ "transparent": false,
+ "type": "graph",
+ "xaxis": {
+ "mode": "time",
+ "name": null,
+ "show": true,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "format": "ops",
+ "label": "",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ },
+ {
+ "format": "short",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ }
+ ]
+ },
+ {
+ "aliasColors": {},
+ "bars": false,
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "fill": 1,
+ "grid": {},
+ "height": "",
+ "id": 29,
+ "interval": "$granularity",
+ "legend": {
+ "alignAsTable": true,
+ "avg": true,
+ "current": true,
+ "hideEmpty": false,
+ "max": true,
+ "min": true,
+ "rightSide": false,
+ "show": true,
+ "total": false,
+ "values": true
+ },
+ "lines": true,
+ "linewidth": 1,
+ "links": [],
+ "minSpan": 12,
+ "nullPointMode": "null",
+ "percentage": false,
+ "pointradius": 5,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "span": 12,
+ "stack": false,
+ "steppedLine": true,
+ "targets": [
+ {
+ "alias": "$tag_transaction",
+ "dsType": "influxdb",
+ "groupBy": [
+ {
+ "params": [
+ "30s"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "transaction"
+ ],
+ "type": "tag"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "jmeter",
+ "policy": "$retention",
+ "query": "SELECT last(\"count\") / 30 FROM \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND \"statut\" = 'ko' AND $timeFilter GROUP BY time(30s), \"transaction\" fill(null)",
+ "rawQuery": false,
+ "refId": "B",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "count"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "sum"
+ },
+ {
+ "params": [
+ " / 30"
+ ],
+ "type": "math"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ },
+ {
+ "condition": "AND",
+ "key": "statut",
+ "operator": "=",
+ "value": "ko"
+ }
+ ]
+ }
+ ],
+ "thresholds": [],
+ "timeFrom": null,
+ "timeShift": null,
+ "title": "Error Per Second",
+ "tooltip": {
+ "msResolution": false,
+ "shared": false,
+ "sort": 0,
+ "value_type": "cumulative"
+ },
+ "transparent": false,
+ "type": "graph",
+ "xaxis": {
+ "mode": "time",
+ "name": null,
+ "show": true,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "format": "ops",
+ "label": "",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ },
+ {
+ "format": "short",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ }
+ ]
+ },
+ {
+ "aliasColors": {},
+ "bars": false,
+ "datasource": "jmeterdb",
+ "editable": true,
+ "error": false,
+ "fill": 1,
+ "grid": {},
+ "height": "",
+ "id": 34,
+ "interval": "",
+ "legend": {
+ "alignAsTable": true,
+ "avg": true,
+ "current": true,
+ "hideEmpty": true,
+ "hideZero": true,
+ "max": true,
+ "min": true,
+ "rightSide": false,
+ "show": true,
+ "total": false,
+ "values": true
+ },
+ "lines": true,
+ "linewidth": 1,
+ "links": [],
+ "minSpan": 12,
+ "nullPointMode": "null",
+ "percentage": false,
+ "pointradius": 1,
+ "points": false,
+ "renderer": "flot",
+ "seriesOverrides": [],
+ "span": 12,
+ "stack": false,
+ "steppedLine": true,
+ "targets": [
+ {
+ "alias": "$tag_transaction - $tag_responseCode : $tag_responseMessage",
+ "dsType": "influxdb",
+ "groupBy": [
+ {
+ "params": [
+ "30s"
+ ],
+ "type": "time"
+ },
+ {
+ "params": [
+ "responseMessage"
+ ],
+ "type": "tag"
+ },
+ {
+ "params": [
+ "responseCode"
+ ],
+ "type": "tag"
+ },
+ {
+ "params": [
+ "transaction"
+ ],
+ "type": "tag"
+ },
+ {
+ "params": [
+ "null"
+ ],
+ "type": "fill"
+ }
+ ],
+ "measurement": "jmeter",
+ "policy": "$retention",
+ "query": "SELECT sum(\"count\") / 5 FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND \"statut\" = 'ko' AND $timeFilter GROUP BY time($granularity), \"responseCode\" fill(null)",
+ "rawQuery": false,
+ "refId": "B",
+ "resultFormat": "time_series",
+ "select": [
+ [
+ {
+ "params": [
+ "count"
+ ],
+ "type": "field"
+ },
+ {
+ "params": [],
+ "type": "sum"
+ },
+ {
+ "params": [
+ " / 30"
+ ],
+ "type": "math"
+ }
+ ]
+ ],
+ "tags": [
+ {
+ "key": "application",
+ "operator": "=~",
+ "value": "/$app$/"
+ },
+ {
+ "condition": "AND",
+ "key": "responseCode",
+ "operator": "!~",
+ "value": "/^0$|^$/"
+ },
+ {
+ "condition": "AND",
+ "key": "transaction",
+ "operator": "=~",
+ "value": "/$transaction/"
+ }
+ ]
+ }
+ ],
+ "thresholds": [],
+ "timeFrom": null,
+ "timeShift": null,
+ "title": "Error detail",
+ "tooltip": {
+ "msResolution": false,
+ "shared": true,
+ "sort": 0,
+ "value_type": "cumulative"
+ },
+ "transparent": false,
+ "type": "graph",
+ "xaxis": {
+ "mode": "time",
+ "name": null,
+ "show": true,
+ "values": []
+ },
+ "yaxes": [
+ {
+ "format": "none",
+ "label": "",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ },
+ {
+ "format": "short",
+ "logBase": 1,
+ "max": null,
+ "min": null,
+ "show": true
+ }
+ ]
+ }
+ ],
+ "showTitle": true,
+ "titleSize": "h6",
+ "height": "700px",
+ "repeat": null,
+ "repeatRowId": null,
+ "repeatIteration": null,
+ "collapse": false
+ }
+ ]
+}
\ No newline at end of file
Propchange: jmeter/trunk/extras/GrafanaJMeterTemplate.json
------------------------------------------------------------------------------
svn:eol-style = native
Re: svn commit: r1798053 - /jmeter/trunk/extras/GrafanaJMeterTemplate.json
Posted by Maxime Chassagneux <ma...@gmail.com>.
Hi,
Yeah my bad, I modify it.
2017-06-26 16:05 GMT+02:00 sebb <se...@gmail.com>:
> On 8 June 2017 at 13:53, <mc...@apache.org> wrote:
> > Author: mchassagneux
> > Date: Thu Jun 8 12:53:52 2017
> > New Revision: 1798053
> >
> > URL: http://svn.apache.org/viewvc?rev=1798053&view=rev
> > Log:
> > Add a Grafana Template
> > Bugzilla Id: 61167
> >
> > Added:
> > jmeter/trunk/extras/GrafanaJMeterTemplate.json (with props)
> >
> > Added: jmeter/trunk/extras/GrafanaJMeterTemplate.json
> > URL: http://svn.apache.org/viewvc/jmeter/trunk/extras/
> GrafanaJMeterTemplate.json?rev=1798053&view=auto
> > ============================================================
> ==================
> > --- jmeter/trunk/extras/GrafanaJMeterTemplate.json (added)
> > +++ jmeter/trunk/extras/GrafanaJMeterTemplate.json Thu Jun 8 12:53:52
> 2017
> > @@ -0,0 +1,1459 @@
> > +{
>
> The characters before the '{' don't look right.
>
> Maybe a spurious UTF BOM?
>
> > + "id": 97,
> > + "title": "JMeter Metric Template",
> > + "tags": [],
> > + "style": "dark",
> > + "timezone": "browser",
> > + "editable": true,
> > + "sharedCrosshair": true,
> > + "hideControls": false,
> > + "time": {
> > + "from": "2017-06-08T01:09:30.935Z",
> > + "to": "2017-06-08T02:55:58.972Z"
> > + },
> > + "timepicker": {
> > + "now": true,
> > + "refresh_intervals": [
> > + "10s",
> > + "30s",
> > + "1m",
> > + "5m",
> > + "15m",
> > + "30m",
> > + "1h",
> > + "2h",
> > + "1d"
> > + ],
> > + "time_options": [
> > + "5m",
> > + "15m",
> > + "1h",
> > + "6h",
> > + "12h",
> > + "24h",
> > + "2d",
> > + "7d",
> > + "30d"
> > + ]
> > + },
> > + "templating": {
> > + "list": [
> > + {
> > + "allValue": ".*",
> > + "datasource": "jmeterdb",
> > + "hide": 0,
> > + "includeAll": false,
> > + "label": null,
> > + "multi": true,
> > + "name": "app",
> > + "options": [],
> > + "query": "SHOW TAG VALUES FROM \"process\" WITH KEY =
> \"application\"",
> > + "refresh": 2,
> > + "regex": "",
> > + "sort": 1,
> > + "tagValuesQuery": "",
> > + "tagsQuery": "SHOW TAG VALUES FROM \"events\" WITH KEY =
> \"tags\"",
> > + "type": "query"
> > + },
> > + {
> > + "allFormat": "regex wildcard",
> > + "auto": false,
> > + "auto_count": 10,
> > + "auto_min": "10s",
> > + "current": {
> > + "text": "1m",
> > + "value": "1m"
> > + },
> > + "datasource": "jmeterdb",
> > + "hide": 0,
> > + "includeAll": true,
> > + "label": "",
> > + "multi": false,
> > + "multiFormat": "glob",
> > + "name": "granularity",
> > + "options": [
> > + {
> > + "text": "1m",
> > + "value": "1m",
> > + "selected": true
> > + },
> > + {
> > + "text": "5m",
> > + "value": "5m",
> > + "selected": false
> > + },
> > + {
> > + "text": "1h",
> > + "value": "1h",
> > + "selected": false
> > + },
> > + {
> > + "text": "5s",
> > + "value": "5s",
> > + "selected": false
> > + },
> > + {
> > + "text": "15s",
> > + "value": "15s",
> > + "selected": false
> > + },
> > + {
> > + "text": "30s",
> > + "value": "30s",
> > + "selected": false
> > + }
> > + ],
> > + "query": "1m,5m,1h,5s,15s,30s",
> > + "refresh": 2,
> > + "regex": "",
> > + "type": "interval"
> > + },
> > + {
> > + "allValue": null,
> > + "current": {
> > + "text": "default",
> > + "value": "default",
> > + "tags": []
> > + },
> > + "datasource": "jmeterdb",
> > + "hide": 0,
> > + "includeAll": false,
> > + "label": null,
> > + "multi": false,
> > + "name": "retention",
> > + "options": [],
> > + "query": "SHOW RETENTION POLICIES ON \"jmeterdb\"",
> > + "refresh": 1,
> > + "regex": "",
> > + "sort": 0,
> > + "tagValuesQuery": null,
> > + "tagsQuery": null,
> > + "type": "query"
> > + },
> > + {
> > + "allValue": ".*",
> > + "current": {
> > + "value": [
> > + "$__all"
> > + ],
> > + "text": "All"
> > + },
> > + "datasource": "jmeterdb",
> > + "hide": 0,
> > + "includeAll": true,
> > + "label": null,
> > + "multi": true,
> > + "name": "transaction",
> > + "options": [],
> > + "query": "SHOW TAG VALUES FROM \"jmeter\" WITH KEY IN
> (\"transaction\",\"application\") where application =~ /$app/ and
> transaction !~ /all/",
> > + "refresh": 2,
> > + "regex": "",
> > + "sort": 0,
> > + "tagValuesQuery": null,
> > + "tagsQuery": null,
> > + "type": "query"
> > + }
> > + ]
> > + },
> > + "annotations": {
> > + "list": [
> > + {
> > + "datasource": "jmeterdb",
> > + "enable": true,
> > + "iconColor": "rgb(237, 18, 18)",
> > + "iconSize": 17,
> > + "lineColor": "rgb(0, 21, 255)",
> > + "name": "Annotation",
> > + "query": "select text,tags,title from \"$retention\".\"events\"
> where application =~ /$app/ AND $timeFilter",
> > + "showLine": true,
> > + "textColumn": "text",
> > + "titleColumn": "title",
> > + "tagsColumn": "tags"
> > + }
> > + ]
> > + },
> > + "refresh": false,
> > + "schemaVersion": 13,
> > + "version": 0,
> > + "links": [
> > + {
> > + "asDropdown": true,
> > + "icon": "dashboard",
> > + "includeVars": true,
> > + "keepTime": true,
> > + "tags": [],
> > + "targetBlank": true,
> > + "tooltip": "",
> > + "type": "dashboards",
> > + "url": ""
> > + }
> > + ],
> > + "gnetId": null,
> > + "rows": [
> > + {
> > + "title": "Jmeter Metrics",
> > + "panels": [
> > + {
> > + "cacheTimeout": null,
> > + "colorBackground": false,
> > + "colorValue": false,
> > + "colors": [
> > + "rgba(245, 54, 54, 0.9)",
> > + "rgba(237, 129, 40, 0.89)",
> > + "rgba(50, 172, 45, 0.97)"
> > + ],
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "format": "none",
> > + "gauge": {
> > + "maxValue": 100,
> > + "minValue": 0,
> > + "show": false,
> > + "thresholdLabels": false,
> > + "thresholdMarkers": true
> > + },
> > + "id": 19,
> > + "interval": "$granularity",
> > + "links": [],
> > + "mappingType": 1,
> > + "mappingTypes": [
> > + {
> > + "name": "value to text",
> > + "value": 1
> > + },
> > + {
> > + "name": "range to text",
> > + "value": 2
> > + }
> > + ],
> > + "maxDataPoints": 100,
> > + "nullPointMode": "connected",
> > + "nullText": null,
> > + "postfix": " users",
> > + "postfixFontSize": "50%",
> > + "prefix": "",
> > + "prefixFontSize": "50%",
> > + "rangeMaps": [
> > + {
> > + "from": "null",
> > + "text": "N/A",
> > + "to": "null"
> > + }
> > + ],
> > + "span": 4,
> > + "sparkline": {
> > + "fillColor": "rgba(31, 118, 189, 0.18)",
> > + "full": true,
> > + "lineColor": "rgb(31, 120, 193)",
> > + "show": true
> > + },
> > + "targets": [
> > + {
> > + "dsType": "influxdb",
> > + "groupBy": [
> > + {
> > + "params": [
> > + "$granularity"
> > + ],
> > + "type": "time"
> > + },
> > + {
> > + "params": [
> > + "null"
> > + ],
> > + "type": "fill"
> > + }
> > + ],
> > + "measurement": "jmeter",
> > + "policy": "$retention",
> > + "query": "SELECT last(\"startedT\") FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity)
> fill(null)",
> > + "refId": "A",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "meanAT"
> > + ],
> > + "type": "field"
> > + },
> > + {
> > + "params": [],
> > + "type": "last"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": "",
> > + "title": "Active Users",
> > + "type": "singlestat",
> > + "valueFontSize": "80%",
> > + "valueMaps": [
> > + {
> > + "op": "=",
> > + "text": "0",
> > + "value": "null"
> > + }
> > + ],
> > + "valueName": "current"
> > + },
> > + {
> > + "cacheTimeout": null,
> > + "colorBackground": false,
> > + "colorValue": false,
> > + "colors": [
> > + "rgba(245, 54, 54, 0.9)",
> > + "rgba(237, 129, 40, 0.89)",
> > + "rgba(50, 172, 45, 0.97)"
> > + ],
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "format": "none",
> > + "gauge": {
> > + "maxValue": 100,
> > + "minValue": 0,
> > + "show": false,
> > + "thresholdLabels": false,
> > + "thresholdMarkers": true
> > + },
> > + "id": 17,
> > + "interval": "",
> > + "links": [],
> > + "mappingType": 1,
> > + "mappingTypes": [
> > + {
> > + "name": "value to text",
> > + "value": 1
> > + },
> > + {
> > + "name": "range to text",
> > + "value": 2
> > + }
> > + ],
> > + "maxDataPoints": 100,
> > + "nullPointMode": "connected",
> > + "nullText": null,
> > + "postfix": " TPS",
> > + "postfixFontSize": "50%",
> > + "prefix": "",
> > + "prefixFontSize": "50%",
> > + "rangeMaps": [
> > + {
> > + "from": "null",
> > + "text": "N/A",
> > + "to": "null"
> > + }
> > + ],
> > + "span": 4,
> > + "sparkline": {
> > + "fillColor": "rgba(31, 118, 189, 0.18)",
> > + "full": true,
> > + "lineColor": "rgb(31, 120, 193)",
> > + "show": true
> > + },
> > + "targets": [
> > + {
> > + "dsType": "influxdb",
> > + "groupBy": [
> > + {
> > + "params": [
> > + "$granularity"
> > + ],
> > + "type": "time"
> > + }
> > + ],
> > + "measurement": "jmeter",
> > + "policy": "default",
> > + "query": "SELECT sum(\"hit\") / 30 FROM
> \"$retention\".\"jmeter\" WHERE \"application\" = '$app' AND
> \"transaction\" = 'all' AND $timeFilter GROUP BY time(30s)",
> > + "rawQuery": true,
> > + "refId": "A",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "hit"
> > + ],
> > + "type": "field"
> > + },
> > + {
> > + "params": [],
> > + "type": "last"
> > + },
> > + {
> > + "params": [
> > + " / 5"
> > + ],
> > + "type": "math"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + },
> > + {
> > + "condition": "AND",
> > + "key": "transaction",
> > + "operator": "=",
> > + "value": "all"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": "",
> > + "title": "Currents hits per Second",
> > + "type": "singlestat",
> > + "valueFontSize": "80%",
> > + "valueMaps": [
> > + {
> > + "op": "=",
> > + "text": "0",
> > + "value": "null"
> > + }
> > + ],
> > + "valueName": "current"
> > + },
> > + {
> > + "cacheTimeout": null,
> > + "colorBackground": false,
> > + "colorValue": true,
> > + "colors": [
> > + "rgba(50, 172, 45, 0.97)",
> > + "rgba(237, 129, 40, 0.89)",
> > + "rgba(245, 54, 54, 0.9)"
> > + ],
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "format": "percentunit",
> > + "gauge": {
> > + "maxValue": 100,
> > + "minValue": 0,
> > + "show": false,
> > + "thresholdLabels": false,
> > + "thresholdMarkers": true
> > + },
> > + "id": 21,
> > + "interval": "$granularity",
> > + "links": [],
> > + "mappingType": 1,
> > + "mappingTypes": [
> > + {
> > + "name": "value to text",
> > + "value": 1
> > + },
> > + {
> > + "name": "range to text",
> > + "value": 2
> > + }
> > + ],
> > + "maxDataPoints": 100,
> > + "nullPointMode": "connected",
> > + "nullText": null,
> > + "postfix": "",
> > + "postfixFontSize": "50%",
> > + "prefix": "",
> > + "prefixFontSize": "50%",
> > + "rangeMaps": [
> > + {
> > + "from": "null",
> > + "text": "N/A",
> > + "to": "null"
> > + }
> > + ],
> > + "span": 4,
> > + "sparkline": {
> > + "fillColor": "rgba(31, 118, 189, 0.18)",
> > + "full": true,
> > + "lineColor": "rgb(31, 120, 193)",
> > + "show": true
> > + },
> > + "targets": [
> > + {
> > + "dsType": "influxdb",
> > + "groupBy": [],
> > + "measurement": "jmeter",
> > + "policy": "$retention",
> > + "query": "SELECT sum(\"countError\") / sum(\"count\")
> FROM \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND
> \"transaction\" = 'all' AND $timeFilter",
> > + "rawQuery": true,
> > + "refId": "B",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "countError"
> > + ],
> > + "type": "field"
> > + },
> > + {
> > + "params": [],
> > + "type": "sum"
> > + },
> > + {
> > + "params": [
> > + " / sum(\"count\")"
> > + ],
> > + "type": "math"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + },
> > + {
> > + "condition": "AND",
> > + "key": "transaction",
> > + "operator": "=",
> > + "value": "all"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": "0.1,0.2",
> > + "title": "% Errors",
> > + "type": "singlestat",
> > + "valueFontSize": "80%",
> > + "valueMaps": [
> > + {
> > + "op": "=",
> > + "text": "0",
> > + "value": "null"
> > + }
> > + ],
> > + "valueName": "total"
> > + },
> > + {
> > + "aliasColors": {},
> > + "bars": false,
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "fill": 1,
> > + "grid": {},
> > + "id": 27,
> > + "interval": "$granularity",
> > + "legend": {
> > + "avg": false,
> > + "current": false,
> > + "max": false,
> > + "min": false,
> > + "show": false,
> > + "total": false,
> > + "values": false
> > + },
> > + "lines": true,
> > + "linewidth": 1,
> > + "links": [],
> > + "nullPointMode": "null as zero",
> > + "percentage": false,
> > + "pointradius": 5,
> > + "points": false,
> > + "renderer": "flot",
> > + "seriesOverrides": [],
> > + "span": 4,
> > + "stack": false,
> > + "steppedLine": true,
> > + "targets": [
> > + {
> > + "alias": "Hits",
> > + "dsType": "influxdb",
> > + "groupBy": [
> > + {
> > + "params": [
> > + "$granularity"
> > + ],
> > + "type": "time"
> > + },
> > + {
> > + "params": [
> > + "null"
> > + ],
> > + "type": "fill"
> > + }
> > + ],
> > + "measurement": "jmeter",
> > + "policy": "$retention",
> > + "query": "SELECT last(\"hit\") / 5 FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity)
> fill(null)",
> > + "refId": "A",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "hit"
> > + ],
> > + "type": "field"
> > + },
> > + {
> > + "params": [],
> > + "type": "last"
> > + },
> > + {
> > + "params": [
> > + " / 5"
> > + ],
> > + "type": "math"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": [],
> > + "timeFrom": null,
> > + "timeShift": null,
> > + "title": "Hits per Second",
> > + "tooltip": {
> > + "msResolution": false,
> > + "shared": true,
> > + "sort": 0,
> > + "value_type": "cumulative"
> > + },
> > + "type": "graph",
> > + "xaxis": {
> > + "mode": "time",
> > + "name": null,
> > + "show": false,
> > + "values": []
> > + },
> > + "yaxes": [
> > + {
> > + "format": "short",
> > + "logBase": 1,
> > + "max": null,
> > + "min": 0,
> > + "show": true
> > + },
> > + {
> > + "format": "short",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + }
> > + ]
> > + },
> > + {
> > + "cacheTimeout": null,
> > + "colorBackground": false,
> > + "colorValue": false,
> > + "colors": [
> > + "rgba(245, 54, 54, 0.9)",
> > + "rgba(237, 129, 40, 0.89)",
> > + "rgba(50, 172, 45, 0.97)"
> > + ],
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "format": "none",
> > + "gauge": {
> > + "maxValue": 100,
> > + "minValue": 0,
> > + "show": false,
> > + "thresholdLabels": false,
> > + "thresholdMarkers": true
> > + },
> > + "id": 22,
> > + "interval": "$granularity",
> > + "links": [],
> > + "mappingType": 1,
> > + "mappingTypes": [
> > + {
> > + "name": "value to text",
> > + "value": 1
> > + },
> > + {
> > + "name": "range to text",
> > + "value": 2
> > + }
> > + ],
> > + "maxDataPoints": 100,
> > + "nullPointMode": "connected",
> > + "nullText": null,
> > + "postfix": "",
> > + "postfixFontSize": "50%",
> > + "prefix": "",
> > + "prefixFontSize": "50%",
> > + "rangeMaps": [
> > + {
> > + "from": "null",
> > + "text": "N/A",
> > + "to": "null"
> > + }
> > + ],
> > + "span": 4,
> > + "sparkline": {
> > + "fillColor": "rgba(31, 118, 189, 0.18)",
> > + "full": true,
> > + "lineColor": "rgb(31, 120, 193)",
> > + "show": true
> > + },
> > + "targets": [
> > + {
> > + "dsType": "influxdb",
> > + "groupBy": [],
> > + "measurement": "jmeter",
> > + "policy": "$retention",
> > + "query": "SELECT \"hit\" FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND \"statut\" = 'all' AND $timeFilter",
> > + "rawQuery": false,
> > + "refId": "A",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "hit"
> > + ],
> > + "type": "field"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + },
> > + {
> > + "condition": "AND",
> > + "key": "statut",
> > + "operator": "=",
> > + "value": "all"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": "",
> > + "title": "Total Hits",
> > + "type": "singlestat",
> > + "valueFontSize": "80%",
> > + "valueMaps": [
> > + {
> > + "op": "=",
> > + "text": "0",
> > + "value": "null"
> > + }
> > + ],
> > + "valueName": "total"
> > + },
> > + {
> > + "aliasColors": {},
> > + "bars": false,
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "fill": 1,
> > + "grid": {},
> > + "id": 28,
> > + "interval": "$granularity",
> > + "legend": {
> > + "avg": false,
> > + "current": false,
> > + "max": false,
> > + "min": false,
> > + "show": false,
> > + "total": false,
> > + "values": false
> > + },
> > + "lines": true,
> > + "linewidth": 1,
> > + "links": [],
> > + "nullPointMode": "null",
> > + "percentage": false,
> > + "pointradius": 5,
> > + "points": false,
> > + "renderer": "flot",
> > + "seriesOverrides": [],
> > + "span": 4,
> > + "stack": false,
> > + "steppedLine": true,
> > + "targets": [
> > + {
> > + "alias": "Errors",
> > + "dsType": "influxdb",
> > + "groupBy": [
> > + {
> > + "params": [
> > + "$granularity"
> > + ],
> > + "type": "time"
> > + },
> > + {
> > + "params": [
> > + "0"
> > + ],
> > + "type": "fill"
> > + }
> > + ],
> > + "measurement": "jmeter",
> > + "policy": "$retention",
> > + "query": "SELECT mean(\"countError\") / 5 FROM
> \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY
> time($granularity) fill(0)",
> > + "rawQuery": false,
> > + "refId": "A",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "countError"
> > + ],
> > + "type": "field"
> > + },
> > + {
> > + "params": [],
> > + "type": "mean"
> > + },
> > + {
> > + "params": [
> > + " / 5"
> > + ],
> > + "type": "math"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": [],
> > + "timeFrom": null,
> > + "timeShift": null,
> > + "title": "Errors per Second",
> > + "tooltip": {
> > + "msResolution": false,
> > + "shared": true,
> > + "sort": 0,
> > + "value_type": "cumulative"
> > + },
> > + "type": "graph",
> > + "xaxis": {
> > + "mode": "time",
> > + "name": null,
> > + "show": false,
> > + "values": []
> > + },
> > + "yaxes": [
> > + {
> > + "format": "short",
> > + "logBase": 1,
> > + "max": null,
> > + "min": 0,
> > + "show": true
> > + },
> > + {
> > + "format": "short",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + }
> > + ]
> > + }
> > + ],
> > + "showTitle": true,
> > + "titleSize": "h6",
> > + "height": "150px",
> > + "repeat": null,
> > + "repeatRowId": null,
> > + "repeatIteration": null,
> > + "collapse": false
> > + },
> > + {
> > + "title": "Application Metrics",
> > + "panels": [
> > + {
> > + "aliasColors": {},
> > + "bars": false,
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "fill": 1,
> > + "grid": {},
> > + "height": "",
> > + "id": 25,
> > + "interval": "$granularity",
> > + "legend": {
> > + "alignAsTable": true,
> > + "avg": true,
> > + "current": true,
> > + "hideEmpty": false,
> > + "max": true,
> > + "min": true,
> > + "rightSide": false,
> > + "show": true,
> > + "total": false,
> > + "values": true
> > + },
> > + "lines": true,
> > + "linewidth": 1,
> > + "links": [],
> > + "minSpan": 12,
> > + "nullPointMode": "null",
> > + "percentage": false,
> > + "pointradius": 5,
> > + "points": false,
> > + "renderer": "flot",
> > + "seriesOverrides": [],
> > + "span": 12,
> > + "stack": false,
> > + "steppedLine": true,
> > + "targets": [
> > + {
> > + "alias": "$tag_transaction",
> > + "dsType": "influxdb",
> > + "groupBy": [
> > + {
> > + "params": [
> > + "$granularity"
> > + ],
> > + "type": "time"
> > + },
> > + {
> > + "params": [
> > + "transaction"
> > + ],
> > + "type": "tag"
> > + }
> > + ],
> > + "hide": false,
> > + "measurement": "jmeter",
> > + "policy": "$retention",
> > + "query": "SELECT mean(\"avg\") FROM \"jmeter\" WHERE
> \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity),
> \"transaction\"",
> > + "rawQuery": false,
> > + "refId": "A",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "avg"
> > + ],
> > + "type": "field"
> > + },
> > + {
> > + "params": [],
> > + "type": "mean"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + },
> > + {
> > + "condition": "AND",
> > + "key": "statut",
> > + "operator": "=",
> > + "value": "all"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": [],
> > + "timeFrom": null,
> > + "timeShift": null,
> > + "title": "Average Response Time",
> > + "tooltip": {
> > + "msResolution": false,
> > + "shared": false,
> > + "sort": 0,
> > + "value_type": "cumulative"
> > + },
> > + "transparent": false,
> > + "type": "graph",
> > + "xaxis": {
> > + "mode": "time",
> > + "name": null,
> > + "show": true,
> > + "values": []
> > + },
> > + "yaxes": [
> > + {
> > + "format": "ms",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + },
> > + {
> > + "format": "short",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + }
> > + ]
> > + },
> > + {
> > + "aliasColors": {},
> > + "bars": false,
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "fill": 1,
> > + "grid": {},
> > + "height": "",
> > + "id": 26,
> > + "interval": "$granularity",
> > + "legend": {
> > + "alignAsTable": true,
> > + "avg": true,
> > + "current": true,
> > + "hideEmpty": false,
> > + "max": true,
> > + "min": true,
> > + "rightSide": false,
> > + "show": true,
> > + "sort": "current",
> > + "sortDesc": true,
> > + "total": false,
> > + "values": true
> > + },
> > + "lines": true,
> > + "linewidth": 1,
> > + "links": [],
> > + "minSpan": 12,
> > + "nullPointMode": "null",
> > + "percentage": false,
> > + "pointradius": 5,
> > + "points": false,
> > + "renderer": "flot",
> > + "seriesOverrides": [],
> > + "span": 12,
> > + "stack": false,
> > + "steppedLine": true,
> > + "targets": [
> > + {
> > + "alias": "$tag_transaction",
> > + "dsType": "influxdb",
> > + "groupBy": [
> > + {
> > + "params": [
> > + "30s"
> > + ],
> > + "type": "time"
> > + },
> > + {
> > + "params": [
> > + "transaction"
> > + ],
> > + "type": "tag"
> > + }
> > + ],
> > + "measurement": "jmeter",
> > + "policy": "$retention",
> > + "query": "SELECT mean(\"count\") / 5 FROM \"jmeter\"
> WHERE \"application\" =~ /$app$/ AND \"transaction\" <> 'all' AND
> $timeFilter GROUP BY time($granularity), \"transaction\"",
> > + "rawQuery": false,
> > + "refId": "A",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "count"
> > + ],
> > + "type": "field"
> > + },
> > + {
> > + "params": [],
> > + "type": "sum"
> > + },
> > + {
> > + "params": [
> > + " / 30"
> > + ],
> > + "type": "math"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + },
> > + {
> > + "condition": "AND",
> > + "key": "transaction",
> > + "operator": "<>",
> > + "value": "all"
> > + },
> > + {
> > + "condition": "AND",
> > + "key": "statut",
> > + "operator": "=",
> > + "value": "all"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": [],
> > + "timeFrom": null,
> > + "timeShift": null,
> > + "title": "Transaction Per Second",
> > + "tooltip": {
> > + "msResolution": false,
> > + "shared": false,
> > + "sort": 0,
> > + "value_type": "cumulative"
> > + },
> > + "transparent": false,
> > + "type": "graph",
> > + "xaxis": {
> > + "mode": "time",
> > + "name": null,
> > + "show": true,
> > + "values": []
> > + },
> > + "yaxes": [
> > + {
> > + "format": "ops",
> > + "label": "",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + },
> > + {
> > + "format": "short",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + }
> > + ]
> > + },
> > + {
> > + "aliasColors": {},
> > + "bars": false,
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "fill": 1,
> > + "grid": {},
> > + "height": "",
> > + "id": 29,
> > + "interval": "$granularity",
> > + "legend": {
> > + "alignAsTable": true,
> > + "avg": true,
> > + "current": true,
> > + "hideEmpty": false,
> > + "max": true,
> > + "min": true,
> > + "rightSide": false,
> > + "show": true,
> > + "total": false,
> > + "values": true
> > + },
> > + "lines": true,
> > + "linewidth": 1,
> > + "links": [],
> > + "minSpan": 12,
> > + "nullPointMode": "null",
> > + "percentage": false,
> > + "pointradius": 5,
> > + "points": false,
> > + "renderer": "flot",
> > + "seriesOverrides": [],
> > + "span": 12,
> > + "stack": false,
> > + "steppedLine": true,
> > + "targets": [
> > + {
> > + "alias": "$tag_transaction",
> > + "dsType": "influxdb",
> > + "groupBy": [
> > + {
> > + "params": [
> > + "30s"
> > + ],
> > + "type": "time"
> > + },
> > + {
> > + "params": [
> > + "transaction"
> > + ],
> > + "type": "tag"
> > + },
> > + {
> > + "params": [
> > + "null"
> > + ],
> > + "type": "fill"
> > + }
> > + ],
> > + "measurement": "jmeter",
> > + "policy": "$retention",
> > + "query": "SELECT last(\"count\") / 30 FROM
> \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND \"statut\" =
> 'ko' AND $timeFilter GROUP BY time(30s), \"transaction\" fill(null)",
> > + "rawQuery": false,
> > + "refId": "B",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "count"
> > + ],
> > + "type": "field"
> > + },
> > + {
> > + "params": [],
> > + "type": "sum"
> > + },
> > + {
> > + "params": [
> > + " / 30"
> > + ],
> > + "type": "math"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + },
> > + {
> > + "condition": "AND",
> > + "key": "statut",
> > + "operator": "=",
> > + "value": "ko"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": [],
> > + "timeFrom": null,
> > + "timeShift": null,
> > + "title": "Error Per Second",
> > + "tooltip": {
> > + "msResolution": false,
> > + "shared": false,
> > + "sort": 0,
> > + "value_type": "cumulative"
> > + },
> > + "transparent": false,
> > + "type": "graph",
> > + "xaxis": {
> > + "mode": "time",
> > + "name": null,
> > + "show": true,
> > + "values": []
> > + },
> > + "yaxes": [
> > + {
> > + "format": "ops",
> > + "label": "",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + },
> > + {
> > + "format": "short",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + }
> > + ]
> > + },
> > + {
> > + "aliasColors": {},
> > + "bars": false,
> > + "datasource": "jmeterdb",
> > + "editable": true,
> > + "error": false,
> > + "fill": 1,
> > + "grid": {},
> > + "height": "",
> > + "id": 34,
> > + "interval": "",
> > + "legend": {
> > + "alignAsTable": true,
> > + "avg": true,
> > + "current": true,
> > + "hideEmpty": true,
> > + "hideZero": true,
> > + "max": true,
> > + "min": true,
> > + "rightSide": false,
> > + "show": true,
> > + "total": false,
> > + "values": true
> > + },
> > + "lines": true,
> > + "linewidth": 1,
> > + "links": [],
> > + "minSpan": 12,
> > + "nullPointMode": "null",
> > + "percentage": false,
> > + "pointradius": 1,
> > + "points": false,
> > + "renderer": "flot",
> > + "seriesOverrides": [],
> > + "span": 12,
> > + "stack": false,
> > + "steppedLine": true,
> > + "targets": [
> > + {
> > + "alias": "$tag_transaction - $tag_responseCode :
> $tag_responseMessage",
> > + "dsType": "influxdb",
> > + "groupBy": [
> > + {
> > + "params": [
> > + "30s"
> > + ],
> > + "type": "time"
> > + },
> > + {
> > + "params": [
> > + "responseMessage"
> > + ],
> > + "type": "tag"
> > + },
> > + {
> > + "params": [
> > + "responseCode"
> > + ],
> > + "type": "tag"
> > + },
> > + {
> > + "params": [
> > + "transaction"
> > + ],
> > + "type": "tag"
> > + },
> > + {
> > + "params": [
> > + "null"
> > + ],
> > + "type": "fill"
> > + }
> > + ],
> > + "measurement": "jmeter",
> > + "policy": "$retention",
> > + "query": "SELECT sum(\"count\") / 5 FROM \"jmeter\"
> WHERE \"application\" =~ /$app$/ AND \"statut\" = 'ko' AND $timeFilter
> GROUP BY time($granularity), \"responseCode\" fill(null)",
> > + "rawQuery": false,
> > + "refId": "B",
> > + "resultFormat": "time_series",
> > + "select": [
> > + [
> > + {
> > + "params": [
> > + "count"
> > + ],
> > + "type": "field"
> > + },
> > + {
> > + "params": [],
> > + "type": "sum"
> > + },
> > + {
> > + "params": [
> > + " / 30"
> > + ],
> > + "type": "math"
> > + }
> > + ]
> > + ],
> > + "tags": [
> > + {
> > + "key": "application",
> > + "operator": "=~",
> > + "value": "/$app$/"
> > + },
> > + {
> > + "condition": "AND",
> > + "key": "responseCode",
> > + "operator": "!~",
> > + "value": "/^0$|^$/"
> > + },
> > + {
> > + "condition": "AND",
> > + "key": "transaction",
> > + "operator": "=~",
> > + "value": "/$transaction/"
> > + }
> > + ]
> > + }
> > + ],
> > + "thresholds": [],
> > + "timeFrom": null,
> > + "timeShift": null,
> > + "title": "Error detail",
> > + "tooltip": {
> > + "msResolution": false,
> > + "shared": true,
> > + "sort": 0,
> > + "value_type": "cumulative"
> > + },
> > + "transparent": false,
> > + "type": "graph",
> > + "xaxis": {
> > + "mode": "time",
> > + "name": null,
> > + "show": true,
> > + "values": []
> > + },
> > + "yaxes": [
> > + {
> > + "format": "none",
> > + "label": "",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + },
> > + {
> > + "format": "short",
> > + "logBase": 1,
> > + "max": null,
> > + "min": null,
> > + "show": true
> > + }
> > + ]
> > + }
> > + ],
> > + "showTitle": true,
> > + "titleSize": "h6",
> > + "height": "700px",
> > + "repeat": null,
> > + "repeatRowId": null,
> > + "repeatIteration": null,
> > + "collapse": false
> > + }
> > + ]
> > +}
> > \ No newline at end of file
> >
> > Propchange: jmeter/trunk/extras/GrafanaJMeterTemplate.json
> > ------------------------------------------------------------
> ------------------
> > svn:eol-style = native
> >
> >
>
>
Re: svn commit: r1798053 - /jmeter/trunk/extras/GrafanaJMeterTemplate.json
Posted by sebb <se...@gmail.com>.
On 8 June 2017 at 13:53, <mc...@apache.org> wrote:
> Author: mchassagneux
> Date: Thu Jun 8 12:53:52 2017
> New Revision: 1798053
>
> URL: http://svn.apache.org/viewvc?rev=1798053&view=rev
> Log:
> Add a Grafana Template
> Bugzilla Id: 61167
>
> Added:
> jmeter/trunk/extras/GrafanaJMeterTemplate.json (with props)
>
> Added: jmeter/trunk/extras/GrafanaJMeterTemplate.json
> URL: http://svn.apache.org/viewvc/jmeter/trunk/extras/GrafanaJMeterTemplate.json?rev=1798053&view=auto
> ==============================================================================
> --- jmeter/trunk/extras/GrafanaJMeterTemplate.json (added)
> +++ jmeter/trunk/extras/GrafanaJMeterTemplate.json Thu Jun 8 12:53:52 2017
> @@ -0,0 +1,1459 @@
> +{
The characters before the '{' don't look right.
Maybe a spurious UTF BOM?
> + "id": 97,
> + "title": "JMeter Metric Template",
> + "tags": [],
> + "style": "dark",
> + "timezone": "browser",
> + "editable": true,
> + "sharedCrosshair": true,
> + "hideControls": false,
> + "time": {
> + "from": "2017-06-08T01:09:30.935Z",
> + "to": "2017-06-08T02:55:58.972Z"
> + },
> + "timepicker": {
> + "now": true,
> + "refresh_intervals": [
> + "10s",
> + "30s",
> + "1m",
> + "5m",
> + "15m",
> + "30m",
> + "1h",
> + "2h",
> + "1d"
> + ],
> + "time_options": [
> + "5m",
> + "15m",
> + "1h",
> + "6h",
> + "12h",
> + "24h",
> + "2d",
> + "7d",
> + "30d"
> + ]
> + },
> + "templating": {
> + "list": [
> + {
> + "allValue": ".*",
> + "datasource": "jmeterdb",
> + "hide": 0,
> + "includeAll": false,
> + "label": null,
> + "multi": true,
> + "name": "app",
> + "options": [],
> + "query": "SHOW TAG VALUES FROM \"process\" WITH KEY = \"application\"",
> + "refresh": 2,
> + "regex": "",
> + "sort": 1,
> + "tagValuesQuery": "",
> + "tagsQuery": "SHOW TAG VALUES FROM \"events\" WITH KEY = \"tags\"",
> + "type": "query"
> + },
> + {
> + "allFormat": "regex wildcard",
> + "auto": false,
> + "auto_count": 10,
> + "auto_min": "10s",
> + "current": {
> + "text": "1m",
> + "value": "1m"
> + },
> + "datasource": "jmeterdb",
> + "hide": 0,
> + "includeAll": true,
> + "label": "",
> + "multi": false,
> + "multiFormat": "glob",
> + "name": "granularity",
> + "options": [
> + {
> + "text": "1m",
> + "value": "1m",
> + "selected": true
> + },
> + {
> + "text": "5m",
> + "value": "5m",
> + "selected": false
> + },
> + {
> + "text": "1h",
> + "value": "1h",
> + "selected": false
> + },
> + {
> + "text": "5s",
> + "value": "5s",
> + "selected": false
> + },
> + {
> + "text": "15s",
> + "value": "15s",
> + "selected": false
> + },
> + {
> + "text": "30s",
> + "value": "30s",
> + "selected": false
> + }
> + ],
> + "query": "1m,5m,1h,5s,15s,30s",
> + "refresh": 2,
> + "regex": "",
> + "type": "interval"
> + },
> + {
> + "allValue": null,
> + "current": {
> + "text": "default",
> + "value": "default",
> + "tags": []
> + },
> + "datasource": "jmeterdb",
> + "hide": 0,
> + "includeAll": false,
> + "label": null,
> + "multi": false,
> + "name": "retention",
> + "options": [],
> + "query": "SHOW RETENTION POLICIES ON \"jmeterdb\"",
> + "refresh": 1,
> + "regex": "",
> + "sort": 0,
> + "tagValuesQuery": null,
> + "tagsQuery": null,
> + "type": "query"
> + },
> + {
> + "allValue": ".*",
> + "current": {
> + "value": [
> + "$__all"
> + ],
> + "text": "All"
> + },
> + "datasource": "jmeterdb",
> + "hide": 0,
> + "includeAll": true,
> + "label": null,
> + "multi": true,
> + "name": "transaction",
> + "options": [],
> + "query": "SHOW TAG VALUES FROM \"jmeter\" WITH KEY IN (\"transaction\",\"application\") where application =~ /$app/ and transaction !~ /all/",
> + "refresh": 2,
> + "regex": "",
> + "sort": 0,
> + "tagValuesQuery": null,
> + "tagsQuery": null,
> + "type": "query"
> + }
> + ]
> + },
> + "annotations": {
> + "list": [
> + {
> + "datasource": "jmeterdb",
> + "enable": true,
> + "iconColor": "rgb(237, 18, 18)",
> + "iconSize": 17,
> + "lineColor": "rgb(0, 21, 255)",
> + "name": "Annotation",
> + "query": "select text,tags,title from \"$retention\".\"events\" where application =~ /$app/ AND $timeFilter",
> + "showLine": true,
> + "textColumn": "text",
> + "titleColumn": "title",
> + "tagsColumn": "tags"
> + }
> + ]
> + },
> + "refresh": false,
> + "schemaVersion": 13,
> + "version": 0,
> + "links": [
> + {
> + "asDropdown": true,
> + "icon": "dashboard",
> + "includeVars": true,
> + "keepTime": true,
> + "tags": [],
> + "targetBlank": true,
> + "tooltip": "",
> + "type": "dashboards",
> + "url": ""
> + }
> + ],
> + "gnetId": null,
> + "rows": [
> + {
> + "title": "Jmeter Metrics",
> + "panels": [
> + {
> + "cacheTimeout": null,
> + "colorBackground": false,
> + "colorValue": false,
> + "colors": [
> + "rgba(245, 54, 54, 0.9)",
> + "rgba(237, 129, 40, 0.89)",
> + "rgba(50, 172, 45, 0.97)"
> + ],
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "format": "none",
> + "gauge": {
> + "maxValue": 100,
> + "minValue": 0,
> + "show": false,
> + "thresholdLabels": false,
> + "thresholdMarkers": true
> + },
> + "id": 19,
> + "interval": "$granularity",
> + "links": [],
> + "mappingType": 1,
> + "mappingTypes": [
> + {
> + "name": "value to text",
> + "value": 1
> + },
> + {
> + "name": "range to text",
> + "value": 2
> + }
> + ],
> + "maxDataPoints": 100,
> + "nullPointMode": "connected",
> + "nullText": null,
> + "postfix": " users",
> + "postfixFontSize": "50%",
> + "prefix": "",
> + "prefixFontSize": "50%",
> + "rangeMaps": [
> + {
> + "from": "null",
> + "text": "N/A",
> + "to": "null"
> + }
> + ],
> + "span": 4,
> + "sparkline": {
> + "fillColor": "rgba(31, 118, 189, 0.18)",
> + "full": true,
> + "lineColor": "rgb(31, 120, 193)",
> + "show": true
> + },
> + "targets": [
> + {
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "null"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT last(\"startedT\") FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity) fill(null)",
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "meanAT"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "last"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + }
> + ]
> + }
> + ],
> + "thresholds": "",
> + "title": "Active Users",
> + "type": "singlestat",
> + "valueFontSize": "80%",
> + "valueMaps": [
> + {
> + "op": "=",
> + "text": "0",
> + "value": "null"
> + }
> + ],
> + "valueName": "current"
> + },
> + {
> + "cacheTimeout": null,
> + "colorBackground": false,
> + "colorValue": false,
> + "colors": [
> + "rgba(245, 54, 54, 0.9)",
> + "rgba(237, 129, 40, 0.89)",
> + "rgba(50, 172, 45, 0.97)"
> + ],
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "format": "none",
> + "gauge": {
> + "maxValue": 100,
> + "minValue": 0,
> + "show": false,
> + "thresholdLabels": false,
> + "thresholdMarkers": true
> + },
> + "id": 17,
> + "interval": "",
> + "links": [],
> + "mappingType": 1,
> + "mappingTypes": [
> + {
> + "name": "value to text",
> + "value": 1
> + },
> + {
> + "name": "range to text",
> + "value": 2
> + }
> + ],
> + "maxDataPoints": 100,
> + "nullPointMode": "connected",
> + "nullText": null,
> + "postfix": " TPS",
> + "postfixFontSize": "50%",
> + "prefix": "",
> + "prefixFontSize": "50%",
> + "rangeMaps": [
> + {
> + "from": "null",
> + "text": "N/A",
> + "to": "null"
> + }
> + ],
> + "span": 4,
> + "sparkline": {
> + "fillColor": "rgba(31, 118, 189, 0.18)",
> + "full": true,
> + "lineColor": "rgb(31, 120, 193)",
> + "show": true
> + },
> + "targets": [
> + {
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "default",
> + "query": "SELECT sum(\"hit\") / 30 FROM \"$retention\".\"jmeter\" WHERE \"application\" = '$app' AND \"transaction\" = 'all' AND $timeFilter GROUP BY time(30s)",
> + "rawQuery": true,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "hit"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "last"
> + },
> + {
> + "params": [
> + " / 5"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "transaction",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": "",
> + "title": "Currents hits per Second",
> + "type": "singlestat",
> + "valueFontSize": "80%",
> + "valueMaps": [
> + {
> + "op": "=",
> + "text": "0",
> + "value": "null"
> + }
> + ],
> + "valueName": "current"
> + },
> + {
> + "cacheTimeout": null,
> + "colorBackground": false,
> + "colorValue": true,
> + "colors": [
> + "rgba(50, 172, 45, 0.97)",
> + "rgba(237, 129, 40, 0.89)",
> + "rgba(245, 54, 54, 0.9)"
> + ],
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "format": "percentunit",
> + "gauge": {
> + "maxValue": 100,
> + "minValue": 0,
> + "show": false,
> + "thresholdLabels": false,
> + "thresholdMarkers": true
> + },
> + "id": 21,
> + "interval": "$granularity",
> + "links": [],
> + "mappingType": 1,
> + "mappingTypes": [
> + {
> + "name": "value to text",
> + "value": 1
> + },
> + {
> + "name": "range to text",
> + "value": 2
> + }
> + ],
> + "maxDataPoints": 100,
> + "nullPointMode": "connected",
> + "nullText": null,
> + "postfix": "",
> + "postfixFontSize": "50%",
> + "prefix": "",
> + "prefixFontSize": "50%",
> + "rangeMaps": [
> + {
> + "from": "null",
> + "text": "N/A",
> + "to": "null"
> + }
> + ],
> + "span": 4,
> + "sparkline": {
> + "fillColor": "rgba(31, 118, 189, 0.18)",
> + "full": true,
> + "lineColor": "rgb(31, 120, 193)",
> + "show": true
> + },
> + "targets": [
> + {
> + "dsType": "influxdb",
> + "groupBy": [],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT sum(\"countError\") / sum(\"count\") FROM \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND \"transaction\" = 'all' AND $timeFilter",
> + "rawQuery": true,
> + "refId": "B",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "countError"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "sum"
> + },
> + {
> + "params": [
> + " / sum(\"count\")"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "transaction",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": "0.1,0.2",
> + "title": "% Errors",
> + "type": "singlestat",
> + "valueFontSize": "80%",
> + "valueMaps": [
> + {
> + "op": "=",
> + "text": "0",
> + "value": "null"
> + }
> + ],
> + "valueName": "total"
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "id": 27,
> + "interval": "$granularity",
> + "legend": {
> + "avg": false,
> + "current": false,
> + "max": false,
> + "min": false,
> + "show": false,
> + "total": false,
> + "values": false
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "nullPointMode": "null as zero",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 4,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "Hits",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "null"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT last(\"hit\") / 5 FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity) fill(null)",
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "hit"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "last"
> + },
> + {
> + "params": [
> + " / 5"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Hits per Second",
> + "tooltip": {
> + "msResolution": false,
> + "shared": true,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": false,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": 0,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + },
> + {
> + "cacheTimeout": null,
> + "colorBackground": false,
> + "colorValue": false,
> + "colors": [
> + "rgba(245, 54, 54, 0.9)",
> + "rgba(237, 129, 40, 0.89)",
> + "rgba(50, 172, 45, 0.97)"
> + ],
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "format": "none",
> + "gauge": {
> + "maxValue": 100,
> + "minValue": 0,
> + "show": false,
> + "thresholdLabels": false,
> + "thresholdMarkers": true
> + },
> + "id": 22,
> + "interval": "$granularity",
> + "links": [],
> + "mappingType": 1,
> + "mappingTypes": [
> + {
> + "name": "value to text",
> + "value": 1
> + },
> + {
> + "name": "range to text",
> + "value": 2
> + }
> + ],
> + "maxDataPoints": 100,
> + "nullPointMode": "connected",
> + "nullText": null,
> + "postfix": "",
> + "postfixFontSize": "50%",
> + "prefix": "",
> + "prefixFontSize": "50%",
> + "rangeMaps": [
> + {
> + "from": "null",
> + "text": "N/A",
> + "to": "null"
> + }
> + ],
> + "span": 4,
> + "sparkline": {
> + "fillColor": "rgba(31, 118, 189, 0.18)",
> + "full": true,
> + "lineColor": "rgb(31, 120, 193)",
> + "show": true
> + },
> + "targets": [
> + {
> + "dsType": "influxdb",
> + "groupBy": [],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT \"hit\" FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND \"statut\" = 'all' AND $timeFilter",
> + "rawQuery": false,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "hit"
> + ],
> + "type": "field"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "statut",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": "",
> + "title": "Total Hits",
> + "type": "singlestat",
> + "valueFontSize": "80%",
> + "valueMaps": [
> + {
> + "op": "=",
> + "text": "0",
> + "value": "null"
> + }
> + ],
> + "valueName": "total"
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "id": 28,
> + "interval": "$granularity",
> + "legend": {
> + "avg": false,
> + "current": false,
> + "max": false,
> + "min": false,
> + "show": false,
> + "total": false,
> + "values": false
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 4,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "Errors",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "0"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT mean(\"countError\") / 5 FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity) fill(0)",
> + "rawQuery": false,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "countError"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "mean"
> + },
> + {
> + "params": [
> + " / 5"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Errors per Second",
> + "tooltip": {
> + "msResolution": false,
> + "shared": true,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": false,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": 0,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + }
> + ],
> + "showTitle": true,
> + "titleSize": "h6",
> + "height": "150px",
> + "repeat": null,
> + "repeatRowId": null,
> + "repeatIteration": null,
> + "collapse": false
> + },
> + {
> + "title": "Application Metrics",
> + "panels": [
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "height": "",
> + "id": 25,
> + "interval": "$granularity",
> + "legend": {
> + "alignAsTable": true,
> + "avg": true,
> + "current": true,
> + "hideEmpty": false,
> + "max": true,
> + "min": true,
> + "rightSide": false,
> + "show": true,
> + "total": false,
> + "values": true
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "minSpan": 12,
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 12,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "$tag_transaction",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "$granularity"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "transaction"
> + ],
> + "type": "tag"
> + }
> + ],
> + "hide": false,
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT mean(\"avg\") FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND $timeFilter GROUP BY time($granularity), \"transaction\"",
> + "rawQuery": false,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "avg"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "mean"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "statut",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Average Response Time",
> + "tooltip": {
> + "msResolution": false,
> + "shared": false,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "transparent": false,
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": true,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "ms",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "height": "",
> + "id": 26,
> + "interval": "$granularity",
> + "legend": {
> + "alignAsTable": true,
> + "avg": true,
> + "current": true,
> + "hideEmpty": false,
> + "max": true,
> + "min": true,
> + "rightSide": false,
> + "show": true,
> + "sort": "current",
> + "sortDesc": true,
> + "total": false,
> + "values": true
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "minSpan": 12,
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 12,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "$tag_transaction",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "30s"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "transaction"
> + ],
> + "type": "tag"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT mean(\"count\") / 5 FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND \"transaction\" <> 'all' AND $timeFilter GROUP BY time($granularity), \"transaction\"",
> + "rawQuery": false,
> + "refId": "A",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "count"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "sum"
> + },
> + {
> + "params": [
> + " / 30"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "transaction",
> + "operator": "<>",
> + "value": "all"
> + },
> + {
> + "condition": "AND",
> + "key": "statut",
> + "operator": "=",
> + "value": "all"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Transaction Per Second",
> + "tooltip": {
> + "msResolution": false,
> + "shared": false,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "transparent": false,
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": true,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "ops",
> + "label": "",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "height": "",
> + "id": 29,
> + "interval": "$granularity",
> + "legend": {
> + "alignAsTable": true,
> + "avg": true,
> + "current": true,
> + "hideEmpty": false,
> + "max": true,
> + "min": true,
> + "rightSide": false,
> + "show": true,
> + "total": false,
> + "values": true
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "minSpan": 12,
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 5,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 12,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "$tag_transaction",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "30s"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "transaction"
> + ],
> + "type": "tag"
> + },
> + {
> + "params": [
> + "null"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT last(\"count\") / 30 FROM \"$retention\".\"jmeter\" WHERE \"application\" =~ /$app$/ AND \"statut\" = 'ko' AND $timeFilter GROUP BY time(30s), \"transaction\" fill(null)",
> + "rawQuery": false,
> + "refId": "B",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "count"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "sum"
> + },
> + {
> + "params": [
> + " / 30"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "statut",
> + "operator": "=",
> + "value": "ko"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Error Per Second",
> + "tooltip": {
> + "msResolution": false,
> + "shared": false,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "transparent": false,
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": true,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "ops",
> + "label": "",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + },
> + {
> + "aliasColors": {},
> + "bars": false,
> + "datasource": "jmeterdb",
> + "editable": true,
> + "error": false,
> + "fill": 1,
> + "grid": {},
> + "height": "",
> + "id": 34,
> + "interval": "",
> + "legend": {
> + "alignAsTable": true,
> + "avg": true,
> + "current": true,
> + "hideEmpty": true,
> + "hideZero": true,
> + "max": true,
> + "min": true,
> + "rightSide": false,
> + "show": true,
> + "total": false,
> + "values": true
> + },
> + "lines": true,
> + "linewidth": 1,
> + "links": [],
> + "minSpan": 12,
> + "nullPointMode": "null",
> + "percentage": false,
> + "pointradius": 1,
> + "points": false,
> + "renderer": "flot",
> + "seriesOverrides": [],
> + "span": 12,
> + "stack": false,
> + "steppedLine": true,
> + "targets": [
> + {
> + "alias": "$tag_transaction - $tag_responseCode : $tag_responseMessage",
> + "dsType": "influxdb",
> + "groupBy": [
> + {
> + "params": [
> + "30s"
> + ],
> + "type": "time"
> + },
> + {
> + "params": [
> + "responseMessage"
> + ],
> + "type": "tag"
> + },
> + {
> + "params": [
> + "responseCode"
> + ],
> + "type": "tag"
> + },
> + {
> + "params": [
> + "transaction"
> + ],
> + "type": "tag"
> + },
> + {
> + "params": [
> + "null"
> + ],
> + "type": "fill"
> + }
> + ],
> + "measurement": "jmeter",
> + "policy": "$retention",
> + "query": "SELECT sum(\"count\") / 5 FROM \"jmeter\" WHERE \"application\" =~ /$app$/ AND \"statut\" = 'ko' AND $timeFilter GROUP BY time($granularity), \"responseCode\" fill(null)",
> + "rawQuery": false,
> + "refId": "B",
> + "resultFormat": "time_series",
> + "select": [
> + [
> + {
> + "params": [
> + "count"
> + ],
> + "type": "field"
> + },
> + {
> + "params": [],
> + "type": "sum"
> + },
> + {
> + "params": [
> + " / 30"
> + ],
> + "type": "math"
> + }
> + ]
> + ],
> + "tags": [
> + {
> + "key": "application",
> + "operator": "=~",
> + "value": "/$app$/"
> + },
> + {
> + "condition": "AND",
> + "key": "responseCode",
> + "operator": "!~",
> + "value": "/^0$|^$/"
> + },
> + {
> + "condition": "AND",
> + "key": "transaction",
> + "operator": "=~",
> + "value": "/$transaction/"
> + }
> + ]
> + }
> + ],
> + "thresholds": [],
> + "timeFrom": null,
> + "timeShift": null,
> + "title": "Error detail",
> + "tooltip": {
> + "msResolution": false,
> + "shared": true,
> + "sort": 0,
> + "value_type": "cumulative"
> + },
> + "transparent": false,
> + "type": "graph",
> + "xaxis": {
> + "mode": "time",
> + "name": null,
> + "show": true,
> + "values": []
> + },
> + "yaxes": [
> + {
> + "format": "none",
> + "label": "",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + },
> + {
> + "format": "short",
> + "logBase": 1,
> + "max": null,
> + "min": null,
> + "show": true
> + }
> + ]
> + }
> + ],
> + "showTitle": true,
> + "titleSize": "h6",
> + "height": "700px",
> + "repeat": null,
> + "repeatRowId": null,
> + "repeatIteration": null,
> + "collapse": false
> + }
> + ]
> +}
> \ No newline at end of file
>
> Propchange: jmeter/trunk/extras/GrafanaJMeterTemplate.json
> ------------------------------------------------------------------------------
> svn:eol-style = native
>
>