Influxdb query duration

[Mert]

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)

[Anaisdg]

Hello @Mert,
Perhaps this thread is useful to you?

Measure Query Execution Time

If you start influxd in the foreground (i.e. executing influxd from a command prompt), it normally writes logs to standard error. I don’t have experience running InfluxDB with Windows, so I’m not sure how people are running it as a service or where logs would normally be expected to be sent to. Unfortunately nothing relevant is turning up on any searches I’ve tried. I assume the logs are going to whatever place is standard for how the influxd service is starting.

Thank you

[Mert]

Thanks @Anaisdg,

I don’t think these are closely related topics. influxdb already exposes some metrics which includes “queryDurationNs”. I just wanted to know if my query is logically correct. I think, in order to get “a query duration” we need to divide the “query duration” by the “number of queries executed”.