Skip to content

Instantly share code, notes, and snippets.

@IdanFridman
Created January 20, 2020 18:28
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 IdanFridman/c1ef80e50568db7eb936f3f6a8fb9ae3 to your computer and use it in GitHub Desktop.
Save IdanFridman/c1ef80e50568db7eb936f3f6a8fb9ae3 to your computer and use it in GitHub Desktop.
query without outter joing
{
"profile":[
{
"executor":"Top",
"limit":"@@SESSION.`sql_select_limit`",
"actual_row_count":{ "value":300 },
"actual_total_time":{ "value":0 },
"inputs":[
{
"executor":"Gather",
"partitions":"all",
"query":"SELECT `cce`.`player_id` AS `player_id`, `cce`.`game_id` AS `game_id`, `cce`.`bet_amount_converted` AS `bet_amount_converted`, `cce`.`cont_amount_jackpot` AS `cont_amount_jackpot`, `cce`.`base_currency` AS `base_currency` FROM `contribution_0`.`cont_event` as `cce` WHERE ((`cce`.`game_id` IN ('2k9d71558609680765')) AND (`cce`.`action` IN ('PLACE_BET','CANCEL_BET')) AND (`cce`.`event_arrival_time` BETWEEN '2019-12-22 00:00:00' AND '2019-12-23 15:00:00') AND (`cce`.`status` = 'ACCEPTED')) LIMIT NULL OPTION(NO_QUERY_REWRITE=1, INTERPRETER_MODE=INTERPRET_FIRST)",
"alias":"remote_0",
"actual_row_count":{ "value":300, "avg":0.000000, "stddev":0.000000, "max":0, "maxPartition":0 },
"actual_total_time":{ "value":0 },
"start_time":{ "value":0 },
"end_time":{ "value":112 },
"inputs":[
{
"executor":"Project",
"out":[
{
"alias":"",
"projection":"cce.player_id"
},
{
"alias":"",
"projection":"cce.game_id"
},
{
"alias":"",
"projection":"cce.bet_amount_converted"
},
{
"alias":"",
"projection":"cce.cont_amount_jackpot"
},
{
"alias":"",
"projection":"cce.base_currency"
}
],
"subselects":[],
"actual_row_count":{ "value":300, "avg":18.750000, "stddev":72.618438, "max":300, "maxPartition":1 },
"actual_total_time":{ "value":19, "avg":9.500000, "stddev":9.500000, "max":19, "maxPartition":0 },
"start_time":{ "value":111, "avg":111.000000, "stddev":0.000000, "max":111, "maxPartition":1 },
"network_traffic":{ "value":14225, "avg":14225.000000, "stddev":0.000000, "max":14225, "maxPartition":1 },
"network_time":{ "value":0, "avg":0.000000, "stddev":0.000000, "max":0, "maxPartition":0 },
"inputs":[
{
"executor":"Top",
"limit":"?",
"actual_row_count":{ "value":305, "avg":19.062500, "stddev":72.539187, "max":300, "maxPartition":1 },
"actual_total_time":{ "value":0, "avg":0.000000, "stddev":0.000000, "max":0, "maxPartition":0 },
"inputs":[
{
"executor":"Filter",
"condition":[
"cce.game_id IN (...) AND cce.action IN (...) AND cce.event_arrival_time >= ? AND cce.event_arrival_time <= ? AND cce.status = ?"
],
"subselects":[],
"actual_row_count":{ "value":6589, "avg":411.812500, "stddev":734.318410, "max":2325, "maxPartition":7 },
"actual_total_time":{ "value":61, "avg":56.500000, "stddev":4.500000, "max":61, "maxPartition":0 },
"start_time":{ "value":28, "avg":29.833333, "stddev":0.000000, "max":34, "maxPartition":7 },
"inputs":[
{
"executor":"ColumnStoreScan",
"db":"contribution",
"table":"cont_event",
"alias":"cce",
"index":"KEY operator_id (event_arrival_time, action, operator_id, game_id, correlation_id) USING CLUSTERED COLUMNSTORE",
"storage":"columnar",
"est_table_rows":"277429341",
"est_filtered":"1",
"actual_row_count":{ "value":6462216, "avg":403888.500000, "stddev":143995.817952, "max":596016, "maxPartition":4 },
"actual_total_time":{ "value":49, "avg":44.500000, "stddev":4.500000, "max":49, "maxPartition":8 },
"start_time":{ "value":27, "avg":44.625000, "stddev":0.000000, "max":70, "maxPartition":14 },
"memory_usage":{ "value":13107200, "avg":819200.000000, "stddev":283779.204312, "max":1310720, "maxPartition":4 },
"segments_scanned":{ "value":20, "avg":1.250000, "stddev":0.433013, "max":2, "maxPartition":4 },
"segments_skipped":{ "value":268, "avg":16.750000, "stddev":0.433013, "max":17, "maxPartition":0 },
"segments_fully_contained":{ "value":0, "avg":0.000000, "stddev":0.000000, "max":0, "maxPartition":0 },
"segments_filter_encoded_data":{ "value":18, "avg":1.125000, "stddev":0.330719, "max":2, "maxPartition":4 },
"inputs":[]
}
]
}
]
}
]
}
]
}
]
}
],
"version":"2",
"warning":"requires compile",
"info":{
"memsql_version":"6.8.11",
"memsql_version_hash":"e973c625ae6d372c2d41d39b19612202c244fd7a",
"num_online_leaves":"2",
"num_online_aggs":"1",
"context_database":"contribution"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment