=============================================================================
|ID|OPERATOR                 |NAME                    |EST.ROWS|EST.TIME(us)|
-----------------------------------------------------------------------------
|0 |HASH UNION DISTINCT      |                        |560     |49032       |
|1 |├─NESTED-LOOP JOIN       |                        |179     |40076       |
|2 |│ ├─HASH JOIN            |                        |561     |29852       |
|3 |│ │ ├─TABLE FULL SCAN    |afsc                    |1431    |17527       |
|4 |│ │ └─TABLE FULL SCAN    |afih                    |16105   |4093        |
|5 |│ └─DISTRIBUTED TABLE GET|psi                     |1       |18          |
|6 |└─HASH OUTER JOIN        |                        |381     |8818        |
|7 |  ├─PX COORDINATOR       |                        |381     |3125        |
|8 |  │ └─EXCHANGE OUT DISTR |:EX10000                |381     |2909        |
|9 |  │   └─TABLE RANGE SCAN |wsspp(idx_store_acct_id)|381     |2422        |
|10|  └─TABLE FULL SCAN      |afih                    |39827   |1946        |
=============================================================================
Outputs & filters:
-------------------------------------
  0 - output([UNION([1])]), filter(nil), rowset=256
  1 - output([afih.id]), filter(nil), rowset=256
      conds(nil), nl_params_([afih.prod_s_id(:0)]), use_batch=true
  2 - output([afih.prod_s_id], [afih.id]), filter(nil), rowset=256
      equal_conds([afih.sales_site = afsc.sales_site], [afih.seller_sku = cast(afsc.seller_sku, VARCHAR(1048576))]), other_conds(nil)
  3 - output([afsc.sales_site], [afsc.seller_sku]), filter([afsc.thirty_daily_sales > 0], [afsc.store_acct_id = 35146]), rowset=256
      access([afsc.store_acct_id], [afsc.sales_site], [afsc.seller_sku], [afsc.thirty_daily_sales]), partitions(p0)
      is_index_back=false, is_global_index=false, filter_before_indexback[false,false], 
      range_key([afsc.id]), range(MIN ; MAX)always true
  4 - output([afih.id], [afih.prod_s_id], [afih.sales_site], [afih.seller_sku]), filter([afih.store_acct_id = 35146]), rowset=256
      access([afih.id], [afih.prod_s_id], [afih.store_acct_id], [afih.sales_site], [afih.seller_sku]), partitions(p0)
      is_index_back=false, is_global_index=false, filter_before_indexback[false], 
      range_key([afih.id]), range(MIN ; MAX)always true
  5 - output(nil), filter(nil), rowset=256
      access([GROUP_ID]), partitions(p0)
      is_index_back=false, is_global_index=false, 
      range_key([psi.id]), range(MIN ; MAX), 
      range_cond([:0 = psi.id])
  6 - output([afih.id]), filter(nil), rowset=256
      equal_conds([cast(wsspp.seller_sku_id, DECIMAL(-1, -1)) = cast(afih.id, DECIMAL(11, 0))]), other_conds(nil)
  7 - output([wsspp.seller_sku_id]), filter(nil), rowset=256
  8 - output([wsspp.seller_sku_id]), filter(nil), rowset=256
      is_single, dop=1
  9 - output([wsspp.seller_sku_id]), filter([wsspp.stock_refresh_time > date_sub(current_timestamp(), cast(1, VARCHAR(1048576)), 6)]), rowset=256
      access([wsspp.id], [wsspp.seller_sku_id], [wsspp.stock_refresh_time]), partitions(p0)
      is_index_back=true, is_global_index=false, filter_before_indexback[false], 
      range_key([wsspp.store_acct_id], [wsspp.id]), range(35146,MIN ; 35146,MAX), 
      range_cond([wsspp.store_acct_id = 35146])
 10 - output([afih.id]), filter(nil), rowset=256
      access([afih.id]), partitions(p0)
      is_index_back=false, is_global_index=false, 
      range_key([afih.id]), range(MIN ; MAX)always true