                                                                             QUERY PLAN                                                                              
---------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=27293603.90..27293603.91 rows=1 width=72)
   CTE ws_wh
     ->  Hash Join  (cost=377817.50..7260666.23 rows=426765799 width=12)
           Hash Cond: (ws1_1.ws_order_number = ws2.ws_order_number)
           Join Filter: (ws1_1.ws_warehouse_sk <> ws2.ws_warehouse_sk)
           ->  Seq Scan on web_sales ws1_1  (cost=0.00..259726.89 rows=7197889 width=8)
           ->  Hash  (cost=259726.89..259726.89 rows=7197889 width=8)
                 ->  Seq Scan on web_sales ws2  (cost=0.00..259726.89 rows=7197889 width=8)
   ->  Sort  (cost=20032937.67..20032937.68 rows=1 width=72)
         Sort Key: (count(DISTINCT ws1.ws_order_number))
         ->  Aggregate  (cost=20032937.65..20032937.66 rows=1 width=72)
               ->  Nested Loop Semi Join  (cost=9610131.56..20032937.63 rows=2 width=16)
                     Join Filter: (ws1.ws_order_number = web_returns.wr_order_number)
                     ->  Nested Loop  (cost=9604736.96..9884073.17 rows=2 width=20)
                           ->  Nested Loop  (cost=9604736.54..9883798.70 rows=619 width=24)
                                 Join Filter: (ws1.ws_web_site_sk = web_site.web_site_sk)
                                 ->  Hash Join  (cost=9604736.54..9883412.22 rows=3251 width=28)
                                       Hash Cond: (ws1.ws_order_number = ws_wh.ws_order_number)
                                       ->  Hash Join  (cost=2501.56..281124.01 rows=6502 width=24)
                                             Hash Cond: (ws1.ws_ship_date_sk = date_dim.d_date_sk)
                                             ->  Seq Scan on web_sales ws1  (cost=0.00..259726.89 rows=7197889 width=28)
                                             ->  Hash  (cost=2500.73..2500.73 rows=66 width=4)
                                                   ->  Seq Scan on date_dim  (cost=0.00..2500.73 rows=66 width=4)
                                                         Filter: ((d_date >= '2002-05-01'::date) AND (d_date <= '2002-06-30 00:00:00'::timestamp without time zone))
                                       ->  Hash  (cost=9602232.48..9602232.48 rows=200 width=4)
                                             ->  HashAggregate  (cost=9602230.48..9602232.48 rows=200 width=4)
                                                   Group Key: ws_wh.ws_order_number
                                                   ->  CTE Scan on ws_wh  (cost=0.00..8535315.98 rows=426765799 width=4)
                                 ->  Materialize  (cost=0.00..3.56 rows=8 width=4)
                                       ->  Seq Scan on web_site  (cost=0.00..3.52 rows=8 width=4)
                                             Filter: (web_company_name = 'pri'::bpchar)
                           ->  Index Scan using customer_address_pkey on customer_address  (cost=0.42..0.44 rows=1 width=4)
                                 Index Cond: (ca_address_sk = ws1.ws_ship_addr_sk)
                                 Filter: (ca_state = 'MA'::bpchar)
                     ->  Hash Join  (cost=5394.60..10141113.46 rows=2491 width=8)
                           Hash Cond: (ws_wh_1.ws_order_number = web_returns.wr_order_number)
                           Join Filter: (ws_wh.ws_order_number = ws_wh_1.ws_order_number)
                           ->  CTE Scan on ws_wh ws_wh_1  (cost=0.00..8535315.98 rows=426765799 width=4)
                           ->  Hash  (cost=5394.57..5394.57 rows=2 width=4)
                                 ->  Index Only Scan using web_returns_pkey on web_returns  (cost=0.42..5394.57 rows=2 width=4)
                                       Index Cond: (wr_order_number = ws_wh.ws_order_number)
(41 rows)

