How to return only aggregation stats in an ElasticSearch query?

Question

Is it possible to exclude documents from an aggregation query? I just need to know "count" and "sum" and do not need hits. I did it like this:

{
  "query": {
    "match_all": {

    }
  },
  "aggs": {
    "my_agg": {
      "stats": {
        "field": "country_id"
      }
    }
  }
}

Possible duplicate of Perform Elasticsearch aggregation without returning hits array — Amir Ali Akbari
– Amir Ali Akbari, Commented Dec 11, 2016 at 10:03

Kevin. · Accepted Answer · 2015-04-26 15:06:54Z

14

To focus only on aggregation with a match_all query, you could simply use "size":0 (this specifies you want no query results) with no query:

curl -XPOST "http://localhost:9200/indexname/doctype/_search" -d'
{
    "size": 0, 
    "aggs": {
        "my_agg": {
            "stats": {
                "field": "country_id"
            }
        }
    }
}'

answered Apr 26, 2015 at 15:06

Kevin.

2,8202 gold badges24 silver badges22 bronze badges

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

1 Comment

Kevin. Over a year ago

Actually, Andrei Stefan's answer is better (source : elastic.co/guide/en/elasticsearch/reference/1.x/…). However, no need to add the match_all query.

Andrei Stefan · Accepted Answer · 2014-09-30 06:35:27Z

11

Add to your query ?search_type=count. For example:

GET /my_index/countries/_search?search_type=count
{
"query": {
    "match_all": {

    }
  },
  "aggs": {
    "my_agg": {
      "stats": {
        "field": "country_id"
      }
    }
  }
}

answered Sep 30, 2014 at 6:35

Andrei Stefan

52.5k6 gold badges102 silver badges92 bronze badges

1 Comment

yurez Over a year ago

"Deprecated in 2.0.0-beta1: count does not provide any benefits over query_then_fetch with a size of 0." link

Collectives™ on Stack Overflow

How to return only aggregation stats in an ElasticSearch query?

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related