Make Elasticsearch return the number of all documents on query

Question

When I do a query Elasticsearch returns how many hits I get. Can I also get it to reply how many documents it has in total? Here I've added the imaginary field sum_documents to the result. Does such thing exist, or to I have to make an extra query to fetch the sum?

{
  "took" : 1,
  "timed_out" : false,
  "_shards" : {
    "total" : 5,
    "successful" : 5,
    "failed" : 0
  },
  "hits" : {
    "total" : 0,
    "sum_documents": 500,
    "max_score" : null,
    "hits" : [ ]
  }
}

Val · Accepted Answer · 2015-06-04 12:22:47Z

1

You can add a global aggregation in your query, and it will return the total document count in your search context (index/alias + type(s))

{
  "query": {
    "query_string": {
      "query": "viking",
      "default_operator": "AND"
    }
  },
  "aggs": {
    "harvester-test": {
      "global": {}
    }
  }
}

edited Jun 4, 2015 at 12:22

answered Jun 4, 2015 at 7:49

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

martins Over a year ago

Hi Val. Thanks for the suggestion. I could not get it working, though. Would you mind having a look? I've updated the post with the query I tried.

Val Over a year ago

I've updated my answer. aggs should be at the top level, i.e. at the same level as the query part.

Collectives™ on Stack Overflow

Make Elasticsearch return the number of all documents on query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related