=============== Profiler: query =============== v = {timeRangeStart: -14d, timeRangeStop: -0d, windowPeriod: 10m} offmst = from(bucket: "dca") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "TfcMonitor" and r["host"] == "cbmin00y" and r["_field"] == "offabs") |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: true) |> keep(columns: ["_time","_value"]) |> rename(columns: {_value: "off_mst"}) offend = from(bucket: "dca") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] == "TfcMonitor" and r["host"] != "cbmin00y" and r["_field"] == "offabs") |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: true) |> keep(columns: ["_time","_value", "host", "oid"]) |> group() |> sort(columns: ["_time"]) |> rename(columns: {_value: "off_end"}) join(tables: {mst:offmst, end:offend}, on: ["_time"]) |> map(fn: (r) => ({ r with _value: r.off_end - r.off_mst})) |> drop(columns: ["off_mst","off_end"]) |> group(columns: ["host", "oid"], mode:"by") |> sort(columns: ["_time"]) |> yield() ======================== Profiler: profiler/query ======================== result : _profiler table : 0 _measurement : profiler/query TotalDuration : 2932474705 CompileDuration : 2152417 QueueDuration : 126250 PlanDuration : 0 RequeueDuration : 0 ExecuteDuration : 2930133163 Concurrency : 0 MaxAllocated : 598445952 TotalAllocated : 0 flux/query-plan : digraph { ReadWindowAggregateByTime32 // every = 10m, aggregates = [mean], createEmpty = true, timeColumn = "_stop", forceAggregate = true keep8 group9 sort10 rename11 ReadWindowAggregateByTime33 // every = 10m, aggregates = [mean], createEmpty = true, timeColumn = "_stop", forceAggregate = true keep20 rename21 join22 map23 drop24 group25 sort26 yield27 ReadWindowAggregateByTime32 -> keep8 keep8 -> group9 group9 -> sort10 sort10 -> rename11 ReadWindowAggregateByTime33 -> keep20 keep20 -> rename21 rename11 -> join22 rename21 -> join22 join22 -> map23 map23 -> drop24 drop24 -> group25 group25 -> sort26 sort26 -> yield27 } influxdb/scanned-bytes: 0 influxdb/scanned-values: 0 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.schemaMutationTransformation Label : keep8 Count : 6 MinDuration : 21750 MaxDuration : 50458 DurationSum : 182332 MeanDuration : 30388.666666666668 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.schemaMutationTransformation Label : keep20 Count : 3 MinDuration : 19500 MaxDuration : 37417 DurationSum : 87959 MeanDuration : 29319.666666666668 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.schemaMutationTransformation Label : rename21 Count : 3 MinDuration : 11833 MaxDuration : 46375 DurationSum : 70624 MeanDuration : 23541.333333333332 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.schemaMutationTransformation Label : drop24 Count : 4 MinDuration : 7667 MaxDuration : 20958 DurationSum : 46541 MeanDuration : 11635.25 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.schemaMutationTransformation Label : rename11 Count : 3 MinDuration : 7083 MaxDuration : 21833 DurationSum : 38624 MeanDuration : 12874.666666666666 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *influxdb.readWindowAggregateSource Label : ReadWindowAggregateByTime33 Count : 1 MinDuration : 31846335 MaxDuration : 31846335 DurationSum : 31846335 MeanDuration : 31846335.0 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *influxdb.readWindowAggregateSource Label : ReadWindowAggregateByTime32 Count : 1 MinDuration : 36660459 MaxDuration : 36660459 DurationSum : 36660459 MeanDuration : 36660459.0 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.mergeJoinTransformation Label : join22 Count : 6 MinDuration : 9750 MaxDuration : 2692471529 DurationSum : 2695629446 MeanDuration : 449271574.3333333 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.mapTransformation Label : map23 Count : 4 MinDuration : 12000 MaxDuration : 108982254 DurationSum : 109987171 MeanDuration : 27496792.75 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.groupTransformation Label : group25 Count : 4 MinDuration : 6333 MaxDuration : 10070417 DurationSum : 10099541 MeanDuration : 2524885.25 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.groupTransformation Label : group9 Count : 6 MinDuration : 11458 MaxDuration : 22667 DurationSum : 87042 MeanDuration : 14507.0 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.sortTransformation Label : sort26 Count : 7 MinDuration : 6333 MaxDuration : 1141875 DurationSum : 4626751 MeanDuration : 660964.4285714285 =========================== Profiler: profiler/operator =========================== result : _profiler table : 1 _measurement : profiler/operator Type : *universe.sortTransformation Label : sort10 Count : 3 MinDuration : 11583 MaxDuration : 24495459 DurationSum : 25942251 MeanDuration : 8647417.0