how to optimize slow query

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

how to optimize slow query

asoqa
This post has NOT been accepted by the mailing list yet.
 I have one node cluster with 3000+ docs.

query:
GET daiquiri/dqr_rules/_search
{"_source":{"exclude":["example"]},"size":5000,"query":{"match_all":{}},"filter":{"and":[{"not":{"term":{"name":"onlydiff"}}},{"and":[{"term":{"rid":"616"}},{"term":{"category":"CELL"}}]}]},"sort":[{"status":"desc"},{"count":"desc"}]}

the query took 40~50ms with 453 hits. I set ES_HEAP_SIZE=1g

this query is a little slow, I want to optimize. I tried some methos, but not work.Anyone helps?