ElasticSearch count returned result

Question

I want to count number of document returned as a result of a query with size limit. For example, I run following query:

curl -XGET http://localhost:9200/logs_-*/a_logs/_search?pretty=true -d '
{
"query" : {
    "match_all" : {  }
},
"size" : 5,
"from" : 8318
}'

and I get:

{
"took" : 5,
"timed_out" : false,
"_shards" : {
"total" : 159,
"successful" : 159,
"failed" : 0
},
  "hits" : {
  "total" : 8319,
  "max_score" : 1.0,
  "hits" : [ {
....

Total documents matching my query are 8319, but I fetched at max 5. Only 1 document was returned since I queried "from" 8318.

In the response, I do not know how many documents are returned. I want to write a query such that the number of documents being returned are also present in some field. Maybe some facet may help, but I could not figure out. Kindly help.

Can't you just count the number of objects in the hits array on the client side? — javanna
– javanna, Commented May 15, 2013 at 17:48
That is an expensive operation. I want to know the number before I start counting/processing individual objects. — Nabeel Akhtar
– Nabeel Akhtar, Commented May 16, 2013 at 9:01
There's no way to get that information back. The idea is that if you already parsed the json response it shouldn't be a big problem to read the length of that array, but if you have a big json object and you read it using a pull parser, then it's a completely different story. — javanna
– javanna, Commented May 16, 2013 at 9:23

toto · Accepted Answer · 2013-11-06 07:02:39Z

9

Your query :

{
"query" : {
    "match_all" : {  }
},

=> Means that you ask all your data

"size" : 5,

=> You want to display only 5 results

"from" : 8318

=> You start from the 8318 records

ElasticSearch respons :

....

"hits" : {
  "total" : 8319,

... => Elastic search told you that there is 8319 results in his index.

You ask him all the result and you start from the 8318.

8319 - 8318 = 1 So you have 1 result.

Try by removing the from.

answered Nov 6, 2013 at 7:02

toto

911 silver badge2 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

enkiv2 · Accepted Answer · 2013-05-15 13:42:53Z

1

Looking through the documentation, it's not clear how to make the query return this -- if indeed the API supports it. If you just want to have the count of the returned hits, the easiest way seems to be to actually count them yourself after parsing the response.

answered May 15, 2013 at 13:42

enkiv2

3062 silver badges8 bronze badges

Comments

WesternGun · Accepted Answer · 2024-05-03 19:00:43Z

0

Use GET /{index}/_count to count all(fast) or use GET /{index}/_search with size=0 and track_total_hits: true to get all counts.

Use _search:

{
  "query": {
            "exists": {
                "field": "foo"
            }
    },
    "size": 0,
    "track_total_hits":true
}

answered May 3, 2024 at 19:00

WesternGun

13.1k9 gold badges119 silver badges192 bronze badges

Collectives™ on Stack Overflow

ElasticSearch count returned result

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related