Search slow down after upgrade to 2.4


(Deepak Mehta) #1

Hello,

We have recently upgraded to elastic search 2.4.2 from 1.6.1. Our searches are taking double time then 1.6.1

One of query example here,
We have two types of documents.

  1. seller
  2. buyer.

Below is complex query we execute:

http://localhost:9200/{index_name}/buyer%2Cseller/_search?pretty -d '{"query":{"filtered":{"query":{"bool":{"should":[{"bool":{"must":[{"term":{"_type":"buyer"}},{"bool":{"should":[{"term":{"buyerName":"india darshan"}},{"match":{"buyerName":{"query":"india darshan","boost":6}}},{"match":{"buyerName.trigram":{"query":"india darshan","boost":4,"minimum_should_match":"50%"}}},{"simple_query_string":{"fields":["content^3.0","userName^2.0","userFullName^2.0","comments^1.0"],"query":"india darshan"}},{"simple_query_string":{"fields":["content^3.0","userName^2.0","userFullName^2.0","comments^1.0"],"query":"india* darshan*"}}]}}]}},{"bool":{"must":[{"term":{"_type":"seller"}},{"bool":{"should":[{"term":{"sellerName":"india darshan"}},{"match":{"sellerName":{"query":"india darshan","boost":8}}},{"match":{"sellerName.trigram":{"query":"india darshan","boost":4,"minimum_should_match":"50%"}}},{"simple_query_string":{"fields":["description^1.0"],"query":"india darshan"}},{"simple_query_string":{"fields":["description^1.0"],"query":"india* darshan*"}}]}}]}}]}},"filter":{"and":[{"term":{"orgId":196323}},{"term":{"deleted":0}}]}}},"_source":{"exclude":["content"]},"highlight":{"fields":{"content":{"fragment_size":150,"number_of_fragments":3,"no_match_size":150}}},"from":0,"size":40}'

Anything wrong in this in context to 2.4.2 upgrade?

These queries used to take around 3sec in 1.6 and now increased to 7 secs in 2.4.2


(Deepak Mehta) #2

Any suggestions on this?


(Deepak Mehta) #4

Hot Threads attached.


(system) #5

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.