Bird
Raised Fist0

Which Elasticsearch query syntax correctly calculates the average response time from APM data?

easy📝 Syntax Q12 of Q15
Elasticsearch - ELK Stack Integration
Which Elasticsearch query syntax correctly calculates the average response time from APM data?
APOST /apm-*/_update_by_query {"script": {"source": "ctx._source.duration = 0"}}
BGET /apm-*/_search {"query": {"match_all": {}}, "size":10}
CGET /apm-*/_search {"size":0, "aggs": {"avg_response_time": {"avg": {"field": "transaction.duration.us"}}}}
DGET /apm-*/_search {"aggs": {"max_response_time": {"max": {"field": "transaction.duration.us"}}}}
Step-by-Step Solution
Solution:
  1. Step 1: Identify aggregation for average

    The query uses "avg" aggregation on the field "transaction.duration.us" which stores response times in microseconds.
  2. Step 2: Confirm query structure

    Size is 0 to avoid returning documents, focusing only on aggregation results, which is correct for average calculation.
  3. Final Answer:

    GET /apm-*/_search {"size":0, "aggs": {"avg_response_time": {"avg": {"field": "transaction.duration.us"}}}} -> Option C
  4. Quick Check:

    Average aggregation query = GET /apm-*/_search {"size":0, "aggs": {"avg_response_time": {"avg": {"field": "transaction.duration.us"}}}} [OK]
Quick Trick: Average uses "avg" aggregation with size 0 [OK]
Common Mistakes:
MISTAKES
  • Using match_all without aggregation
  • Using update_by_query instead of search
  • Using max aggregation instead of avg

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Elasticsearch Quizzes