Hello,
I have a problem with the performance of aggregations: The time of the
aggregation is very worst.
I'm doing the next aggregation over an index with 160M documents (16G of
data).
{
"query": {
"filtered": {
"filter": {
"range": {
"_cache": false,
"insert_date": {
"gte": 1424790449432
}
}
}
}
},
"aggs": {
"tag": {
"terms": {
"field": "origin_ip"
}
}
}
}
Time: 18s. No results found (The result is correct. There are no documents
with insert_date greater than 1424790449432)
However if I'm doing the next search:
{
"query": {
"filtered": {
"filter": {
"range": {
"_cache": false,
"insert_date": {
"gte": 1424790449432
}
}
}
}
}
}
Time: 7ms . No results found. (As I already wrote, the result is correct).
What is happening?
In documentation
(http://www.elasticsearch.org/guide/en/elasticsearch/guide/current/_filtered_query.html),
it is written :"The query (which happens to include a filter) returns a
certain subset of documents, and the aggregation operates on those
documents."
In my situation, there are no elements in the subset of documents returned
by the filter, so the aggregation should run in the same amount of time
like the search.
So, how can I improve the performance of that aggregation?
Thank you,
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/1d1d559a-7ebe-435f-be9c-5dd89528eb2d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
