Shards query and merging time

Elastic Stack Elasticsearch
1

Hi,

I want to know if there is anyway, by which we can find the following
1)Query execution time on a shard.
2)Merging time to merge the result of every shard.

I have gone through the Profile API, But didn't understand much, Could you please help me with above timings.

2

IF you have a setting index.search.slowlog.threshold.query.debug: 0s in your elasticsearch .yml, it would print the query execution time per shard.

Related to second question please check this https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-stats.html

3

Hey SKumarMN,

Thanks .

Will surely try this today.

As for the merging time taken by each shard for a given search query, We wont be able to find using : Index stats API | Elasticsearch Guide [8.11] | Elastic

As these gives the cummulative time.