New 4
AI-enhanced title
"__inputs": [ { "name": "DS_FLUX", "label": "Flux", "description": "", "type": "datasource", "pluginId": "grafana-influxdb-flux-datasource", "pluginName": "InfluxDB" } ], "__requires": [ { "type": "grafana", "id": "grafana", "name": "Grafana", "version": "6.2.5" }, { "type": "datasource", "id": "grafana-influxdb-flux-datasource", "name": "InfluxDB", "version": "5.2.11" }, { "type": "panel", "id": "table", "name": "Table", "version": "" } ], "annotations": { "list": [ { "builtIn": 1, "datasource": "-- Grafana --", "enable": true, "hide": true, "iconColor": "rgba(0, 211, 255, 1)", "name": "Annotations & Alerts", "type": "dashboard" } ] }, "editable": true, "gnetId": null, "graphTooltip": 0, "id": null, "iteration": 1573110763053, "links": [], "panels": [ { "cacheTimeout": null, "columns": [], "description": "", "fontSize": "100%", "gridPos": { "h": 3, "w": 24, "x": 0, "y": 0 }, "id": 163, "links": [], "options": {}, "pageSize": null, "pluginVersion": "6.2.5", "scroll": true, "showHeader": true, "sort": { "col": 0, "desc": true }, "styles": [ { "alias": "Time of Calculation", "dateFormat": "YYYY-MM-DD HH:mm:ss", "link": false, "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": "hidden", "unit": "short" } ], "targets": [ { "query": "from(bucket: \"monitoring_last\")\n|> filter(fn: (r) =>r._measurement == \"mm_topn_bucket_by_obj_size_place\" and r._field == \"value\"and r.place == \"1\")\n|> range($range)\n|> last()\n|> keep(columns: [\"_time\"])\n", "refId": "A", "resultFormat": "table" } ], "timeFrom": null, "timeShift": null, "title": " ", "transform": "table", "type": "table" }, { "columns": [], "description": "Top Buckets by Size", "fontSize": "100%", "gridPos": { "h": 11, "w": 24, "x": 0, "y": 3},"id": 161,"links": [],"options": {},"pageSize": 10,"scroll": true,"showHeader": true,"sort": { "col": 3, "desc": false},"styles": [ { "alias": "Time", "dateFormat": "MM/DD/YY h:mm:ss a", "pattern": "Time", "type": "hidden" }, { "alias": "", "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": "Measurement", "thresholds": [], "type": "hidden", "unit": "short" }, { "alias": "", "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": "Field", "thresholds": [], "type": "hidden", "unit": "short" }, { "alias": "", "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": "Value", "thresholds": [], "type": "hidden", "unit": "short"},{ "alias": "Size", "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": "vl4_value", "thresholds": [], "type": "number", "unit": "decbytes"},{ "alias": "Bucket Name", "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": "vl3_bucketName", "thresholds": [], "type": "number", "unit": "short"},{ "alias": "Place", "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": "vl1_place", "thresholds": [], "type": "number", "unit": "short"},{ "alias": "Namespace", "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": "vl2_ns", "thresholds": [], "type": "number", "unit": "short" }, { "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": [ { "query": "from(bucket: \"monitoring_last\")\n|> filter(fn: (r) =>r._measurement == \"mm_topn_bucket_by_obj_size_place\" and (r._field== \"bucketName\" or r._field == \"value\" or r._field == \"namespace\"))\n|>range($range)\n|> last()\n|> keep(columns:[\"_time\", \"_field\", \"_value\", \"place\"])\n|> pivot(rowKey:[\"_time\", \"place\"], columnKey: [\"_field\"], valueColumn: \"_value\")\n|>filter(fn: (r) => r.namespace =~ /^${ns:pipe}$/)\n|> map(mergeKey: false, fn:(r) =>({ _time: r._time, vl1_place: int(v: r.place), vl2_ns: r.namespace, vl3_bucketName:r.bucketName, vl4_value: r.value }))\n|> sort(columns:[\"place_s\"])", "refId": "A", "resultFormat": "table" } ], "title": "Top Buckets by Size", "transform": "table", "type": "table" }, { "columns": [], "description": "Top Buckets by Object Count", "fontSize": "100%", "gridPos": { "h": 11, "w": 24, "x": 0, "y": 14 },"id": 159,"links": [],"options": {},"pageSize": 10,"scroll": true,"showHeader": true,"sort": { "col": 3, "desc": false},"styles": [ { "alias": "Time", "dateFormat": "YYYY-MM-DD HH:mm:ss", "pattern": "Time", "type": "hidden" }, { "alias": "", "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": "Measurement", "thresholds": [], "type": "hidden", "unit": "short" }, { "alias": "", "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": "Field", "thresholds": [], "type": "hidden", "unit": "short" }, { "alias": "", "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": "Value", "thresholds": [], "type": "hidden", "unit": "short"},{ "alias": "Objects Count", "colorMode": null, "colors": [ "rgba(245, 54, 54, 0.9)", "rgba(237, 129, 40, 0.89)", "rgba(50, 172, 45, 0.97)" ], "dateFormat": "YYYY-MM-DD HH:mm:ss", "decimals": 2, "mappingType": 1, "pattern": "vl4_value", "thresholds": [], "type": "number", "unit": "short"},{ "alias": "Bucket Name", "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": "vl3_bucketName", "thresholds": [], "type": "number", "unit": "short"},{ "alias": "Place", "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": "vl1_place", "thresholds": [], "type": "number", "unit": "short"},{ "alias": "Namespace", "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": "vl2_ns", "thresholds": [], "type": "number", "unit": "short" }, { "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": [ { "query": "from(bucket: \"monitoring_last\")\n|> filter(fn: (r) =>r._measurement == \"mm_topn_bucket_by_obj_count_place\" and (r._field== \"bucketName\" or r._field == \"value\" or r._field == \"namespace\"))\n|>range($range)\n|> last()\n|> keep(columns:[\"_time\", \"_field\", \"_value\", \"place\"])\n|> pivot(rowKey:[\"_time\", \"place\"], columnKey: [\"_field\"], valueColumn: \"_value\")\n|>filter(fn: (r) => r.namespace =~ /^${ns:pipe}$/)\n|> map(mergeKey: false, fn:(r) =>({ _time: r._time, vl1_place: int(v: r.place), vl2_ns: r.namespace, vl3_bucketName:r.bucketName, vl4_value: r.value }))\n|> sort(columns:[\"place_s\"])", "refId": "A", "resultFormat": "table" } ], "title": "Top Buckets by Object Count", "transform": "table", "type": "table" } ], "refresh": false, "schemaVersion": 18, "style": "dark", "tags": [], "templating": { "list": [ { "allValue": ".*", "current": {}, "datasource": "${DS_FLUX}", "definition": "from(bucket:\"monitoring_last\") |> filter(fn:(r) =>r._measurement == \"mm_topn_bucket_by_obj_size_place\" and r._field==\"namespace\")|> range(start: -24h) |> last() |> group(columns:[\"_value\"]) |>last()", "hide": 0, "includeAll": true, "label": "Namespace", "multi": true, "name": "ns", "options": [], "query": "from(bucket:\"monitoring_last\") |> filter(fn:(r) =>r._measurement == \"mm_topn_bucket_by_obj_size_place\" and r._field==\"namespace\")|> range(start: -24h) |> last() |> group(columns:[\"_value\"]) |>last()", "refresh": 1, "regex": "", "skipUrlSync": false, "sort": 0, "tagValuesQuery": "", "tags": [], "tagsQuery": "", "type": "query", "useTags": false } ] }, "time": { "from": "now-24h", "to": "now" }, "timepicker": { "refresh_intervals": [ "15m", "30m", "1h", "2h", "1d" ], "time_options": [ "15m", "1h", "6h", "12h", "24h", "2d", "7d", "30d" ] }, "timezone": "", "title": "Top Buckets", "uid": "eu-XVJtWk", "version": 5}