What do the hot threads look like while the query is running? http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/cluster-nodes-hot-threads.html
On Tue, Feb 24, 2015 at 4:28 PM, Octavian <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/elasticsearch/1d1d559a-7ebe-435f-be9c-5dd89528eb2d%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Adrien Grand -- 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/CAL6Z4j4S6AwmgjY-T9u5EaH9RoL%2B-A3JHucAMYtpYyqFAHp50w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
