{ "__inputs": [ { "name": "DS_INFLUXDB-RAILS", "label": "InfluxDB-Rails", "description": "", "type": "datasource", "pluginId": "influxdb", "pluginName": "InfluxDB" } ], "__requires": [ { "type": "panel", "id": "bargauge", "name": "Bar gauge", "version": "" }, { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "7.1.1" }, { "type": "datasource", "id": "influxdb", "name": "InfluxDB", "version": "1.0.0" }, { "type": "panel", "id": "stat", "name": "Stat", "version": "" }, { "type": "panel", "id": "table-old", "name": "Table (old)", "version": "" }, { "type": "panel", "id": "text", "name": "Text", "version": "7.1.0" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "type": "dashboard" } ] }, "description": "", "editable": true, "gnetId": 10429, "graphTooltip": 0, "id": null, "iteration": 1616428738654, "links": [ { "$$hashKey": "object:392", "icon": "external link", "tags": [ "influxdb-rails" ], "type": "dashboards" } ], "panels": [ { "content": "## Details for $method ($request_id)", "datasource": "InfluxDB", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "gridPos": { "h": 2, "w": 24, "x": 0, "y": 0 }, "id": 4, "links": [], "mode": "markdown", "options": { "content": "## Details for $method ($request_id)", "mode": "markdown" }, "pluginVersion": "7.1.0", "title": "", "type": "text" }, { "cacheTimeout": null, "datasource": "InfluxDB", "description": "", "fieldConfig": { "defaults": { "custom": {}, "mappings": [ { "id": 0, "op": "=", "text": "N/A", "type": 1, "value": "null" } ], "nullValueMode": "connected", "thresholds": { "mode": "absolute", "steps": [ { "color": "#299c46", "value": null }, { "color": "rgba(237, 129, 40, 0.89)", "value": 200 }, { "color": "#d44a3a", "value": 300 } ] }, "unit": "ms" }, "overrides": [] }, "gridPos": { "h": 3, "w": 8, "x": 0, "y": 2 }, "id": 2, "interval": null, "links": [], "maxDataPoints": 100, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "sum" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "7.1.1", "targets": [ { "groupBy": [], "measurement": "rails", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "controller" ], "type": "field" } ] ], "tags": [ { "key": "request_id", "operator": "=~", "value": "/^$request_id$/" }, { "condition": "AND", "key": "hook", "operator": "=", "value": "process_action" } ] } ], "title": "Total Controller Action Runtime", "type": "stat" }, { "cacheTimeout": null, "datasource": "InfluxDB", "fieldConfig": { "defaults": { "custom": {}, "mappings": [ { "id": 0, "op": "=", "text": "N/A", "type": 1, "value": "null" } ], "nullValueMode": "connected", "thresholds": { "mode": "absolute", "steps": [ { "color": "#299c46", "value": null }, { "color": "rgba(237, 129, 40, 0.89)", "value": 200 }, { "color": "#d44a3a", "value": 300 } ] }, "unit": "ms" }, "overrides": [] }, "gridPos": { "h": 3, "w": 8, "x": 8, "y": 2 }, "id": 6, "interval": null, "links": [], "maxDataPoints": 100, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "7.1.1", "targets": [ { "groupBy": [], "measurement": "rails", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "db" ], "type": "field" } ] ], "tags": [ { "key": "request_id", "operator": "=~", "value": "/^$request_id$/" }, { "condition": "AND", "key": "hook", "operator": "=", "value": "process_action" } ] } ], "title": "Total Database Query Runtime", "type": "stat" }, { "cacheTimeout": null, "datasource": "InfluxDB", "fieldConfig": { "defaults": { "custom": {}, "mappings": [ { "id": 0, "op": "=", "text": "0", "type": 1, "value": "null" } ], "nullValueMode": "connected", "thresholds": { "mode": "absolute", "steps": [ { "color": "#299c46", "value": null }, { "color": "rgba(237, 129, 40, 0.89)", "value": 200 }, { "color": "#d44a3a", "value": 300 } ] }, "unit": "ms" }, "overrides": [] }, "gridPos": { "h": 3, "w": 8, "x": 16, "y": 2 }, "id": 8, "interval": null, "links": [], "maxDataPoints": 100, "options": { "colorMode": "value", "graphMode": "none", "justifyMode": "auto", "orientation": "horizontal", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": false }, "textMode": "auto" }, "pluginVersion": "7.1.1", "targets": [ { "groupBy": [], "measurement": "rails", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "value" ], "type": "field" } ] ], "tags": [ { "key": "request_id", "operator": "=~", "value": "/^$request_id$/" }, { "condition": "AND", "key": "hook", "operator": "=", "value": "render_template" } ] } ], "title": "Total View Rendering Runtime", "type": "stat" }, { "columns": [], "datasource": "InfluxDB", "description": "Database queries in this request.\n\n- Count: Number of occurrences\n- Mean: Average time spent in this query\n- Maximum: Slowest occurrence\n- Total: Total amount of time spent in this query", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fontSize": "100%", "gridPos": { "h": 7, "w": 12, "x": 0, "y": 5 }, "id": 12, "links": [], "pageSize": null, "scroll": true, "showHeader": true, "sort": { "col": 5, "desc": true }, "styles": [ { "$$hashKey": "object:554", "alias": "Time", "align": "auto", "dateFormat": "YYYY-MM-DD HH:mm:ss", "pattern": "Time", "type": "hidden" }, { "$$hashKey": "object:555", "alias": "Count", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "count", "thresholds": [], "type": "number", "unit": "short" }, { "$$hashKey": "object:556", "alias": "Query", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "name", "preserveFormat": false, "sanitize": false, "thresholds": [], "type": "string", "unit": "short", "valueMaps": [ { "$$hashKey": "object:823", "text": "Unkown", "value": "" } ] }, { "$$hashKey": "object:557", "alias": "Mean", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "mean", "thresholds": [], "type": "number", "unit": "ms" }, { "$$hashKey": "object:558", "alias": "Maximum", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "max", "thresholds": [], "type": "number", "unit": "ms" }, { "$$hashKey": "object:559", "alias": "Total", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "sum", "thresholds": [], "type": "number", "unit": "ms" }, { "$$hashKey": "object:560", "alias": "", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "decimals": 2, "pattern": "/.*/", "thresholds": [], "type": "number", "unit": "ms" } ], "targets": [ { "groupBy": [ { "params": [ "name" ], "type": "tag" } ], "measurement": "rails", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "count" } ], [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ], [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "max" } ], [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [ { "key": "request_id", "operator": "=~", "value": "/^$request_id$/" }, { "condition": "AND", "key": "hook", "operator": "=", "value": "sql" } ] } ], "title": "Database Queries", "transform": "table", "type": "table-old" }, { "cacheTimeout": null, "datasource": "InfluxDB", "description": "", "fieldConfig": { "defaults": { "custom": {}, "mappings": [], "thresholds": { "mode": "absolute", "steps": [ { "color": "green", "value": null }, { "color": "yellow", "value": 100 }, { "color": "red", "value": 200 } ] }, "unit": "short" }, "overrides": [] }, "gridPos": { "h": 7, "w": 12, "x": 12, "y": 5 }, "id": 17, "interval": null, "links": [], "maxDataPoints": 3, "options": { "displayMode": "lcd", "orientation": "horizontal", "reduceOptions": { "calcs": [ "mean" ], "fields": "", "values": true }, "showUnfilled": true }, "pluginVersion": "7.1.1", "targets": [ { "alias": "$tag_class_name", "groupBy": [ { "params": [ "class_name" ], "type": "tag" } ], "measurement": "rails", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "time_series", "select": [ [ { "params": [ "record_count" ], "type": "field" }, { "params": [], "type": "count" } ] ], "tags": [ { "key": "request_id", "operator": "=~", "value": "/^$request_id$/" }, { "condition": "AND", "key": "hook", "operator": "=", "value": "instantiation" } ] } ], "title": "Record Instantiation", "type": "bargauge" }, { "columns": [], "datasource": "InfluxDB", "description": "Views rendered in this request.\n\n- Count: Number of occurrences\n- Mean: Average time spent in this query\n- Maximum: Slowest occurrence", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fontSize": "100%", "gridPos": { "h": 9, "w": 12, "x": 0, "y": 12 }, "id": 10, "links": [], "pageSize": null, "scroll": true, "showHeader": true, "sort": { "col": 4, "desc": true }, "styles": [ { "alias": "Time", "align": "auto", "dateFormat": "YYYY-MM-DD HH:mm:ss", "pattern": "Time", "type": "hidden" }, { "alias": "Count", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": null, "mappingType": 1, "pattern": "count", "thresholds": [], "type": "number", "unit": "short" }, { "alias": "Mean", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "mean", "thresholds": [], "type": "number", "unit": "ms" }, { "alias": "Maximum", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "max", "thresholds": [], "type": "number", "unit": "ms" }, { "alias": "File", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "decimals": 2, "pattern": "filename", "thresholds": [], "type": "number", "unit": "ms" } ], "targets": [ { "groupBy": [ { "params": [ "filename" ], "type": "tag" } ], "measurement": "rails", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "count" } ], [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ], [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "max" } ] ], "tags": [ { "key": "request_id", "operator": "=~", "value": "/^$request_id$/" }, { "condition": "AND", "key": "hook", "operator": "=", "value": "render_template" } ] } ], "title": "Views Rendered", "transform": "table", "type": "table-old" }, { "columns": [], "datasource": "InfluxDB", "description": "Partials rendered in this request.\n\n- Count: Number of occurrences\n- Mean: Average time spent in this partial\n- Maximum: Slowest occurrence\n- Total: Total time spent in this partial", "fieldConfig": { "defaults": { "custom": {} }, "overrides": [] }, "fontSize": "100%", "gridPos": { "h": 9, "w": 12, "x": 12, "y": 12 }, "id": 16, "links": [], "pageSize": null, "scroll": true, "showHeader": true, "sort": { "col": 5, "desc": true }, "styles": [ { "alias": "Time", "align": "auto", "dateFormat": "YYYY-MM-DD HH:mm:ss", "pattern": "Time", "type": "hidden" }, { "alias": "Count", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 0, "mappingType": 1, "pattern": "count", "thresholds": [], "type": "number", "unit": "short" }, { "alias": "File", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "filename", "thresholds": [], "type": "string", "unit": "short" }, { "alias": "Mean", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "mean", "thresholds": [], "type": "number", "unit": "ms" }, { "alias": "Maximum", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "max", "thresholds": [], "type": "number", "unit": "ms" }, { "alias": "Total", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "sum", "thresholds": [], "type": "number", "unit": "ms" }, { "alias": "", "align": "auto", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "decimals": 2, "pattern": "/.*/", "thresholds": [], "type": "number", "unit": "ms" } ], "targets": [ { "groupBy": [ { "params": [ "filename" ], "type": "tag" } ], "measurement": "rails", "orderByTime": "ASC", "policy": "default", "refId": "A", "resultFormat": "table", "select": [ [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "count" } ], [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "mean" } ], [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "max" } ], [ { "params": [ "value" ], "type": "field" }, { "params": [], "type": "sum" } ] ], "tags": [ { "key": "request_id", "operator": "=~", "value": "/^$request_id$/" }, { "condition": "AND", "key": "hook", "operator": "=", "value": "render_partial" } ] } ], "title": "Partials Rendered", "transform": "table", "type": "table-old" } ], "refresh": false, "schemaVersion": 26, "style": "dark", "tags": [ "Performance", "Ruby on Rails" ], "templating": { "list": [ { "current": { "text": "", "value": "" }, "hide": 2, "label": null, "name": "request_id", "options": [ { "selected": false, "text": "", "value": "" } ], "query": "ba3c5e76-d15a-40fb-bb0c-a6dc0220fa8c", "skipUrlSync": false, "type": "textbox" }, { "current": { "text": "", "value": "" }, "hide": 2, "label": null, "name": "method", "options": [ { "selected": false, "text": "", "value": "" } ], "query": "Webui::PackageController#meta", "skipUrlSync": false, "type": "textbox" } ] }, "time": { "from": "now-6h", "to": "now" }, "timepicker": { "hidden": true, "refresh_intervals": [ "" ], "time_options": [ "5m", "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "timezone": "", "title": "Performance (per Request)", "uid": "influxdb-rails-request", "version": 9 }