ok, good hint
first query, 500 results
- query time: 170ms
- request time: 27339ms
second query after clearing the cache with following:
POST /winlogbeat-2019.11.14/_cache/clear
POST /winlogbeat-2019.11.13/_cache/clear
Result:
# POST /winlogbeat-2019.11.14/_cache/clear
{
"_shards" : {
"total" : 5,
"successful" : 5,
"failed" : 0
}
}
# POST /winlogbeat-2019.11.13/_cache/clear
{
"_shards" : {
"total" : 5,
"successful" : 5,
"failed" : 0
}
}
Query time: 129ms
Request time: 634ms
so... even after clearing cache, second query is very fast (for the same data); how is that possible?!