Skip to content

Instantly share code, notes, and snippets.

@codyaray

codyaray/query.sh

Last active January 5, 2016 22:43
Show Gist options
  • Save codyaray/5d8d1c6766acd2134d07 to your computer and use it in GitHub Desktop.
Save codyaray/5d8d1c6766acd2134d07 to your computer and use it in GitHub Desktop.
Download ZIP
Example slow query
Raw
query.sh
time curl "localhost:9200/stats-2016.01.05/_search?pretty" -d '{
"query": {
"filtered": {
"query": {
"query_string": {
"analyze_wildcard": false,
"query": "_type:nextgen-stats",
"lowercase_expanded_terms": false
}
},
"filter": {
"bool": {
"must": [
{
"range": {
"@timestamp": {
"gte": 1451982872963,
"lte": 1452026072963
}
}
}
],
"must_not": []
}
}
}
},
"size": 0,
"aggs": {
"2": {
"date_histogram": {
"field": "@timestamp",
"interval": "10m",
"pre_zone": "-06:00",
"pre_zone_adjust_large_interval": true,
"min_doc_count": 1,
"extended_bounds": {
"min": 1451982872960,
"max": 1452026072960
}
},
"aggs": {
"1": {
"sum": {
"field": "hmap_size"
}
}
}
}
}
}'
Raw
response.json
{
"took": 7589,
"timed_out": false,
"_shards": {
"total": 8,
"successful": 8,
"failed": 0
},
"hits": {
"total": 208644986,
"max_score": 0,
"hits": []
},
"aggregations": {
"2": {
"buckets": [
{
"1": {
"value": 54
},
"key_as_string": "2016-01-05T10:30:00.000Z",
"key": 1451989800000,
"doc_count": 2539
},
{
"1": {
"value": 1283
},
"key_as_string": "2016-01-05T10:40:00.000Z",
"key": 1451990400000,
"doc_count": 51285
},
{
"1": {
"value": 4609
},
"key_as_string": "2016-01-05T10:50:00.000Z",
"key": 1451991000000,
"doc_count": 51382
},
{
"1": {
"value": 1127351
},
"key_as_string": "2016-01-05T11:00:00.000Z",
"key": 1451991600000,
"doc_count": 5744
},
{
"1": {
"value": 2385463
},
"key_as_string": "2016-01-05T12:00:00.000Z",
"key": 1451995200000,
"doc_count": 945
},
{
"1": {
"value": 3627376
},
"key_as_string": "2016-01-05T12:10:00.000Z",
"key": 1451995800000,
"doc_count": 6339
},
{
"1": {
"value": 75151
},
"key_as_string": "2016-01-05T12:20:00.000Z",
"key": 1451996400000,
"doc_count": 15948
},
{
"1": {
"value": 874709
},
"key_as_string": "2016-01-05T12:30:00.000Z",
"key": 1451997000000,
"doc_count": 58421
},
{
"1": {
"value": 99416
},
"key_as_string": "2016-01-05T12:40:00.000Z",
"key": 1451997600000,
"doc_count": 91331
},
{
"1": {
"value": 292199
},
"key_as_string": "2016-01-05T12:50:00.000Z",
"key": 1451998200000,
"doc_count": 112345
},
{
"1": {
"value": 377822128
},
"key_as_string": "2016-01-05T13:00:00.000Z",
"key": 1451998800000,
"doc_count": 188419
},
{
"1": {
"value": 1057918
},
"key_as_string": "2016-01-05T13:10:00.000Z",
"key": 1451999400000,
"doc_count": 218452
},
{
"1": {
"value": 69540185
},
"key_as_string": "2016-01-05T13:20:00.000Z",
"key": 1452000000000,
"doc_count": 278134
},
{
"1": {
"value": 1552196
},
"key_as_string": "2016-01-05T13:30:00.000Z",
"key": 1452000600000,
"doc_count": 357928
},
{
"1": {
"value": 1027616
},
"key_as_string": "2016-01-05T13:40:00.000Z",
"key": 1452001200000,
"doc_count": 453885
},
{
"1": {
"value": 263022284
},
"key_as_string": "2016-01-05T13:50:00.000Z",
"key": 1452001800000,
"doc_count": 531004
},
{
"1": {
"value": 297731824
},
"key_as_string": "2016-01-05T14:00:00.000Z",
"key": 1452002400000,
"doc_count": 553480
},
{
"1": {
"value": 52090696
},
"key_as_string": "2016-01-05T14:10:00.000Z",
"key": 1452003000000,
"doc_count": 559479
},
{
"1": {
"value": 537906
},
"key_as_string": "2016-01-05T14:20:00.000Z",
"key": 1452003600000,
"doc_count": 572135
},
{
"1": {
"value": 14220240687
},
"key_as_string": "2016-01-05T14:30:00.000Z",
"key": 1452004200000,
"doc_count": 4586085
},
{
"1": {
"value": 14796184294
},
"key_as_string": "2016-01-05T14:40:00.000Z",
"key": 1452004800000,
"doc_count": 4749852
},
{
"1": {
"value": 15076810674
},
"key_as_string": "2016-01-05T14:50:00.000Z",
"key": 1452005400000,
"doc_count": 4969795
},
{
"1": {
"value": 15473818109
},
"key_as_string": "2016-01-05T15:00:00.000Z",
"key": 1452006000000,
"doc_count": 4978589
},
{
"1": {
"value": 16486011169
},
"key_as_string": "2016-01-05T15:10:00.000Z",
"key": 1452006600000,
"doc_count": 4979846
},
{
"1": {
"value": 16551235881
},
"key_as_string": "2016-01-05T15:20:00.000Z",
"key": 1452007200000,
"doc_count": 5112173
},
{
"1": {
"value": 16257831829
},
"key_as_string": "2016-01-05T15:30:00.000Z",
"key": 1452007800000,
"doc_count": 5015289
},
{
"1": {
"value": 16249573882
},
"key_as_string": "2016-01-05T15:40:00.000Z",
"key": 1452008400000,
"doc_count": 4987091
},
{
"1": {
"value": 16494092251
},
"key_as_string": "2016-01-05T15:50:00.000Z",
"key": 1452009000000,
"doc_count": 4998641
},
{
"1": {
"value": 16539853659
},
"key_as_string": "2016-01-05T16:00:00.000Z",
"key": 1452009600000,
"doc_count": 5034227
},
{
"1": {
"value": 16552003855
},
"key_as_string": "2016-01-05T16:10:00.000Z",
"key": 1452010200000,
"doc_count": 5086845
},
{
"1": {
"value": 16732024720
},
"key_as_string": "2016-01-05T16:20:00.000Z",
"key": 1452010800000,
"doc_count": 5030065
},
{
"1": {
"value": 17174395499
},
"key_as_string": "2016-01-05T16:30:00.000Z",
"key": 1452011400000,
"doc_count": 4964677
},
{
"1": {
"value": 17211563719
},
"key_as_string": "2016-01-05T16:40:00.000Z",
"key": 1452012000000,
"doc_count": 4960472
},
{
"1": {
"value": 17504311818
},
"key_as_string": "2016-01-05T16:50:00.000Z",
"key": 1452012600000,
"doc_count": 4998457
},
{
"1": {
"value": 17528623854
},
"key_as_string": "2016-01-05T17:00:00.000Z",
"key": 1452013200000,
"doc_count": 5047427
},
{
"1": {
"value": 17670189381
},
"key_as_string": "2016-01-05T17:10:00.000Z",
"key": 1452013800000,
"doc_count": 5071556
},
{
"1": {
"value": 17837185244
},
"key_as_string": "2016-01-05T17:20:00.000Z",
"key": 1452014400000,
"doc_count": 4932321
},
{
"1": {
"value": 18111524357
},
"key_as_string": "2016-01-05T17:30:00.000Z",
"key": 1452015000000,
"doc_count": 4784193
},
{
"1": {
"value": 18176343443
},
"key_as_string": "2016-01-05T17:40:00.000Z",
"key": 1452015600000,
"doc_count": 4794327
},
{
"1": {
"value": 18036786224
},
"key_as_string": "2016-01-05T17:50:00.000Z",
"key": 1452016200000,
"doc_count": 4734953
},
{
"1": {
"value": 18249208321
},
"key_as_string": "2016-01-05T18:00:00.000Z",
"key": 1452016800000,
"doc_count": 4900347
},
{
"1": {
"value": 18435251878
},
"key_as_string": "2016-01-05T18:10:00.000Z",
"key": 1452017400000,
"doc_count": 4832952
},
{
"1": {
"value": 18452707026
},
"key_as_string": "2016-01-05T18:20:00.000Z",
"key": 1452018000000,
"doc_count": 4819242
},
{
"1": {
"value": 18570863158
},
"key_as_string": "2016-01-05T18:30:00.000Z",
"key": 1452018600000,
"doc_count": 4895612
},
{
"1": {
"value": 18868136806
},
"key_as_string": "2016-01-05T18:40:00.000Z",
"key": 1452019200000,
"doc_count": 5081138
},
{
"1": {
"value": 19093132662
},
"key_as_string": "2016-01-05T18:50:00.000Z",
"key": 1452019800000,
"doc_count": 5101815
},
{
"1": {
"value": 18884346631
},
"key_as_string": "2016-01-05T19:00:00.000Z",
"key": 1452020400000,
"doc_count": 5040356
},
{
"1": {
"value": 18811112390
},
"key_as_string": "2016-01-05T19:10:00.000Z",
"key": 1452021000000,
"doc_count": 5070169
},
{
"1": {
"value": 18790312085
},
"key_as_string": "2016-01-05T19:20:00.000Z",
"key": 1452021600000,
"doc_count": 5294233
},
{
"1": {
"value": 18709351593
},
"key_as_string": "2016-01-05T19:30:00.000Z",
"key": 1452022200000,
"doc_count": 5106228
},
{
"1": {
"value": 18564461733
},
"key_as_string": "2016-01-05T19:40:00.000Z",
"key": 1452022800000,
"doc_count": 5060011
},
{
"1": {
"value": 18668749535
},
"key_as_string": "2016-01-05T19:50:00.000Z",
"key": 1452023400000,
"doc_count": 5072310
},
{
"1": {
"value": 18605138173
},
"key_as_string": "2016-01-05T20:00:00.000Z",
"key": 1452024000000,
"doc_count": 5200899
},
{
"1": {
"value": 18919622608
},
"key_as_string": "2016-01-05T20:10:00.000Z",
"key": 1452024600000,
"doc_count": 5213650
},
{
"1": {
"value": 18901143017
},
"key_as_string": "2016-01-05T20:20:00.000Z",
"key": 1452025200000,
"doc_count": 5331462
},
{
"1": {
"value": 18536139529
},
"key_as_string": "2016-01-05T20:30:00.000Z",
"key": 1452025800000,
"doc_count": 5522632
},
{
"1": {
"value": 17929841681
},
"key_as_string": "2016-01-05T20:40:00.000Z",
"key": 1452026400000,
"doc_count": 6489403
},
{
"1": {
"value": 17783745064
},
"key_as_string": "2016-01-05T20:50:00.000Z",
"key": 1452027000000,
"doc_count": 6602862
},
{
"1": {
"value": 928343973
},
"key_as_string": "2016-01-05T21:00:00.000Z",
"key": 1452027600000,
"doc_count": 921006
},
{
"1": {
"value": 275220071
},
"key_as_string": "2016-01-05T21:10:00.000Z",
"key": 1452028200000,
"doc_count": 599899
},
{
"1": {
"value": 42635094
},
"key_as_string": "2016-01-05T21:20:00.000Z",
"key": 1452028800000,
"doc_count": 571015
},
{
"1": {
"value": 260225
},
"key_as_string": "2016-01-05T21:30:00.000Z",
"key": 1452029400000,
"doc_count": 550832
},
{
"1": {
"value": 378201
},
"key_as_string": "2016-01-05T21:40:00.000Z",
"key": 1452030000000,
"doc_count": 623952
},
{
"1": {
"value": 115565810
},
"key_as_string": "2016-01-05T21:50:00.000Z",
"key": 1452030600000,
"doc_count": 552332
},
{
"1": {
"value": 1469865748
},
"key_as_string": "2016-01-05T22:00:00.000Z",
"key": 1452031200000,
"doc_count": 605675
},
{
"1": {
"value": 648920824
},
"key_as_string": "2016-01-05T22:10:00.000Z",
"key": 1452031800000,
"doc_count": 579625
},
{
"1": {
"value": 343510431
},
"key_as_string": "2016-01-05T22:20:00.000Z",
"key": 1452032400000,
"doc_count": 585002
},
{
"1": {
"value": 219550
},
"key_as_string": "2016-01-05T22:30:00.000Z",
"key": 1452033000000,
"doc_count": 494251
}
]
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment