performance query in elasticsearch

Question

I have 2 queries:

GET _search
{
  "query": {
    "constant_score": {
      "filter": {
        "term": {
          "idpays": 250
        }
      }
    }
  }
}

and

GET _search
{
  "query": {
    "constant_score": {
      "filter": {
        "bool": {
          "must": {
            "term": {
              "idpays": 250
            }
          }
        }
      }
    }
  }
}

Theses 2 queries return the same results. Which one has the best performance? The first one or the second one with bool and must?

Regards

adityasinghraghav · Accepted Answer · 2016-07-15 13:47:43Z

1

Since Elasticsearch uses lucene under the hood all the queries are rewritten as simpler lucene queries before they are executed. If you use overly complicated queries to do a simple task, it will take Elasticsearch more time to rewrite the query into a simpler one.

add "profile": true at the root of your query to return a detailed analysis of the performance stats of the query and take a look at the rewrite time. The larger the time the more complex the query is. A quick look tells me the second one should be slower but you should analyze the results yourself.

answered Jul 15, 2016 at 13:47

adityasinghraghav

5444 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

performance query in elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related