# Elasticsearch returns 10000 rows even when only ~100 documents are relevant **URL:** \ **Category:** Kibana\ **Created:** [May 3, 2023, 1:23pm UTC](https://discuss.elastic.co/t/elasticsearch-returns-10000-rows-even-when-only-100-documents-are-relevant/332425 "2023-05-03T13:23:27Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![bonyolult](https://avatars.discourse-cdn.com/v4/letter/b/e36b37/32.png) [@bonyolult](https://discuss.elastic.co/u/bonyolult)\ **Post date:** [May 3, 2023, 1:23pm UTC](https://discuss.elastic.co/t/elasticsearch-returns-10000-rows-even-when-only-100-documents-are-relevant/332425/1 "2023-05-03T13:23:27Z")
Hello, i need some help with the following issue. I run wildcard queries on an index in Kibana Dev Tools. If i run one query at a time it returns only the relevant hits. If the queries are run paralell (2 browser tabs), both return 10000 hits. It is true for any of the queries below, looks it is related to the demand on Elasticsearch, or to something i could'n find until now in the documentations. The same is true if the queries are run by our application via Java API. The index has 6 shards, 2 replicas but the same happens with 1 shard and no replicas, too. Any help is appreciated because our client is a little bit crabby for the many irrelevant hits. Thank you, Attila ```auto GET someindex*/_search { "query": { "wildcard": { "somefield": "*sometext*" } } } GET someindex*/_search { "query": { "bool": { "must": [ { "wildcard": { "somefield": "*sometext*" } } ] } } } GET someindex*/_search { "query": { "bool": { "minimum_should_match": 1, "should": [ { "wildcard": { "somefield": "*sometext*" } } ] } } } ``` ---
**Author:** ![Wave](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wave/32/117242_2.png) [@Wave](https://discuss.elastic.co/u/Wave)\ **Post date:** [May 3, 2023, 7:37pm UTC](https://discuss.elastic.co/t/elasticsearch-returns-10000-rows-even-when-only-100-documents-are-relevant/332425/2 "2023-05-03T19:37:03Z")
Hi @bonyolult, You can add size as a query parameter to get 7 results for example with: ```auto GET someindex*/_search?size=7 ``` You could also add size in the body with: ```auto GET someindex*/_search { size: 7, "query": { ``` ---
**Author:** ![bonyolult](https://avatars.discourse-cdn.com/v4/letter/b/e36b37/32.png) [@bonyolult](https://discuss.elastic.co/u/bonyolult)\ **Post date:** [May 4, 2023, 7:59am UTC](https://discuss.elastic.co/t/elasticsearch-returns-10000-rows-even-when-only-100-documents-are-relevant/332425/3 "2023-05-04T07:59:28Z")
Hi Andrew, thank you for your answer! We are dealing with enermous amount of data. A query can return hundreds of thousands of hits and all those must be shown to the user paginated (that's the business req., i can't help:)). so the first thing is to count how many hits we can expect. In this case i can't use the size parameter. When search\_after is used than of course we use the size setting. The other thing what i don't understand is: how come, a query returns the e.g. 103 relevant hits and on the second run (when other queries are running, too) it returns everything. AFAIK it's clearly related to the demand on Elasticsearch. When a query runs alone on the cluster it's fine, returns ony what it has to. ---
**Author:** ![Wave](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wave/32/117242_2.png) [@Wave](https://discuss.elastic.co/u/Wave)\ **Post date:** [May 4, 2023, 1:15pm UTC](https://discuss.elastic.co/t/elasticsearch-returns-10000-rows-even-when-only-100-documents-are-relevant/332425/4 "2023-05-04T13:15:04Z")
Gotcha. Hmmm, I wouldn't expect the number of primaries or replicas to matter in the issue you are seeing. Just curious what happens when you run queries in parallel but on different clients? For example, instead of running it in two browser tabs on the same machine, trying two different machines each with one tab. ---
**Author:** ![bonyolult](https://avatars.discourse-cdn.com/v4/letter/b/e36b37/32.png) [@bonyolult](https://discuss.elastic.co/u/bonyolult)\ **Post date:** [May 23, 2023, 8:42am UTC](https://discuss.elastic.co/t/elasticsearch-returns-10000-rows-even-when-only-100-documents-are-relevant/332425/6 "2023-05-23T08:42:22Z")
The reason was a query\_string query without proper escaping, so when the user searched for `"something"` with wildcard, in the generated query there was `"*\"something\"*"` instead of `"*something*"` and this caused some strange and undeterministic behaviour. The other thing related to the queries shown in the original post: it seems to be a Kibana bug because running the same searches in Postman return the expected hits. ---
**Author:** ![Wave](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wave/32/117242_2.png) [@Wave](https://discuss.elastic.co/u/Wave)\ **Post date:** [May 23, 2023, 1:00pm UTC](https://discuss.elastic.co/t/elasticsearch-returns-10000-rows-even-when-only-100-documents-are-relevant/332425/7 "2023-05-23T13:00:25Z")
Oh good to know. Strange about postman being different than kibana though. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 20, 2023, 1:00pm UTC](https://discuss.elastic.co/t/elasticsearch-returns-10000-rows-even-when-only-100-documents-are-relevant/332425/8 "2023-06-20T13:00:50Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.