==================================================================================================================================
|ID|OPERATOR                                                                   |NAME                       |EST.ROWS|EST.TIME(us)|
----------------------------------------------------------------------------------------------------------------------------------
|0 |HASH JOIN                                                                  |                           |1       |20413       |
|1 |©À©¤HASH JOIN                                                                |                           |1       |20405       |
|2 |©¦ ©À©¤PX COORDINATOR                                                         |                           |1       |20395       |
|3 |©¦ ©¦ ©¸©¤EXCHANGE OUT DISTR                                                   |:EX10002                   |1       |20395       |
|4 |©¦ ©¦   ©¸©¤HASH JOIN                                                          |                           |1       |20395       |
|5 |©¦ ©¦     ©À©¤SUBPLAN SCAN                                                     |s1                         |1       |20371       |
|6 |©¦ ©¦     ©¦ ©¸©¤MERGE GROUP BY                                                 |                           |1       |20371       |
|7 |©¦ ©¦     ©¦   ©¸©¤PARTITION SORT                                               |                           |1       |20371       |
|8 |©¦ ©¦     ©¦     ©¸©¤SUBPLAN SCAN                                               |tem                        |1       |20371       |
|9 |©¦ ©¦     ©¦       ©¸©¤HASH DISTINCT                                            |                           |1       |20371       |
|10|©¦ ©¦     ©¦         ©¸©¤NESTED-LOOP OUTER JOIN                                 |                           |1       |20371       |
|11|©¦ ©¦     ©¦           ©À©¤NESTED-LOOP JOIN                                     |                           |1       |20353       |
|12|©¦ ©¦     ©¦           ©¦ ©À©¤NESTED-LOOP JOIN                                   |                           |1       |20333       |
|13|©¦ ©¦     ©¦           ©¦ ©¦ ©À©¤NESTED-LOOP JOIN                                 |                           |1       |20314       |
|14|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©À©¤EXCHANGE IN DISTR                              |                           |1       |20282       |
|15|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦ ©¸©¤EXCHANGE OUT DISTR (BC2HOST)                 |:EX10001                   |1       |20282       |
|16|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦   ©¸©¤NESTED-LOOP OUTER JOIN                     |                           |1       |20282       |
|17|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©À©¤MERGE RIGHT OUTER JOIN                   |                           |1       |20255       |
|18|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦ ©À©¤TABLE FULL SCAN                        |l                          |5       |4           |
|19|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦ ©¸©¤SORT                                   |                           |1       |20250       |
|20|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦   ©¸©¤NESTED-LOOP OUTER JOIN               |                           |1       |20250       |
|21|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©À©¤NESTED-LOOP JOIN                   |                           |1       |20232       |
|22|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©À©¤NESTED-LOOP JOIN                 |                           |28      |19728       |
|23|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©À©¤SUBPLAN SCAN                   |A                          |28      |19225       |
|24|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¦ ©¸©¤HASH DISTINCT                |                           |28      |19224       |
|25|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¦   ©¸©¤HASH JOIN                  |                           |28      |19210       |
|26|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¦     ©À©¤EXCHANGE IN DISTR        |                           |1       |163         |
|27|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¦     ©¦ ©¸©¤EXCHANGE OUT DISTR     |:EX10000                   |1       |162         |
|28|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¦     ©¦   ©¸©¤SUBPLAN SCAN         |b                          |1       |160         |
|29|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¦     ©¦     ©¸©¤WINDOW FUNCTION    |                           |121     |159         |
|30|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¦     ©¦       ©¸©¤PARTITION SORT   |                           |121     |54          |
|31|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¦     ©¦         ©¸©¤TABLE FULL SCAN|t_task            				 |121     |19          |
|32|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¦     ©¸©¤TABLE FULL SCAN          |tem                        |34362   |3583        |
|33|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¦ ©¸©¤DISTRIBUTED TABLE GET          |C                          |1       |18          |
|34|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¦ ©¸©¤DISTRIBUTED TABLE GET            |F                          |1       |18          |
|35|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¦     ©¸©¤DISTRIBUTED TABLE GET              |t1                         |1       |18          |
|36|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¦     ©¸©¤DISTRIBUTED TABLE RANGE SCAN             |m(idx_r)        					 |2       |27          |
|37|©¦ ©¦     ©¦           ©¦ ©¦ ©¦ ©¸©¤TABLE RANGE SCAN                               |sr(idx_s_id)          		 |2       |32          |
|38|©¦ ©¦     ©¦           ©¦ ©¦ ©¸©¤DISTRIBUTED TABLE GET                            |dai                        |1       |18          |
|39|©¦ ©¦     ©¦           ©¦ ©¸©¤DISTRIBUTED TABLE GET                              |D                          |2       |20          |
|40|©¦ ©¦     ©¦           ©¸©¤DISTRIBUTED TABLE GET                                |t2                         |1       |18          |
|41|©¦ ©¦     ©¸©¤TABLE FULL SCAN                                                  |s2                         |36      |15          |
|42|©¦ ©¸©¤TABLE FULL SCAN                                                        |a                          |10      |7           |
|43|©¸©¤SUBPLAN SCAN                                                             |b                          |3       |8           |
|44|  ©¸©¤HASH GROUP BY                                                          |                           |3       |8           |
|45|    ©¸©¤TABLE FULL SCAN                                                      |dlog											 |10      |6           |
==================================================================================================================================