# Doubt about performance elastic 2.4 matchAll X boolQuery **URL:** \ **Category:** Elasticsearch\ **Created:** [November 20, 2017, 2:47pm UTC](https://discuss.elastic.co/t/doubt-about-performance-elastic-2-4-matchall-x-boolquery/108408 "2017-11-20T14:47:38Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![RafaelPosthaus](https://avatars.discourse-cdn.com/v4/letter/r/73ab20/32.png) [@RafaelPosthaus](https://discuss.elastic.co/u/RafaelPosthaus)\ **Post date:** [November 20, 2017, 2:47pm UTC](https://discuss.elastic.co/t/doubt-about-performance-elastic-2-4-matchall-x-boolquery/108408/1 "2017-11-20T14:47:38Z")
Good afternoon, Browsing a legacy font I found a search in elasticSearch 2.4, which did the following: create the filters and sorts, and then apply this to a matchAll Query. Would I have more performance if instead of matchAll use a boolQuery for example? The search is about locating a certain item of a particular category for example. In my tests the search with matchAll seems to be costly. Would you have any suggestions or explanation for this behavior? Thankful. ---
**Author:** ![RafaelPosthaus](https://avatars.discourse-cdn.com/v4/letter/r/73ab20/32.png) [@RafaelPosthaus](https://discuss.elastic.co/u/RafaelPosthaus)\ **Post date:** [November 20, 2017, 3:16pm UTC](https://discuss.elastic.co/t/doubt-about-performance-elastic-2-4-matchall-x-boolquery/108408/2 "2017-11-20T15:16:44Z")
This is one of the executed queries, it seems to me to bring all products of the right base? Actually, I should bring only the dresses. ```auto { "from" : 0, "size" : 52, "query" : { "filtered" : { "query" : { "match_all" : { } }, "filter" : { "bool" : { "must" : { "or" : { "filters" : [ { "range" : { "valor" : { "from" : 0.0, "to" : 99999.99, "include_lower" : true, "include_upper" : true } } } ] } } } } } }, "sort" : [ { "qtdComprada" : { "order" : "desc" } }, { "_score" : { } }, { "cliques" : { "order" : "desc" } } ], "aggregations" : { "tipoProduto" : { "terms" : { "field" : "tipoProduto", "size" : 100 } }, "loja" : { "terms" : { "field" : "loja.codigo", "size" : 100 } }, "tamanho" : { "terms" : { "field" : "tamanhos.tamanho", "size" : 100 } }, "corAgrupado" : { "terms" : { "field" : "corAgrupado", "size" : 100 } }, "grupos" : { "nested" : { "path" : "classificacoes" }, "aggregations" : { "grupo" : { "terms" : { "field" : "classificacoes.grupo", "size" : 100 }, "aggregations" : { "subgrupo" : { "terms" : { "field" : "classificacoes.subgrupo", "size" : 100 }, "aggregations" : { "subclasse" : { "terms" : { "field" : "classificacoes.subclasse", "size" : 100 } } } } } } } }, "marca" : { "terms" : { "field" : "marca.codigo", "size" : 100 } }, "valor" : { "range" : { "field" : "valor", "ranges" : [ { "key" : "ATE_49", "from" : 0.01, "to" : 50.0 }, { "key" : "DE_50_ATE_99", "from" : 50.0, "to" : 100.0 }, { "key" : "DE_100_ATE_149", "from" : 100.0, "to" : 150.0 }, { "key" : "DE_149_ATE_199", "from" : 150.0, "to" : 200.0 }, { "key" : "MAIOR_200", "from" : 200.0, "to" : 100000.0 } ] } }, "faixaEtariasLoja" : { "terms" : { "field" : "faixaEtariasLoja", "size" : 100 } } }, "suggest" : { "desc" : { "text" : " DRESSES", "phrase" : { "field" : "descritivo" } } } } ``` ---
**Author:** ![RafaelPosthaus](https://avatars.discourse-cdn.com/v4/letter/r/73ab20/32.png) [@RafaelPosthaus](https://discuss.elastic.co/u/RafaelPosthaus)\ **Post date:** [November 20, 2017, 5:10pm UTC](https://discuss.elastic.co/t/doubt-about-performance-elastic-2-4-matchall-x-boolquery/108408/3 "2017-11-20T17:10:49Z")
Would this query have some more performative form? ```auto { "from" : 0, "size" : 36, "query" : { "filtered" : { "query" : { "match_all" : { } }, "filter" : { "bool" : { "must" : [ { "terms" : { "loja.codigo" : [42] } }, { "or" : { "filters" : [ { "range" : { "valor" : { "from" : 0.0, "to" : 99999.99, "include_lower" : true, "include_upper" : true } } } ] } }, { "terms" : { "corAgrupado" : ["PRETO", "VERMELHO"] } }, { "terms" : { "tamanhos.tamanho" : ["m"] } }, { "nested" : { "query" : { "bool" : { "must" : { "match" : { "classificacoes.grupo" : { "query" : 38, "type" : "boolean" } } } } }, "path" : "classificacoes" } } ] } } } }, "sort" : [ { "qtdComprada" : { "order" : "desc" } }, { "_score" : { } }, { "cliques" : { "order" : "desc" } } ], "aggregations" : { "tipoProduto" : { "terms" : { "field" : "tipoProduto", "size" : 100 } }, "loja" : { "terms" : { "field" : "loja.codigo", "size" : 100 } }, "tamanho" : { "terms" : { "field" : "tamanhos.tamanho", "size" : 100 } }, "corAgrupado" : { "terms" : { "field" : "corAgrupado", "size" : 100 } }, "grupos" : { "nested" : { "path" : "classificacoes" }, "aggregations" : { "grupo" : { "terms" : { "field" : "classificacoes.grupo", "size" : 100 }, "aggregations" : { "subgrupo" : { "terms" : { "field" : "classificacoes.subgrupo", "size" : 100 }, "aggregations" : { "subclasse" : { "terms" : { "field" : "classificacoes.subclasse", "size" : 100 } } } } } } } }, "marca" : { "terms" : { "field" : "marca.codigo", "size" : 100 } }, "valor" : { "range" : { "field" : "valor", "ranges" : [ { "key" : "ATE_49", "from" : 0.01, "to" : 50.0 }, { "key" : "DE_50_ATE_99", "from" : 50.0, "to" : 100.0 }, { "key" : "DE_100_ATE_149", "from" : 100.0, "to" : 150.0 }, { "key" : "DE_149_ATE_199", "from" : 150.0, "to" : 200.0 }, { "key" : "MAIOR_200", "from" : 200.0, "to" : 100000.0 } ] } }, "faixaEtariasLoja" : { "terms" : { "field" : "faixaEtariasLoja", "size" : 100 } } }, "suggest" : { "desc" : { "text" : "", "phrase" : { "field" : "descritivo" } } } } ``` ---
**Author:** ![jpountz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jpountz/32/45836_2.png) [@jpountz](https://discuss.elastic.co/u/jpountz)\ **Post date:** [November 21, 2017, 2:05pm UTC](https://discuss.elastic.co/t/doubt-about-performance-elastic-2-4-matchall-x-boolquery/108408/4 "2017-11-21T14:05:18Z")
The `filtered` and `bool` query should have the same performance, `bool` is just the new syntax for filtered queries (using `filter` clauses). ---
**Author:** ![thiago](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/thiago/32/32096_2.png) [@thiago](https://discuss.elastic.co/u/thiago)\ **Post date:** [November 23, 2017, 1:41pm UTC](https://discuss.elastic.co/t/doubt-about-performance-elastic-2-4-matchall-x-boolquery/108408/5 "2017-11-23T13:41:43Z")
I am understanding that you want to know the performance difference between using a `terms` query as a `query` versus using a `matchAll` query as a `query` and apply a `filter` later. I understand that, intuitively, you may think that using the `terms` query as a `query` would be better compared to filtering since Elasticsearch would precisely hit the documents that matches the query whereas with the filtering Elasticsearch would scan every single document to apply the filter. But that's not what really happens under the covers because Elasticsearch almost never scans the whole document dataset regardless if that `terms` query is being used as a filter or not. Generally, by using a `matchAll` + `filter` it would have a better performance since there is no scoring calculation involved but since you are using just a `terms` query then the scoring overhead is really low and that performance difference is marginal. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [December 21, 2017, 1:41pm UTC](https://discuss.elastic.co/t/doubt-about-performance-elastic-2-4-matchall-x-boolquery/108408/6 "2017-12-21T13:41:49Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.