Last active
January 5, 2016 22:43
-
-
Save codyaray/5d8d1c6766acd2134d07 to your computer and use it in GitHub Desktop.
Example slow query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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" | |
| } | |
| } | |
| } | |
| } | |
| } | |
| }' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "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