Poor performance with date range


(ofer lilian) #1

i am getting very poor throughput when i adding date range filter,
is there any tuning that i misssing ?


(Mark Walkom) #2

It'd help if you gave us your query.


(ofer lilian) #3

i see some improvment with rounding it to minute,
is there anything else i can do to improve that query ?

{
"from": 0,
"size": 100,
"query": {
"filtered": {
"query": {
"match_all": {}
},
"filter": {
"bool": {
"must": {"terms": {"TTTT": ["xxxx","yyyy","zzzz"]}},
"should": [{"range": {"MYDATE": {"to": "now/m"}}},
{"missing": {"field": "XXXX"}}
],
"must_not":
{"term": {"SSSSS": "C1"}},
"must": {"terms": {"BBBBB": ["R1","R2"]}}
}

    }
  }
}

}


(system) #4