Hi, Yeah my bad, I modify it.
2017-06-26 16:05 GMT+02:00 sebb <seb...@gmail.com>: > On 8 June 2017 at 13:53, <mchassagn...@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 > > > > > >