============================================================================================== |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| ---------------------------------------------------------------------------------------------- |0 |EXCHANGE IN REMOTE | |8 |232 | |1 |└─EXCHANGE OUT REMOTE | |8 |228 | |2 | └─SUBPLAN FILTER | |8 |218 | |3 | ├─TABLE RANGE SCAN |a(ob_orgid_0081_ob_enddate_0081)|8 |38 | |4 | └─DISTRIBUTED TABLE RANGE SCAN|ctb_quotation(TradeDate,Reverse)|1 |23 | ============================================================================================== Outputs & filters: ------------------------------------- 0 - output([DATE_FORMAT(a.ob_enddate_0081, '%Y-%m-%d')], [a.f001n_0081], [ROUND(cast(subquery(1), DOUBLE(-1, -1)), 2)]), filter(nil) 1 - output([DATE_FORMAT(a.ob_enddate_0081, '%Y-%m-%d')], [a.f001n_0081], [ROUND(cast(subquery(1), DOUBLE(-1, -1)), 2)]), filter(nil) 2 - output([DATE_FORMAT(a.ob_enddate_0081, '%Y-%m-%d')], [a.f001n_0081], [ROUND(cast(subquery(1), DOUBLE(-1, -1)), 2)]), filter(nil), rowset=16 exec_params_([a.ob_enddate_0081(:0)]), onetime_exprs_(nil), init_plan_idxs_(nil), use_batch=false 3 - output([a.f001n_0081], [a.ob_enddate_0081]), filter([a.f001n_0081 IS NOT NULL]), rowset=16 access([a.ID], [a.f001n_0081], [a.ob_enddate_0081]), partitions(p0) is_index_back=true, is_global_index=false, filter_before_indexback[false], range_key([a.ob_orgid_0081], [a.ob_enddate_0081], [a.shadow_pk_0]), range(873843,MIN,MIN ; 873843,MAX,MAX), range_cond([a.ob_orgid_0081 = '873843']) 4 - output([ctb_quotation.ClosePrice]), filter([ctb_quotation.Stockcode = '873843'], [cast(ctb_quotation.ClosePrice, DOUBLE(-1, -1)) != cast('', DOUBLE(-1, -1))]), rowset=16 access([ctb_quotation.ID], [ctb_quotation.Stockcode], [ctb_quotation.ClosePrice]), partitions(p0) limit(1), offset(nil), is_index_back=true, is_global_index=false, filter_before_indexback[false,false], range_key([ctb_quotation.TradeDate], [ctb_quotation.ID]), range(MIN,MIN ; MAX,MAX)always true, range_cond([ctb_quotation.TradeDate <= cast(:0, DATETIME(-1, -1))])