Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- {
- "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
- }
- }
- ]
- },
- { },
- { },
- { },
- { }
- ]
- }
- }
Add Comment
Please, Sign In to add comment