Hi, I want to calculate how long each query take? Can you check out the query below. I thought, we should divide the cumulative duration by how many queries executed or finished. Am I doing right?
SELECT non_negative_derivative(mean("queryDurationNs"), 10s) / non_negative_derivative(mean("queriesFinished"), 10s) AS "query duration" FROM "influxdb_queryExecutor" WHERE $timeFilter GROUP BY time(1m) fill(null)