Skip to content

Instantly share code, notes, and snippets.

@wakawaka54
Created January 13, 2019 07:33
Show Gist options
  • Save wakawaka54/6b52fd0eef2b8ead1589241e65c239fe to your computer and use it in GitHub Desktop.
Save wakawaka54/6b52fd0eef2b8ead1589241e65c239fe to your computer and use it in GitHub Desktop.
Elasticsearch Query Profile
"profile": {
"shards": [
{
"id": "[Et56u6N-RBusw0uf0BnpUQ][products][2]",
"searches": [
{
"query": [
{
"type": "BooleanQuery",
"description": "+searchData.fullText:drone #numberSort.totalGrossPrice:[1.0 TO 1500.0] #numberSort.lotSize:[1.0 TO 10.0] #numberSort.orders:[10.0 TO 1.0E7] #numberSort.ratings:[4.0 TO 5.0]",
"time": "8173.669870ms",
"time_in_nanos": 8173669870,
"breakdown": {
"score": 0,
"build_scorer_count": 50,
"match_count": 12991,
"create_weight": 78567,
"next_doc": 37373389,
"match": 8093749717,
"create_weight_count": 1,
"next_doc_count": 17179,
"score_count": 0,
"build_scorer": 42437976,
"advance": 0,
"advance_count": 0
},
"children": [
{
"type": "TermQuery",
"description": "searchData.fullText:drone",
"time": "66.42045900ms",
"time_in_nanos": 66420459,
"breakdown": {
"score": 0,
"build_scorer_count": 94,
"match_count": 0,
"create_weight": 26927,
"next_doc": 28888811,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 17179,
"score_count": 0,
"build_scorer": 37487447,
"advance": 0,
"advance_count": 0
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.totalGrossPrice:[1.0 TO 1500.0]",
"time": "2760.256007ms",
"time_in_nanos": 2760256007,
"breakdown": {
"score": 0,
"build_scorer_count": 88,
"match_count": 12991,
"create_weight": 4871,
"next_doc": 0,
"match": 2757533061,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 1834533,
"advance": 853283,
"advance_count": 17179
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.lotSize:[1.0 TO 10.0]",
"time": "2346.448902ms",
"time_in_nanos": 2346448902,
"breakdown": {
"score": 0,
"build_scorer_count": 88,
"match_count": 12928,
"create_weight": 1476,
"next_doc": 0,
"match": 2345310382,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 460890,
"advance": 645958,
"advance_count": 17179
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.orders:[10.0 TO 1.0E7]",
"time": "2492.105536ms",
"time_in_nanos": 2492105536,
"breakdown": {
"score": 0,
"build_scorer_count": 88,
"match_count": 12781,
"create_weight": 1196,
"next_doc": 0,
"match": 2491088819,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 375573,
"advance": 609899,
"advance_count": 17179
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.ratings:[4.0 TO 5.0]",
"time": "496.3914550ms",
"time_in_nanos": 496391455,
"breakdown": {
"score": 0,
"build_scorer_count": 88,
"match_count": 912,
"create_weight": 1122,
"next_doc": 0,
"match": 495431316,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 350271,
"advance": 590566,
"advance_count": 17179
}
}
]
}
],
"rewrite_time": 31112,
"collector": [
{
"name": "CancellableCollector",
"reason": "search_cancelled",
"time": "1076.055657ms",
"time_in_nanos": 1076055657,
"children": [
{
"name": "SimpleFieldCollector",
"reason": "search_top_hits",
"time": "1074.521849ms",
"time_in_nanos": 1074521849
}
]
}
]
}
],
"aggregations": []
},
{
"id": "[VlalboERSZmCvGP9ocYI-w][products][0]",
"searches": [
{
"query": [
{
"type": "BooleanQuery",
"description": "+searchData.fullText:drone #numberSort.totalGrossPrice:[1.0 TO 1500.0] #numberSort.lotSize:[1.0 TO 10.0] #numberSort.orders:[10.0 TO 1.0E7] #numberSort.ratings:[4.0 TO 5.0]",
"time": "9974.344413ms",
"time_in_nanos": 9974344413,
"breakdown": {
"score": 0,
"build_scorer_count": 47,
"match_count": 12940,
"create_weight": 50215,
"next_doc": 48746171,
"match": 9884546208,
"create_weight_count": 1,
"next_doc_count": 17726,
"score_count": 0,
"build_scorer": 40971105,
"advance": 0,
"advance_count": 0
},
"children": [
{
"type": "TermQuery",
"description": "searchData.fullText:drone",
"time": "64.43269000ms",
"time_in_nanos": 64432690,
"breakdown": {
"score": 0,
"build_scorer_count": 83,
"match_count": 0,
"create_weight": 7740,
"next_doc": 28675688,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 17726,
"score_count": 0,
"build_scorer": 35731452,
"advance": 0,
"advance_count": 0
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.totalGrossPrice:[1.0 TO 1500.0]",
"time": "3261.276020ms",
"time_in_nanos": 3261276020,
"breakdown": {
"score": 0,
"build_scorer_count": 72,
"match_count": 12940,
"create_weight": 4631,
"next_doc": 0,
"match": 3257791196,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 2005890,
"advance": 1443564,
"advance_count": 17726
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.lotSize:[1.0 TO 10.0]",
"time": "3022.312587ms",
"time_in_nanos": 3022312587,
"breakdown": {
"score": 0,
"build_scorer_count": 72,
"match_count": 12894,
"create_weight": 1095,
"next_doc": 0,
"match": 3020267876,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 345090,
"advance": 1667833,
"advance_count": 17726
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.orders:[10.0 TO 1.0E7]",
"time": "3032.480957ms",
"time_in_nanos": 3032480957,
"breakdown": {
"score": 0,
"build_scorer_count": 72,
"match_count": 12764,
"create_weight": 1135,
"next_doc": 0,
"match": 3031501615,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 265215,
"advance": 682429,
"advance_count": 17726
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.ratings:[4.0 TO 5.0]",
"time": "570.6096710ms",
"time_in_nanos": 570609671,
"breakdown": {
"score": 0,
"build_scorer_count": 72,
"match_count": 857,
"create_weight": 902,
"next_doc": 0,
"match": 569132759,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 420187,
"advance": 1037167,
"advance_count": 17726
}
}
]
}
],
"rewrite_time": 58773,
"collector": [
{
"name": "CancellableCollector",
"reason": "search_cancelled",
"time": "1202.252178ms",
"time_in_nanos": 1202252178,
"children": [
{
"name": "SimpleFieldCollector",
"reason": "search_top_hits",
"time": "1201.613764ms",
"time_in_nanos": 1201613764
}
]
}
]
}
],
"aggregations": []
},
{
"id": "[X7YsQf06RaW6vFp7X_-X3g][products][1]",
"searches": [
{
"query": [
{
"type": "BooleanQuery",
"description": "+searchData.fullText:drone #numberSort.totalGrossPrice:[1.0 TO 1500.0] #numberSort.lotSize:[1.0 TO 10.0] #numberSort.orders:[10.0 TO 1.0E7] #numberSort.ratings:[4.0 TO 5.0]",
"time": "14642.13030ms",
"time_in_nanos": 14642130299,
"breakdown": {
"score": 0,
"build_scorer_count": 48,
"match_count": 12956,
"create_weight": 46823,
"next_doc": 70494532,
"match": 14512305559,
"create_weight_count": 1,
"next_doc_count": 16732,
"score_count": 0,
"build_scorer": 59253648,
"advance": 0,
"advance_count": 0
},
"children": [
{
"type": "TermQuery",
"description": "searchData.fullText:drone",
"time": "113.2429090ms",
"time_in_nanos": 113242909,
"breakdown": {
"score": 0,
"build_scorer_count": 88,
"match_count": 0,
"create_weight": 2295,
"next_doc": 56901680,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 16732,
"score_count": 0,
"build_scorer": 56322113,
"advance": 0,
"advance_count": 0
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.totalGrossPrice:[1.0 TO 1500.0]",
"time": "5233.068990ms",
"time_in_nanos": 5233068990,
"breakdown": {
"score": 0,
"build_scorer_count": 80,
"match_count": 12956,
"create_weight": 597,
"next_doc": 0,
"match": 5231385704,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 702844,
"advance": 950076,
"advance_count": 16732
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.lotSize:[1.0 TO 10.0]",
"time": "3614.452612ms",
"time_in_nanos": 3614452612,
"breakdown": {
"score": 0,
"build_scorer_count": 80,
"match_count": 12894,
"create_weight": 253,
"next_doc": 0,
"match": 3613206167,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 226334,
"advance": 990151,
"advance_count": 16732
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.orders:[10.0 TO 1.0E7]",
"time": "4916.748763ms",
"time_in_nanos": 4916748763,
"breakdown": {
"score": 0,
"build_scorer_count": 80,
"match_count": 12760,
"create_weight": 162,
"next_doc": 0,
"match": 4915922033,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 199069,
"advance": 597926,
"advance_count": 16732
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.ratings:[4.0 TO 5.0]",
"time": "746.9318330ms",
"time_in_nanos": 746931833,
"breakdown": {
"score": 0,
"build_scorer_count": 80,
"match_count": 872,
"create_weight": 186,
"next_doc": 0,
"match": 746013081,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 287659,
"advance": 613222,
"advance_count": 16732
}
}
]
}
],
"rewrite_time": 11217,
"collector": [
{
"name": "CancellableCollector",
"reason": "search_cancelled",
"time": "1517.630562ms",
"time_in_nanos": 1517630562,
"children": [
{
"name": "SimpleFieldCollector",
"reason": "search_top_hits",
"time": "1517.153764ms",
"time_in_nanos": 1517153764
}
]
}
]
}
],
"aggregations": []
},
{
"id": "[X7YsQf06RaW6vFp7X_-X3g][products][4]",
"searches": [
{
"query": [
{
"type": "BooleanQuery",
"description": "+searchData.fullText:drone #numberSort.totalGrossPrice:[1.0 TO 1500.0] #numberSort.lotSize:[1.0 TO 10.0] #numberSort.orders:[10.0 TO 1.0E7] #numberSort.ratings:[4.0 TO 5.0]",
"time": "17721.65538ms",
"time_in_nanos": 17721655378,
"breakdown": {
"score": 0,
"build_scorer_count": 51,
"match_count": 12649,
"create_weight": 47744,
"next_doc": 94362339,
"match": 17548007060,
"create_weight_count": 1,
"next_doc_count": 16460,
"score_count": 0,
"build_scorer": 79209074,
"advance": 0,
"advance_count": 0
},
"children": [
{
"type": "TermQuery",
"description": "searchData.fullText:drone",
"time": "157.0915360ms",
"time_in_nanos": 157091536,
"breakdown": {
"score": 0,
"build_scorer_count": 87,
"match_count": 0,
"create_weight": 2225,
"next_doc": 80223338,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 16460,
"score_count": 0,
"build_scorer": 76849425,
"advance": 0,
"advance_count": 0
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.totalGrossPrice:[1.0 TO 1500.0]",
"time": "6309.509568ms",
"time_in_nanos": 6309509568,
"breakdown": {
"score": 0,
"build_scorer_count": 72,
"match_count": 12649,
"create_weight": 637,
"next_doc": 0,
"match": 6307839861,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 644304,
"advance": 995584,
"advance_count": 16460
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.lotSize:[1.0 TO 10.0]",
"time": "4408.401561ms",
"time_in_nanos": 4408401561,
"breakdown": {
"score": 0,
"build_scorer_count": 72,
"match_count": 12580,
"create_weight": 727,
"next_doc": 0,
"match": 4407540054,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 189372,
"advance": 642295,
"advance_count": 16460
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.orders:[10.0 TO 1.0E7]",
"time": "5994.189168ms",
"time_in_nanos": 5994189168,
"breakdown": {
"score": 0,
"build_scorer_count": 72,
"match_count": 12465,
"create_weight": 223,
"next_doc": 0,
"match": 5993376793,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 174715,
"advance": 608439,
"advance_count": 16460
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.ratings:[4.0 TO 5.0]",
"time": "833.7121930ms",
"time_in_nanos": 833712193,
"breakdown": {
"score": 0,
"build_scorer_count": 72,
"match_count": 882,
"create_weight": 228,
"next_doc": 0,
"match": 832796212,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 267970,
"advance": 630368,
"advance_count": 16460
}
}
]
}
],
"rewrite_time": 13305,
"collector": [
{
"name": "CancellableCollector",
"reason": "search_cancelled",
"time": "1809.025823ms",
"time_in_nanos": 1809025823,
"children": [
{
"name": "SimpleFieldCollector",
"reason": "search_top_hits",
"time": "1808.359891ms",
"time_in_nanos": 1808359891
}
]
}
]
}
],
"aggregations": []
},
{
"id": "[m_DDEQ9aQ5m3dmBO5WzRpw][products][3]",
"searches": [
{
"query": [
{
"type": "BooleanQuery",
"description": "+searchData.fullText:drone #numberSort.totalGrossPrice:[1.0 TO 1500.0] #numberSort.lotSize:[1.0 TO 10.0] #numberSort.orders:[10.0 TO 1.0E7] #numberSort.ratings:[4.0 TO 5.0]",
"time": "4997.347137ms",
"time_in_nanos": 4997347137,
"breakdown": {
"score": 0,
"build_scorer_count": 40,
"match_count": 3346,
"create_weight": 33169,
"next_doc": 71349380,
"match": 4909468020,
"create_weight_count": 1,
"next_doc_count": 5137,
"score_count": 0,
"build_scorer": 16488044,
"advance": 0,
"advance_count": 0
},
"children": [
{
"type": "TermQuery",
"description": "searchData.fullText:drone",
"time": "46.88219500ms",
"time_in_nanos": 46882195,
"breakdown": {
"score": 0,
"build_scorer_count": 68,
"match_count": 0,
"create_weight": 2828,
"next_doc": 30235102,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 5137,
"score_count": 0,
"build_scorer": 14120065,
"advance": 2505471,
"advance_count": 13523
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.totalGrossPrice:[1.0 TO 1500.0]",
"time": "1771.527125ms",
"time_in_nanos": 1771527125,
"breakdown": {
"score": 0,
"build_scorer_count": 56,
"match_count": 3346,
"create_weight": 1028,
"next_doc": 0,
"match": 1770543989,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 780477,
"advance": 193091,
"advance_count": 5137
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.lotSize:[1.0 TO 10.0]",
"time": "1312.540195ms",
"time_in_nanos": 1312540195,
"breakdown": {
"score": 0,
"build_scorer_count": 56,
"match_count": 3328,
"create_weight": 157,
"next_doc": 0,
"match": 1312143447,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 205589,
"advance": 182480,
"advance_count": 5137
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.orders:[10.0 TO 1.0E7]",
"time": "1812.973647ms",
"time_in_nanos": 1812973647,
"breakdown": {
"score": 0,
"build_scorer_count": 56,
"match_count": 3306,
"create_weight": 114,
"next_doc": 0,
"match": 1812644309,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 149335,
"advance": 171389,
"advance_count": 5137
}
},
{
"type": "IndexOrDocValuesQuery",
"description": "numberSort.ratings:[4.0 TO 5.0]",
"time": "44.69014100ms",
"time_in_nanos": 44690141,
"breakdown": {
"score": 0,
"build_scorer_count": 56,
"match_count": 8,
"create_weight": 121,
"next_doc": 0,
"match": 12343826,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 179015,
"advance": 32148535,
"advance_count": 18579
}
}
]
}
],
"rewrite_time": 15493,
"collector": [
{
"name": "CancellableCollector",
"reason": "search_cancelled",
"time": "887.3342780ms",
"time_in_nanos": 887334278,
"children": [
{
"name": "SimpleFieldCollector",
"reason": "search_top_hits",
"time": "887.0106510ms",
"time_in_nanos": 887010651
}
]
}
]
}
],
"aggregations": []
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment