============================================================================================================= |ID|OPERATOR |NAME |EST.ROWS|EST.TIME(us)| ------------------------------------------------------------------------------------------------------------- |0 |HASH JOIN | |37 |100059 | |1 |©À©¤HASH JOIN | |3 |443 | |2 |©¦ ©À©¤HASH JOIN | |3 |19 | |3 |©¦ ©¦ ©À©¤SUBPLAN SCAN |b |3 |8 | |4 |©¦ ©¦ ©¦ ©¸©¤HASH GROUP BY | |3 |8 | |5 |©¦ ©¦ ©¦ ©¸©¤TABLE FULL SCAN |dlog |10 |6 | |6 |©¦ ©¦ ©¸©¤TABLE FULL SCAN |a |10 |7 | |7 |©¦ ©¸©¤PX COORDINATOR | |36 |413 | |8 |©¦ ©¸©¤EXCHANGE OUT DISTR |:EX10000 |36 |290 | |9 |©¦ ©¸©¤TABLE FULL SCAN |s2 |36 |15 | |10|©¸©¤SUBPLAN SCAN |s1 |718 |99421 | |11| ©¸©¤MERGE GROUP BY | |718 |99419 | |12| ©¸©¤PARTITION SORT | |718 |98384 | |13| ©¸©¤SUBPLAN SCAN |tem |718 |97315 | |14| ©¸©¤HASH DISTINCT | |718 |97313 | |15| ©¸©¤HASH RIGHT OUTER JOIN | |718 |96304 | |16| ©À©¤TABLE FULL SCAN |l |5 |4 | |17| ©¸©¤HASH RIGHT OUTER JOIN | |718 |96217 | |18| ©À©¤PX COORDINATOR | |479 |741 | |19| ©¦ ©¸©¤EXCHANGE OUT DISTR |:EX20000 |479 |522 | |20| ©¦ ©¸©¤TABLE FULL SCAN |t2 |479 |32 | |21| ©¸©¤NESTED-LOOP JOIN | |718 |95271 | |22| ©À©¤HASH RIGHT OUTER JOIN | |718 |21172 | |23| ©¦ ©À©¤PX COORDINATOR | |103 |143 | |24| ©¦ ©¦ ©¸©¤EXCHANGE OUT DISTR |:EX30000 |103 |101 | |25| ©¦ ©¦ ©¸©¤TABLE FULL SCAN |m |103 |9 | |26| ©¦ ©¸©¤HASH RIGHT OUTER JOIN | |718 |20788 | |27| ©¦ ©À©¤PX COORDINATOR | |479 |1272 | |28| ©¦ ©¦ ©¸©¤EXCHANGE OUT DISTR |:EX40000 |479 |895 | |29| ©¦ ©¦ ©¸©¤TABLE FULL SCAN |t1 |479 |47 | |30| ©¦ ©¸©¤HASH JOIN | |718 |19278 | |31| ©¦ ©À©¤PX COORDINATOR | |26 |170 | |32| ©¦ ©¦ ©¸©¤EXCHANGE OUT DISTR |:EX50000 |26 |149 | |33| ©¦ ©¦ ©¸©¤HASH JOIN | |26 |100 | |34| ©¦ ©¦ ©À©¤SUBPLAN SCAN |b |26 |36 | |35| ©¦ ©¦ ©¦ ©¸©¤HASH GROUP BY | |26 |36 | |36| ©¦ ©¦ ©¦ ©¸©¤TABLE FULL SCAN |t_task |121 |18 | |37| ©¦ ©¦ ©¸©¤TABLE FULL SCAN |a |121 |19 | |38| ©¦ ©¸©¤TABLE FULL SCAN |tem |34362 |3583 | |39| ©¸©¤SUBPLAN SCAN |B |1 |103 | |40| ©¸©¤NESTED-LOOP JOIN | |1 |103 | |41| ©À©¤NESTED-LOOP JOIN | |1 |85 | |42| ©¦ ©À©¤NESTED-LOOP JOIN | |1 |66 | |43| ©¦ ©¦ ©À©¤NESTED-LOOP JOIN | |1 |39 | |44| ©¦ ©¦ ©¦ ©À©¤DISTRIBUTED TABLE GET |C |1 |21 | |45| ©¦ ©¦ ©¦ ©¸©¤DISTRIBUTED TABLE GET |F |1 |18 | |46| ©¦ ©¦ ©¸©¤DISTRIBUTED TABLE RANGE SCAN|sr(idx_s_id) |2 |27 | |47| ©¦ ©¸©¤DISTRIBUTED TABLE GET |D |1 |18 | |48| ©¸©¤DISTRIBUTED TABLE GET |dai |1 |18 | =============================================================================================================