Skip to content

Instantly share code, notes, and snippets.

@GuetaHen

GuetaHen/profile.json

Created October 20, 2018 01:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save GuetaHen/f9b8e67aa0c81d9818dc8774cf9d2b3c to your computer and use it in GitHub Desktop.
Save GuetaHen/f9b8e67aa0c81d9818dc8774cf9d2b3c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
profile.json
{
"took": 936,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"failed": 0
},
"hits": {
"total": 2376,
"max_score": 0,
"hits": [
]
},
"aggregations": {
"transactionTotalValue": {
"value": 378913.1000137329
},
"transactionMinDate": {
"value": 1476646780150,
"value_as_string": "2016-10-16T19:39:40.150Z"
}
},
"profile": {
"shards": [
{
"id": "[3]",
"searches": [
{
"query": [
{
"type": "BooleanQuery",
"description": "+(+doc.type:transaction +doc.date:[-9223372036854775808 TO 1539492679806] +(doc.user_id:u::2-1482136850986-166310 doc.user_id:u::2-1476646137089-722440 doc.user_id:u::2-1479194700963-852066 doc.user_id:u::2-1480265460875-343974 doc.user_id:u::2-1481480223561-687220 doc.user_id:u::2-1490893533742-495973 doc.user_id:u::2-1491369718244-637855 doc.user_id:u::2-1516387240762-347825 doc.user_id:u::2-1528653244185-72739 doc.user_id:u::2-1528655615289-795763 doc.user_id:u::2-1529855538547-966658 doc.user_id:u::2-1530351338917-849377 doc.user_id:u::2-1530370314753-233523 doc.user_id:u::2-1530895620180-904769 doc.user_id:u::2-1534446475987-300580 doc.user_id:u::2-1535168457544-236782 doc.user_id:u::2-1537987992702-74474 doc.user_id:u::2-1538136688139-639988 doc.user_id:u::2-1538496245078-5097)) #(ConstantScore(+*:* -_type:__*))^0.0",
"time": "393.6896530ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 35,
"create_weight": 21680,
"next_doc": 29267356,
"match": 46128,
"create_weight_count": 1,
"next_doc_count": 652,
"score_count": 0,
"build_scorer": 364353787,
"advance": 0,
"advance_count": 0
},
"children": [
{
"type": "BooleanQuery",
"description": "+doc.type:transaction +doc.date:[-9223372036854775808 TO 1539492679806] +(doc.user_id:u::2-1482136850986-166310 doc.user_id:u::2-1476646137089-722440 doc.user_id:u::2-1479194700963-852066 doc.user_id:u::2-1480265460875-343974 doc.user_id:u::2-1481480223561-687220 doc.user_id:u::2-1490893533742-495973 doc.user_id:u::2-1491369718244-637855 doc.user_id:u::2-1516387240762-347825 doc.user_id:u::2-1528653244185-72739 doc.user_id:u::2-1528655615289-795763 doc.user_id:u::2-1529855538547-966658 doc.user_id:u::2-1530351338917-849377 doc.user_id:u::2-1530370314753-233523 doc.user_id:u::2-1530895620180-904769 doc.user_id:u::2-1534446475987-300580 doc.user_id:u::2-1535168457544-236782 doc.user_id:u::2-1537987992702-74474 doc.user_id:u::2-1538136688139-639988 doc.user_id:u::2-1538496245078-5097)",
"time": "393.0235760ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 13870,
"next_doc": 29003976,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 652,
"score_count": 0,
"build_scorer": 364005063,
"advance": 0,
"advance_count": 0
},
"children": [
{
"type": "TermQuery",
"description": "doc.type:transaction",
"time": "0.6903140000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 1152,
"next_doc": 0,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 124714,
"advance": 563754,
"advance_count": 679
}
},
{
"type": "",
"description": "doc.date:[-9223372036854775808 TO 1539492679806]",
"time": "44.52389900ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 376,
"next_doc": 0,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 44426783,
"advance": 96069,
"advance_count": 656
}
},
{
"type": "BooleanQuery",
"description": "doc.user_id:u::2-1482136850986-166310 doc.user_id:u::2-1476646137089-722440 doc.user_id:u::2-1479194700963-852066 doc.user_id:u::2-1480265460875-343974 doc.user_id:u::2-1481480223561-687220 doc.user_id:u::2-1490893533742-495973 doc.user_id:u::2-1491369718244-637855 doc.user_id:u::2-1516387240762-347825 doc.user_id:u::2-1528653244185-72739 doc.user_id:u::2-1528655615289-795763 doc.user_id:u::2-1529855538547-966658 doc.user_id:u::2-1530351338917-849377 doc.user_id:u::2-1530370314753-233523 doc.user_id:u::2-1530895620180-904769 doc.user_id:u::2-1534446475987-300580 doc.user_id:u::2-1535168457544-236782 doc.user_id:u::2-1537987992702-74474 doc.user_id:u::2-1538136688139-639988 doc.user_id:u::2-1538496245078-5097",
"time": "347.5104580ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 9691,
"next_doc": 28142500,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 652,
"score_count": 0,
"build_scorer": 319345359,
"advance": 12212,
"advance_count": 29
},
"children": [
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1482136850986-166310",
"time": "143.4765250ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 115,
"next_doc": 10769786,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 308,
"score_count": 0,
"build_scorer": 132703190,
"advance": 3102,
"advance_count": 9
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1476646137089-722440",
"time": "5.707585000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 60,
"next_doc": 298,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 4,
"score_count": 0,
"build_scorer": 5707208,
"advance": 0,
"advance_count": 0
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1479194700963-852066",
"time": "7.879044000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 66,
"next_doc": 17532,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 147,
"score_count": 0,
"build_scorer": 7861074,
"advance": 207,
"advance_count": 3
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1480265460875-343974",
"time": "18.92381500ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 63,
"next_doc": 589,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 4,
"score_count": 0,
"build_scorer": 18923144,
"advance": 0,
"advance_count": 0
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1481480223561-687220",
"time": "0.1225720000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 69,
"next_doc": 6001,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 8,
"score_count": 0,
"build_scorer": 116420,
"advance": 58,
"advance_count": 1
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1490893533742-495973",
"time": "42.92017500ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 111,
"next_doc": 8858261,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 141,
"score_count": 0,
"build_scorer": 34061647,
"advance": 0,
"advance_count": 0
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1491369718244-637855",
"time": "0.07731800000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 68,
"next_doc": 3762,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 24,
"score_count": 0,
"build_scorer": 73449,
"advance": 0,
"advance_count": 0
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1516387240762-347825",
"time": "16.55806800ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 58,
"next_doc": 0,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 16557995,
"advance": 0,
"advance_count": 0
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1528653244185-72739",
"time": "28.34905800ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 69,
"next_doc": 0,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 28348974,
"advance": 0,
"advance_count": 0
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1528655615289-795763",
"time": "0.08645300000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 60,
"next_doc": 6128,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 22,
"score_count": 0,
"build_scorer": 79870,
"advance": 352,
"advance_count": 6
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1529855538547-966658",
"time": "9.501318000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 67,
"next_doc": 8334384,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 10,
"score_count": 0,
"build_scorer": 1166842,
"advance": 0,
"advance_count": 0
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1530351338917-849377",
"time": "0.07053200000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 65,
"next_doc": 1285,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 8,
"score_count": 0,
"build_scorer": 69159,
"advance": 0,
"advance_count": 0
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1530370314753-233523",
"time": "0.05073900000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 64,
"next_doc": 693,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 5,
"score_count": 0,
"build_scorer": 49644,
"advance": 316,
"advance_count": 2
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1530895620180-904769",
"time": "0.06458500000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 59,
"next_doc": 2669,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 23,
"score_count": 0,
"build_scorer": 61699,
"advance": 118,
"advance_count": 2
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1534446475987-300580",
"time": "44.50781400ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 59,
"next_doc": 124,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 1,
"score_count": 0,
"build_scorer": 44507547,
"advance": 67,
"advance_count": 1
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1535168457544-236782",
"time": "9.678057000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 68,
"next_doc": 160,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 2,
"score_count": 0,
"build_scorer": 9677689,
"advance": 121,
"advance_count": 2
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1537987992702-74474",
"time": "5.876220000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 64,
"next_doc": 0,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 5876141,
"advance": 0,
"advance_count": 0
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1538136688139-639988",
"time": "13.27449500ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 60,
"next_doc": 42,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 1,
"score_count": 0,
"build_scorer": 13274330,
"advance": 46,
"advance_count": 1
}
},
{
"type": "TermQuery",
"description": "doc.user_id:u::2-1538496245078-5097",
"time": "0.07937400000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 14,
"match_count": 0,
"create_weight": 58,
"next_doc": 86,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 2,
"score_count": 0,
"build_scorer": 78962,
"advance": 249,
"advance_count": 2
}
}
]
}
]
},
{
"type": "BoostQuery",
"description": "(ConstantScore(+*:* -_type:__*))^0.0",
"time": "0.4098620000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 13,
"match_count": 35,
"create_weight": 3926,
"next_doc": 0,
"match": 39655,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 233962,
"advance": 131618,
"advance_count": 652
},
"children": [
{
"type": "BooleanQuery",
"description": "+*:* -_type:__*",
"time": "0.3330730000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 13,
"match_count": 35,
"create_weight": 3034,
"next_doc": 0,
"match": 37212,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 204059,
"advance": 88067,
"advance_count": 652
},
"children": [
{
"type": "MatchAllDocsQuery",
"description": "*:*",
"time": "0.008261000000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 8,
"match_count": 0,
"create_weight": 517,
"next_doc": 0,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 4617,
"advance": 3074,
"advance_count": 44
}
},
{
"type": "MultiTermQueryConstantScoreWrapper",
"description": "_type:__*",
"time": "0.1679570000ms",
"breakdown": {
"score": 0,
"build_scorer_count": 8,
"match_count": 0,
"create_weight": 512,
"next_doc": 0,
"match": 0,
"create_weight_count": 1,
"next_doc_count": 0,
"score_count": 0,
"build_scorer": 141346,
"advance": 26055,
"advance_count": 35
}
}
]
}
]
}
]
}
],
"rewrite_time": 27641,
"collector": [
{
"name": "CancellableCollector",
"reason": "search_cancelled",
"time": "540.5379140ms",
"children": [
{
"name": "MultiCollector",
"reason": "search_multi",
"time": "540.4906080ms",
"children": [
{
"name": "TotalHitCountCollector",
"reason": "search_count",
"time": "0.03796300000ms"
},
{
"name": "BucketCollector: [[org.elasticsearch.search.profile.aggregation.ProfilingAggregator@4c85ad56, org.elasticsearch.search.profile.aggregation.ProfilingAggregator@795934c6]]",
"reason": "aggregation",
"time": "540.3260570ms"
}
]
}
]
}
]
}
],
"aggregations": [
{
"type": "org.elasticsearch.search.aggregations.metrics.sum.SumAggregator",
"description": "transactionTotalValue",
"time": "32.45754900ms",
"breakdown": {
"reduce": 0,
"build_aggregation": 782,
"build_aggregation_count": 1,
"initialize": 1865,
"initialize_count": 1,
"reduce_count": 0,
"collect": 32454430,
"collect_count": 470
}
},
{
"type": "org.elasticsearch.search.aggregations.metrics.min.MinAggregator",
"description": "transactionMinDate",
"time": "507.3990940ms",
"breakdown": {
"reduce": 0,
"build_aggregation": 416,
"build_aggregation_count": 1,
"initialize": 462,
"initialize_count": 1,
"reduce_count": 0,
"collect": 507397744,
"collect_count": 470
}
}
]
},
{ },
{ },
{ },
{ }
]
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment