Versions OpenSearch 2.19.4
Describe the issue: I have been digging down into trying to optimize our search indexing and speed up access in OpenSearch Dashboard. After finding some other issues the searches are now much faster, but one things that remains is the date_histogram performance.
Currently a simple query selecting the first 10 documents and performing a date_histogram like the one in OpenSearch Dashboards take 1600ms to perform on an 9GB index with ~50M, the same query without the aggregation is <100ms. This isn’t terrible, but according to this https://opensearch.org/blog/opensearch-performance-2.17/ they are able to perform Date histogram aggregations in ~150ms with a 24GB index and 100M documents… so I am seeing 10x slower performance with half the dataset.. That is also with older / smaller instances than I run these tests on (m7a / 32GB RAM with 8GB heap).
Is there anything I’m missing that could explain the large difference between the benchmark and my results?
Relevant Logs or Screenshots:
Query
{
"sort": [
{
"time": {
"order": "desc",
"numeric_type": "date_nanos",
"unmapped_type": "boolean"
}
}
],
"size": 10,
"version": true,
"aggs": {
"2": {
"date_histogram": {
"field": "time",
"interval": "3h",
"time_zone": "Europe/Stockholm",
"min_doc_count": 1
}
}
},
"stored_fields": [
"*"
],
"script_fields": {},
"docvalue_fields": [
{
"field": "time",
"format": "strict_date_time"
}
],
"_source": {
"excludes": []
},
"query": {
"bool": {
"must": [],
"filter": [
{
"match_all": {}
},
{
"range": {
"time": {
"gte": "2026-01-18T11:00:00.000Z",
"lte": "2026-01-21T15:09:00.000Z"
}
}
}
],
"should": [],
"must_not": []
}
},
"highlight": {
"pre_tags": [
"@opensearch-dashboards-highlighted-field@"
],
"post_tags": [
"@/opensearch-dashboards-highlighted-field@"
],
"fields": {
"*": {}
},
"fragment_size": 2147483647
}
}
Search result with profiling
{
"took": 6889,
"timed_out": false,
"_shards": {
"total": 1,
"successful": 1,
"skipped": 0,
"failed": 0
},
"hits": {
"total": {
"value": 10000,
"relation": "gte"
},
"max_score": null,
"hits": [
...
]
},
"aggregations": {
"2": {
"buckets": [
{
"key_as_string": "2026-01-17T00:00:00.000+01:00",
"key": 1768604400000,
"doc_count": 165265
},
{
"key_as_string": "2026-01-17T03:00:00.000+01:00",
"key": 1768615200000,
"doc_count": 203854
},
{
"key_as_string": "2026-01-17T06:00:00.000+01:00",
"key": 1768626000000,
"doc_count": 201415
},
{
"key_as_string": "2026-01-17T09:00:00.000+01:00",
"key": 1768636800000,
"doc_count": 314319
},
{
"key_as_string": "2026-01-17T12:00:00.000+01:00",
"key": 1768647600000,
"doc_count": 203160
},
{
"key_as_string": "2026-01-17T15:00:00.000+01:00",
"key": 1768658400000,
"doc_count": 202781
},
{
"key_as_string": "2026-01-17T18:00:00.000+01:00",
"key": 1768669200000,
"doc_count": 313823
},
{
"key_as_string": "2026-01-17T21:00:00.000+01:00",
"key": 1768680000000,
"doc_count": 234553
},
{
"key_as_string": "2026-01-18T00:00:00.000+01:00",
"key": 1768690800000,
"doc_count": 213416
},
{
"key_as_string": "2026-01-18T03:00:00.000+01:00",
"key": 1768701600000,
"doc_count": 204543
},
{
"key_as_string": "2026-01-18T06:00:00.000+01:00",
"key": 1768712400000,
"doc_count": 203687
},
{
"key_as_string": "2026-01-18T09:00:00.000+01:00",
"key": 1768723200000,
"doc_count": 319639
},
{
"key_as_string": "2026-01-18T12:00:00.000+01:00",
"key": 1768734000000,
"doc_count": 207570
},
{
"key_as_string": "2026-01-18T15:00:00.000+01:00",
"key": 1768744800000,
"doc_count": 207212
},
{
"key_as_string": "2026-01-18T18:00:00.000+01:00",
"key": 1768755600000,
"doc_count": 315310
},
{
"key_as_string": "2026-01-18T21:00:00.000+01:00",
"key": 1768766400000,
"doc_count": 200804
},
{
"key_as_string": "2026-01-19T00:00:00.000+01:00",
"key": 1768777200000,
"doc_count": 206272
},
{
"key_as_string": "2026-01-19T03:00:00.000+01:00",
"key": 1768788000000,
"doc_count": 1263188
},
{
"key_as_string": "2026-01-19T06:00:00.000+01:00",
"key": 1768798800000,
"doc_count": 211024
},
{
"key_as_string": "2026-01-19T09:00:00.000+01:00",
"key": 1768809600000,
"doc_count": 4330943
},
{
"key_as_string": "2026-01-19T12:00:00.000+01:00",
"key": 1768820400000,
"doc_count": 3043267
},
{
"key_as_string": "2026-01-19T21:00:00.000+01:00",
"key": 1768852800000,
"doc_count": 8606
},
{
"key_as_string": "2026-01-20T00:00:00.000+01:00",
"key": 1768863600000,
"doc_count": 200426
},
{
"key_as_string": "2026-01-20T03:00:00.000+01:00",
"key": 1768874400000,
"doc_count": 1262428
},
{
"key_as_string": "2026-01-20T06:00:00.000+01:00",
"key": 1768885200000,
"doc_count": 214415
},
{
"key_as_string": "2026-01-20T09:00:00.000+01:00",
"key": 1768896000000,
"doc_count": 2430440
},
{
"key_as_string": "2026-01-20T12:00:00.000+01:00",
"key": 1768906800000,
"doc_count": 3040783
},
{
"key_as_string": "2026-01-20T15:00:00.000+01:00",
"key": 1768917600000,
"doc_count": 2308017
},
{
"key_as_string": "2026-01-20T18:00:00.000+01:00",
"key": 1768928400000,
"doc_count": 68364
},
{
"key_as_string": "2026-01-21T00:00:00.000+01:00",
"key": 1768950000000,
"doc_count": 161402
},
{
"key_as_string": "2026-01-21T03:00:00.000+01:00",
"key": 1768960800000,
"doc_count": 1262344
},
{
"key_as_string": "2026-01-21T06:00:00.000+01:00",
"key": 1768971600000,
"doc_count": 468161
},
{
"key_as_string": "2026-01-21T09:00:00.000+01:00",
"key": 1768982400000,
"doc_count": 2165345
},
{
"key_as_string": "2026-01-21T12:00:00.000+01:00",
"key": 1768993200000,
"doc_count": 743968
},
{
"key_as_string": "2026-01-21T15:00:00.000+01:00",
"key": 1769004000000,
"doc_count": 4066170
},
{
"key_as_string": "2026-01-21T18:00:00.000+01:00",
"key": 1769014800000,
"doc_count": 242691
},
{
"key_as_string": "2026-01-21T21:00:00.000+01:00",
"key": 1769025600000,
"doc_count": 107048
},
{
"key_as_string": "2026-01-22T00:00:00.000+01:00",
"key": 1769036400000,
"doc_count": 175558
},
{
"key_as_string": "2026-01-22T03:00:00.000+01:00",
"key": 1769047200000,
"doc_count": 1274229
},
{
"key_as_string": "2026-01-22T06:00:00.000+01:00",
"key": 1769058000000,
"doc_count": 3452538
},
{
"key_as_string": "2026-01-22T09:00:00.000+01:00",
"key": 1769068800000,
"doc_count": 2974063
},
{
"key_as_string": "2026-01-22T12:00:00.000+01:00",
"key": 1769079600000,
"doc_count": 2749579
},
{
"key_as_string": "2026-01-23T00:00:00.000+01:00",
"key": 1769122800000,
"doc_count": 169019
},
{
"key_as_string": "2026-01-23T03:00:00.000+01:00",
"key": 1769133600000,
"doc_count": 1288116
},
{
"key_as_string": "2026-01-23T06:00:00.000+01:00",
"key": 1769144400000,
"doc_count": 209444
},
{
"key_as_string": "2026-01-23T09:00:00.000+01:00",
"key": 1769155200000,
"doc_count": 3753381
},
{
"key_as_string": "2026-01-23T12:00:00.000+01:00",
"key": 1769166000000,
"doc_count": 2855836
},
{
"key_as_string": "2026-01-23T15:00:00.000+01:00",
"key": 1769176800000,
"doc_count": 1120552
}
]
}
},
"profile": {
"shards": [
{
"id": "[PpNGMZZvQbuIwVZf9U3ivQ][test-perf-dev-kontrakcja-v4][0]",
"inbound_network_time_in_millis": 0,
"outbound_network_time_in_millis": 0,
"searches": [
{
"query": [
{
"type": "ConstantScoreQuery",
"description": "ConstantScore(*:*)",
"time_in_nanos": 3957273494,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 3957000073,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 249821,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 51538996,
"compute_max_score": 0,
"build_scorer_count": 56,
"create_weight": 23600
},
"children": [
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 1349133086,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 1348988225,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 144361,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 51538996,
"compute_max_score": 0,
"build_scorer_count": 56,
"create_weight": 500
}
}
]
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 60,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 60
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 760,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 760
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 200,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 200
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 310,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 310
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 790,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 790
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 640,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 640
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 790,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 790
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 390,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 390
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 750,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 750
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 420,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 420
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 450,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 450
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 480,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 480
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 110,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 110
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 30,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 30
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 40,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 40
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 920,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 920
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 480,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 480
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 490,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 490
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 290,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 290
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 650,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 650
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 170,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 170
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 150,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 150
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 190,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 190
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 160,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 160
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 330,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 330
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 260,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 260
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 350,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 350
}
},
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time_in_nanos": 240,
"breakdown": {
"set_min_competitive_score_count": 0,
"match_count": 0,
"shallow_advance_count": 0,
"next_doc": 0,
"score_count": 0,
"compute_max_score_count": 0,
"advance": 0,
"advance_count": 0,
"score": 0,
"shallow_advance": 0,
"create_weight_count": 1,
"build_scorer": 0,
"set_min_competitive_score": 0,
"match": 0,
"next_doc_count": 0,
"compute_max_score": 0,
"build_scorer_count": 0,
"create_weight": 240
}
}
],
"rewrite_time": 36281,
"collector": [
{
"name": "MultiCollector",
"reason": "search_multi",
"time_in_nanos": 5274882008,
"children": [
{
"name": "SimpleFieldCollector",
"reason": "search_top_hits",
"time_in_nanos": 440184
},
{
"name": "ProfilingAggregator: [2]",
"reason": "aggregation",
"time_in_nanos": 2598217603
}
]
}
]
}
],
"aggregations": [
{
"type": "DateHistogramAggregator",
"description": "2",
"time_in_nanos": 2507166518,
"breakdown": {
"reduce": 0,
"build_aggregation_count": 1,
"post_collection": 2650,
"initialize_count": 1,
"reduce_count": 0,
"collect_count": 51538968,
"post_collection_count": 1,
"build_leaf_collector": 725501,
"build_aggregation": 23470,
"build_leaf_collector_count": 28,
"initialize": 2500,
"collect": 2506412397
},
"debug": {
"total_buckets": 48
}
}
]
}
]
}
}
Index settings
{
"settings": {
"index": {
"codec": "best_compression",
"number_of_shards": 1,
"number_of_replicas": 1,
"sort.field": "time",
"sort.order": "desc"
}
},
"mappings": {
"properties": {
"time": {
"type": "date_nanos"
}
}
[...]
}
}