Template Elasticsearch Timeboard indexing/query latency might be wrong

[yaoxiaotong]

The template chart of indexing latency and query latency might be wrong. It shows different with Kibana.

Take query latency for example. The template is using rate of fetch time and rate of query time like this:

It might be better to use derivatives to get the same chart with Kibana like this:
(derivative of fetch time + derivative of query time ) / derivative of query total

The json of this is

{ "viz": "timeseries", "status": "done", "requests": [ { "q": "( derivative(sum:elasticsearch.search.fetch.time{$cluster}) + derivative(sum:elasticsearch.search.query.time{$cluster}) ) * 1000 / derivative(sum:elasticsearch.search.query.total{$cluster})", "aggregator": "avg", "conditional_formats": [], "type": "line" } ], "autoscale": true }

[johnaxel]

Thanks for the report @yaoxiaotong. Can you take a look @echang26 ?

[echang26]

Hi @yaoxiaotong thanks for bringing this to our attention. We used your suggestion to apply a fix to our default Elasticsearch timeboard's indexing and query latency graphs, and it does look like those graphs are now more similar to the ones shown in Marvel/Kibana (see below).

Thanks for letting us know.

[yaoxiaotong]

@johnaxel @echang26 thanks for your response and fixing. This solved the problem.

[johnaxel]

Thanks for the report!