Last active
December 20, 2017 15:03
-
-
Save dmfenton/944e6bad9c8cf721cd684495165c2636 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "__inputs": [ | |
| { | |
| "name": "DS_NGINX-ACCESS-LOG", | |
| "label": "nginx-access-log", | |
| "description": "", | |
| "type": "datasource", | |
| "pluginId": "elasticsearch", | |
| "pluginName": "Elasticsearch" | |
| } | |
| ], | |
| "__requires": [ | |
| { | |
| "type": "datasource", | |
| "id": "elasticsearch", | |
| "name": "Elasticsearch", | |
| "version": "3.0.0" | |
| }, | |
| { | |
| "type": "grafana", | |
| "id": "grafana", | |
| "name": "Grafana", | |
| "version": "4.4.1" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "grafana-piechart-panel", | |
| "name": "Pie Chart", | |
| "version": "1.1.5" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "grafana-worldmap-panel", | |
| "name": "Worldmap Panel", | |
| "version": "0.0.17" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "graph", | |
| "name": "Graph", | |
| "version": "" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "singlestat", | |
| "name": "Singlestat", | |
| "version": "" | |
| }, | |
| { | |
| "type": "panel", | |
| "id": "table", | |
| "name": "Table", | |
| "version": "" | |
| } | |
| ], | |
| "annotations": { | |
| "list": [] | |
| }, | |
| "description": "Browse, analyze logs in Elasticsearchstatus_codes, pie-chart, top 10 clientip, line-chart,word-map and etc...", | |
| "editable": true, | |
| "gnetId": 2292, | |
| "graphTooltip": 0, | |
| "hideControls": false, | |
| "id": null, | |
| "links": [ | |
| { | |
| "icon": "external link", | |
| "tags": [], | |
| "targetBlank": true, | |
| "title": "Kibana", | |
| "type": "link", | |
| "url": "https://127.0.0.1:5601" | |
| } | |
| ], | |
| "refresh": "30s", | |
| "rows": [ | |
| { | |
| "collapse": false, | |
| "height": 412, | |
| "panels": [ | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": true, | |
| "colorValue": false, | |
| "colors": ["rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)"], | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "format": "none", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "id": 17, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "80%", | |
| "prefix": "", | |
| "prefixFontSize": "200%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "span": 2, | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": true, | |
| "lineColor": "rgb(0, 4, 244)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "$inter", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "ip.keyword", | |
| "id": "1", | |
| "meta": {}, | |
| "settings": {}, | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "thresholds": "300000,500000", | |
| "title": "The total number of requests", | |
| "type": "singlestat", | |
| "valueFontSize": "100%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "total" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": true, | |
| "colorValue": false, | |
| "colors": ["rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)"], | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "format": "none", | |
| "gauge": { | |
| "maxValue": 100, | |
| "minValue": 0, | |
| "show": false, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "id": 1, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "", | |
| "postfixFontSize": "80%", | |
| "prefix": "", | |
| "prefixFontSize": "200%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "span": 2, | |
| "sparkline": { | |
| "fillColor": "rgba(31, 118, 189, 0.18)", | |
| "full": true, | |
| "lineColor": "rgb(0, 14, 245)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "alias": "", | |
| "bucketAggs": [ | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "$inter", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "ip.keyword", | |
| "id": "1", | |
| "meta": {}, | |
| "settings": {}, | |
| "type": "cardinality" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "thresholds": "10000,100000", | |
| "title": "IP", | |
| "type": "singlestat", | |
| "valueFontSize": "100%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "total" | |
| }, | |
| { | |
| "cacheTimeout": null, | |
| "colorBackground": true, | |
| "colorValue": false, | |
| "colors": ["rgba(50, 172, 45, 0.97)", "rgba(237, 129, 40, 0.89)", "rgba(245, 54, 54, 0.9)"], | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "format": "none", | |
| "gauge": { | |
| "maxValue": 1, | |
| "minValue": 0, | |
| "show": true, | |
| "thresholdLabels": false, | |
| "thresholdMarkers": true | |
| }, | |
| "id": 24, | |
| "interval": null, | |
| "links": [], | |
| "mappingType": 1, | |
| "mappingTypes": [ | |
| { | |
| "name": "value to text", | |
| "value": 1 | |
| }, | |
| { | |
| "name": "range to text", | |
| "value": 2 | |
| } | |
| ], | |
| "maxDataPoints": 100, | |
| "minSpan": 3, | |
| "nullPointMode": "connected", | |
| "nullText": null, | |
| "postfix": "s", | |
| "postfixFontSize": "50%", | |
| "prefix": "", | |
| "prefixFontSize": "50%", | |
| "rangeMaps": [ | |
| { | |
| "from": "null", | |
| "text": "N/A", | |
| "to": "null" | |
| } | |
| ], | |
| "span": 2, | |
| "sparkline": { | |
| "fillColor": "rgba(240, 246, 239, 0.18)", | |
| "full": true, | |
| "lineColor": "rgb(31, 120, 193)", | |
| "show": true | |
| }, | |
| "tableColumn": "", | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "groupBy": [ | |
| { | |
| "params": ["$__interval"], | |
| "type": "time" | |
| }, | |
| { | |
| "params": ["null"], | |
| "type": "fill" | |
| } | |
| ], | |
| "metrics": [ | |
| { | |
| "field": "responsetime", | |
| "id": "1", | |
| "meta": {}, | |
| "settings": {}, | |
| "type": "avg" | |
| } | |
| ], | |
| "orderByTime": "ASC", | |
| "policy": "default", | |
| "query": | |
| " AND upstreamaddr:\"unix:/usr/local/php/var/run/php-fpm.sock\" and user_agent!='MSIE' and user_agent!='Zabbix'", | |
| "refId": "A", | |
| "resultFormat": "time_series", | |
| "select": [ | |
| [ | |
| { | |
| "params": ["value"], | |
| "type": "field" | |
| }, | |
| { | |
| "params": [], | |
| "type": "mean" | |
| } | |
| ] | |
| ], | |
| "tags": [], | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "thresholds": "0.5,0.8", | |
| "title": "$domain Average response time", | |
| "type": "singlestat", | |
| "valueFontSize": "50%", | |
| "valueMaps": [ | |
| { | |
| "op": "=", | |
| "text": "N/A", | |
| "value": "null" | |
| } | |
| ], | |
| "valueName": "avg" | |
| }, | |
| { | |
| "aliasColors": { | |
| "500": "#BF1B00" | |
| }, | |
| "cacheTimeout": null, | |
| "combine": { | |
| "label": "Others", | |
| "threshold": 0 | |
| }, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "fontSize": "80%", | |
| "format": "short", | |
| "id": 3, | |
| "interval": null, | |
| "legend": { | |
| "percentage": true, | |
| "show": true, | |
| "sortDesc": true, | |
| "values": true | |
| }, | |
| "legendType": "Right side", | |
| "links": [], | |
| "maxDataPoints": 3, | |
| "minSpan": 6, | |
| "nullPointMode": "connected", | |
| "pieType": "pie", | |
| "span": 3, | |
| "strokeWidth": 1, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "status", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "0" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain HTTP status code", | |
| "type": "grafana-piechart-panel", | |
| "valueName": "total" | |
| }, | |
| { | |
| "aliasColors": { | |
| "500": "#BF1B00" | |
| }, | |
| "cacheTimeout": null, | |
| "combine": { | |
| "label": "Others", | |
| "threshold": 0 | |
| }, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "fontSize": "80%", | |
| "format": "short", | |
| "id": 11, | |
| "interval": null, | |
| "legend": { | |
| "percentage": true, | |
| "show": true, | |
| "values": true | |
| }, | |
| "legendType": "Right side", | |
| "links": [], | |
| "maxDataPoints": 3, | |
| "minSpan": 6, | |
| "nullPointMode": "connected", | |
| "pieType": "pie", | |
| "span": 3, | |
| "strokeWidth": 1, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "ip.keyword", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "10" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain IP TOP 10", | |
| "type": "grafana-piechart-panel", | |
| "valueName": "total" | |
| }, | |
| { | |
| "aliasColors": { | |
| "500": "#BF1B00" | |
| }, | |
| "cacheTimeout": null, | |
| "combine": { | |
| "label": "Others", | |
| "threshold": 0 | |
| }, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "fontSize": "80%", | |
| "format": "short", | |
| "id": 30, | |
| "interval": null, | |
| "legend": { | |
| "percentage": true, | |
| "show": true, | |
| "values": true | |
| }, | |
| "legendType": "Right side", | |
| "links": [], | |
| "maxDataPoints": 3, | |
| "minSpan": 3, | |
| "nullPointMode": "connected", | |
| "pieType": "pie", | |
| "span": 3, | |
| "strokeWidth": 1, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "geoip.city_name.keyword", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "10" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain Top 10 cities", | |
| "type": "grafana-piechart-panel", | |
| "valueName": "total" | |
| }, | |
| { | |
| "aliasColors": { | |
| "500": "#BF1B00" | |
| }, | |
| "cacheTimeout": null, | |
| "combine": { | |
| "label": "Others", | |
| "threshold": 0 | |
| }, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "fontSize": "80%", | |
| "format": "short", | |
| "id": 31, | |
| "interval": null, | |
| "legend": { | |
| "percentage": true, | |
| "show": true, | |
| "values": true | |
| }, | |
| "legendType": "Right side", | |
| "links": [], | |
| "maxDataPoints": 3, | |
| "minSpan": 3, | |
| "nullPointMode": "connected", | |
| "pieType": "pie", | |
| "span": 3, | |
| "strokeWidth": 1, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "geoip.region_name.keyword", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "10" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain Top 10 provinces", | |
| "type": "grafana-piechart-panel", | |
| "valueName": "total" | |
| }, | |
| { | |
| "aliasColors": { | |
| "500": "#BF1B00" | |
| }, | |
| "cacheTimeout": null, | |
| "combine": { | |
| "label": "Others", | |
| "threshold": 0 | |
| }, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "fontSize": "80%", | |
| "format": "short", | |
| "id": 32, | |
| "interval": null, | |
| "legend": { | |
| "percentage": true, | |
| "show": true, | |
| "values": true | |
| }, | |
| "legendType": "Right side", | |
| "links": [], | |
| "maxDataPoints": 3, | |
| "minSpan": 3, | |
| "nullPointMode": "connected", | |
| "pieType": "pie", | |
| "span": 3, | |
| "strokeWidth": 1, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "geoip.country_name.keyword", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "10" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain Percentage of visits by country", | |
| "type": "grafana-piechart-panel", | |
| "valueName": "total" | |
| }, | |
| { | |
| "aliasColors": { | |
| "500": "#BF1B00" | |
| }, | |
| "cacheTimeout": null, | |
| "combine": { | |
| "label": "Others", | |
| "threshold": 0 | |
| }, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "fontSize": "80%", | |
| "format": "short", | |
| "id": 14, | |
| "interval": null, | |
| "legend": { | |
| "percentage": true, | |
| "show": true, | |
| "values": true | |
| }, | |
| "legendType": "Right side", | |
| "links": [], | |
| "maxDataPoints": 3, | |
| "minSpan": 3, | |
| "nullPointMode": "connected", | |
| "pieType": "pie", | |
| "span": 3, | |
| "strokeWidth": 1, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "request_method.keyword", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "10" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain Request methods", | |
| "type": "grafana-piechart-panel", | |
| "valueName": "total" | |
| }, | |
| { | |
| "circleMaxSize": "30", | |
| "circleMinSize": "3", | |
| "colors": ["rgba(0, 247, 0, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(240, 4, 45, 0.97)"], | |
| "decimals": 0, | |
| "esGeoPoint": "geoip.location", | |
| "esLocationName": "", | |
| "esMetric": "Count", | |
| "height": "600px", | |
| "hideEmpty": false, | |
| "hideZero": true, | |
| "id": 35, | |
| "initialZoom": 1, | |
| "links": [], | |
| "locationData": "geohash", | |
| "mapCenter": "custom", | |
| "mapCenterLatitude": "30", | |
| "mapCenterLongitude": "120", | |
| "maxDataPoints": 1, | |
| "showLegend": true, | |
| "span": 12, | |
| "stickyLabels": false, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "geoip.location", | |
| "id": "3", | |
| "settings": { | |
| "precision": 3 | |
| }, | |
| "type": "geohash_grid" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "thresholds": "1000,10000", | |
| "title": "$domain Word Map", | |
| "transparent": true, | |
| "type": "grafana-worldmap-panel", | |
| "unitPlural": "", | |
| "unitSingle": "", | |
| "valueName": "total" | |
| }, | |
| { | |
| "aliasColors": { | |
| "500": "#BF1B00" | |
| }, | |
| "cacheTimeout": null, | |
| "combine": { | |
| "label": "Others", | |
| "threshold": 0 | |
| }, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "fontSize": "80%", | |
| "format": "short", | |
| "id": 12, | |
| "interval": null, | |
| "legend": { | |
| "percentage": true, | |
| "show": true, | |
| "values": true | |
| }, | |
| "legendType": "Right side", | |
| "links": [], | |
| "maxDataPoints": 3, | |
| "minSpan": 12, | |
| "nullPointMode": "connected", | |
| "pieType": "pie", | |
| "span": 12, | |
| "strokeWidth": 1, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "request.keyword", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "10" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain request top 10", | |
| "type": "grafana-piechart-panel", | |
| "valueName": "total" | |
| }, | |
| { | |
| "aliasColors": { | |
| "500": "#BF1B00" | |
| }, | |
| "cacheTimeout": null, | |
| "combine": { | |
| "label": "Others", | |
| "threshold": 0 | |
| }, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "fontSize": "80%", | |
| "format": "short", | |
| "height": "300px", | |
| "id": 13, | |
| "interval": null, | |
| "legend": { | |
| "percentage": true, | |
| "show": true, | |
| "values": true | |
| }, | |
| "legendType": "Right side", | |
| "links": [], | |
| "maxDataPoints": 3, | |
| "minSpan": 12, | |
| "nullPointMode": "connected", | |
| "pieType": "pie", | |
| "span": 12, | |
| "strokeWidth": 1, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "referer.keyword", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "10" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain referer top 10", | |
| "transparent": true, | |
| "type": "grafana-piechart-panel", | |
| "valueName": "total" | |
| }, | |
| { | |
| "aliasColors": { | |
| "500": "#BF1B00" | |
| }, | |
| "cacheTimeout": null, | |
| "combine": { | |
| "label": "Others", | |
| "threshold": 0 | |
| }, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "editable": true, | |
| "error": false, | |
| "fontSize": "80%", | |
| "format": "short", | |
| "id": 16, | |
| "interval": null, | |
| "legend": { | |
| "percentage": true, | |
| "show": true, | |
| "values": true | |
| }, | |
| "legendType": "Right side", | |
| "links": [], | |
| "maxDataPoints": 3, | |
| "minSpan": 12, | |
| "nullPointMode": "connected", | |
| "pieType": "pie", | |
| "span": 12, | |
| "strokeWidth": 1, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "http_user_agent.keyword", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "10" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "auto", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain user_agent top 10", | |
| "type": "grafana-piechart-panel", | |
| "valueName": "total" | |
| } | |
| ], | |
| "repeat": null, | |
| "repeatIteration": null, | |
| "repeatRowId": null, | |
| "showTitle": true, | |
| "title": "Summary", | |
| "titleSize": "h6" | |
| }, | |
| { | |
| "collapse": false, | |
| "height": 360, | |
| "panels": [ | |
| { | |
| "aliasColors": {}, | |
| "bars": true, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "decimals": 0, | |
| "editable": true, | |
| "error": false, | |
| "fill": 0, | |
| "grid": {}, | |
| "id": 2, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "total": true, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "span": 12, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "$inter", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "$domain Requests", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "none", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "none", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": { | |
| "404": "#3F2B5B", | |
| "499": "#890F02", | |
| "500": "#BF1B00" | |
| }, | |
| "bars": true, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "decimals": 0, | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": {}, | |
| "id": 7, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "max": true, | |
| "min": true, | |
| "rightSide": true, | |
| "show": true, | |
| "total": true, | |
| "values": true | |
| }, | |
| "lines": true, | |
| "linewidth": 2, | |
| "links": [], | |
| "minSpan": 12, | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "span": 12, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "bucketAggs": [ | |
| { | |
| "fake": true, | |
| "field": "status", | |
| "id": "3", | |
| "settings": { | |
| "min_doc_count": 1, | |
| "order": "desc", | |
| "orderBy": "_count", | |
| "size": "10" | |
| }, | |
| "type": "terms" | |
| }, | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "$inter", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": "", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "$domain HTTP status code", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "none", | |
| "label": "status code number", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "none", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| }, | |
| { | |
| "aliasColors": { | |
| "404": "#3F2B5B", | |
| "499": "#890F02", | |
| "500": "#BF1B00" | |
| }, | |
| "bars": true, | |
| "dashLength": 10, | |
| "dashes": false, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "decimals": 0, | |
| "editable": true, | |
| "error": false, | |
| "fill": 1, | |
| "grid": {}, | |
| "id": 21, | |
| "legend": { | |
| "alignAsTable": true, | |
| "avg": true, | |
| "current": true, | |
| "max": true, | |
| "min": true, | |
| "rightSide": false, | |
| "show": true, | |
| "total": true, | |
| "values": true | |
| }, | |
| "lines": false, | |
| "linewidth": 2, | |
| "links": [], | |
| "minSpan": 12, | |
| "nullPointMode": "connected", | |
| "percentage": false, | |
| "pointradius": 5, | |
| "points": false, | |
| "renderer": "flot", | |
| "seriesOverrides": [], | |
| "spaceLength": 10, | |
| "span": 12, | |
| "stack": false, | |
| "steppedLine": false, | |
| "targets": [ | |
| { | |
| "alias": "", | |
| "bucketAggs": [ | |
| { | |
| "field": "@timestamp", | |
| "id": "2", | |
| "settings": { | |
| "interval": "$inter", | |
| "min_doc_count": 0, | |
| "trimEdges": 0 | |
| }, | |
| "type": "date_histogram" | |
| } | |
| ], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "type": "count" | |
| } | |
| ], | |
| "query": " AND responsetime:[$responsetime TO 100] and user_agent!='MSIE' and user_agent!='Zabbix'", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "thresholds": [], | |
| "timeFrom": null, | |
| "timeShift": null, | |
| "title": "$domain Slow response time>$responsetime s", | |
| "tooltip": { | |
| "msResolution": true, | |
| "shared": true, | |
| "sort": 0, | |
| "value_type": "cumulative" | |
| }, | |
| "type": "graph", | |
| "xaxis": { | |
| "buckets": null, | |
| "mode": "time", | |
| "name": null, | |
| "show": true, | |
| "values": [] | |
| }, | |
| "yaxes": [ | |
| { | |
| "format": "none", | |
| "label": "", | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| }, | |
| { | |
| "format": "none", | |
| "label": null, | |
| "logBase": 1, | |
| "max": null, | |
| "min": null, | |
| "show": true | |
| } | |
| ] | |
| } | |
| ], | |
| "repeat": null, | |
| "repeatIteration": null, | |
| "repeatRowId": null, | |
| "showTitle": true, | |
| "title": "Historical trend", | |
| "titleSize": "h6" | |
| }, | |
| { | |
| "collapse": false, | |
| "height": 250, | |
| "panels": [ | |
| { | |
| "columns": [ | |
| { | |
| "text": "@timestamp", | |
| "value": "@timestamp" | |
| }, | |
| { | |
| "text": "ip", | |
| "value": "ip" | |
| }, | |
| { | |
| "text": "geoip.city_name", | |
| "value": "geoip.city_name" | |
| }, | |
| { | |
| "text": "http_user_agent", | |
| "value": "http_user_agent" | |
| }, | |
| { | |
| "text": "request_method", | |
| "value": "request_method" | |
| }, | |
| { | |
| "text": "request", | |
| "value": "request" | |
| }, | |
| { | |
| "text": "status", | |
| "value": "status" | |
| }, | |
| { | |
| "text": "responsetime", | |
| "value": "responsetime" | |
| } | |
| ], | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "fontSize": "100%", | |
| "height": "500", | |
| "id": 33, | |
| "links": [], | |
| "pageSize": null, | |
| "scroll": true, | |
| "showHeader": true, | |
| "sort": { | |
| "col": 0, | |
| "desc": true | |
| }, | |
| "span": 12, | |
| "styles": [ | |
| { | |
| "alias": "Time", | |
| "dateFormat": "YYYY-MM-DD HH:mm:ss", | |
| "pattern": "/@time.*/", | |
| "type": "date" | |
| }, | |
| { | |
| "alias": "", | |
| "colorMode": null, | |
| "colors": ["rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)"], | |
| "decimals": 2, | |
| "pattern": "/.*/", | |
| "thresholds": [], | |
| "type": "number", | |
| "unit": "short" | |
| } | |
| ], | |
| "targets": [ | |
| { | |
| "bucketAggs": [], | |
| "dsType": "elasticsearch", | |
| "metrics": [ | |
| { | |
| "field": "select field", | |
| "id": "1", | |
| "meta": {}, | |
| "settings": { | |
| "size": 500 | |
| }, | |
| "type": "raw_document" | |
| } | |
| ], | |
| "query": " and status:$status and user_agent!=MSIE", | |
| "refId": "A", | |
| "timeField": "@timestamp" | |
| } | |
| ], | |
| "title": "$domain status:$status", | |
| "transform": "json", | |
| "transparent": true, | |
| "type": "table" | |
| } | |
| ], | |
| "repeat": null, | |
| "repeatIteration": null, | |
| "repeatRowId": null, | |
| "showTitle": false, | |
| "title": "Dashboard Row", | |
| "titleSize": "h6" | |
| } | |
| ], | |
| "schemaVersion": 14, | |
| "style": "dark", | |
| "tags": ["nginx", "es", "logstash", "log"], | |
| "templating": { | |
| "list": [ | |
| { | |
| "allValue": null, | |
| "current": {}, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "domain name", | |
| "multi": false, | |
| "name": "domain", | |
| "options": [], | |
| "query": "{\"find\":\"terms\",\"field\":\"domain.keyword\"}", | |
| "refresh": 1, | |
| "regex": "", | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": {}, | |
| "datasource": "${DS_NGINX-ACCESS-LOG}", | |
| "hide": 0, | |
| "includeAll": true, | |
| "label": "status code", | |
| "multi": true, | |
| "name": "status", | |
| "options": [], | |
| "query": "{\"find\":\"terms\",\"field\":\"status\"}", | |
| "refresh": 1, | |
| "regex": "", | |
| "sort": 0, | |
| "tagValuesQuery": "", | |
| "tags": [], | |
| "tagsQuery": "", | |
| "type": "query", | |
| "useTags": false | |
| }, | |
| { | |
| "allValue": null, | |
| "current": { | |
| "tags": [], | |
| "text": "2", | |
| "value": "2" | |
| }, | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "response time", | |
| "multi": false, | |
| "name": "responsetime", | |
| "options": [ | |
| { | |
| "selected": false, | |
| "text": "1", | |
| "value": "1" | |
| }, | |
| { | |
| "selected": true, | |
| "text": "2", | |
| "value": "2" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "3", | |
| "value": "3" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "4", | |
| "value": "4" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5", | |
| "value": "5" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "10", | |
| "value": "10" | |
| } | |
| ], | |
| "query": "1,2,3,4,5,10", | |
| "type": "custom" | |
| }, | |
| { | |
| "auto": true, | |
| "auto_count": 100, | |
| "auto_min": "10s", | |
| "current": { | |
| "text": "auto", | |
| "value": "$__auto_interval" | |
| }, | |
| "datasource": null, | |
| "hide": 0, | |
| "includeAll": false, | |
| "label": "cycle", | |
| "multi": false, | |
| "name": "inter", | |
| "options": [ | |
| { | |
| "selected": true, | |
| "text": "auto", | |
| "value": "$__auto_interval" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1s", | |
| "value": "1s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "5s", | |
| "value": "5s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "10s", | |
| "value": "10s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "30s", | |
| "value": "30s" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1m", | |
| "value": "1m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "10m", | |
| "value": "10m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "30m", | |
| "value": "30m" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1h", | |
| "value": "1h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "6h", | |
| "value": "6h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "12h", | |
| "value": "12h" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "1d", | |
| "value": "1d" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "7d", | |
| "value": "7d" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "14d", | |
| "value": "14d" | |
| }, | |
| { | |
| "selected": false, | |
| "text": "30d", | |
| "value": "30d" | |
| } | |
| ], | |
| "query": "1s,5s,10s,30s,1m,10m,30m,1h,6h,12h,1d,7d,14d,30d", | |
| "refresh": 2, | |
| "type": "interval" | |
| } | |
| ] | |
| }, | |
| "time": { | |
| "from": "now/d", | |
| "to": "now/d" | |
| }, | |
| "timepicker": { | |
| "refresh_intervals": ["5s", "10s", "30s", "1m", "5m", "15m", "30m", "1h", "2h", "1d"], | |
| "time_options": ["5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d"] | |
| }, | |
| "timezone": "browser", | |
| "title": "# Elasticserch Nginx Logs", | |
| "version": 2 | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment