                                                                      QUERY PLAN                                                                       
-------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=359605.92..359606.17 rows=100 width=117)
   ->  Sort  (cost=359605.92..359607.54 rows=648 width=117)
         Sort Key: (substr((warehouse.w_warehouse_name)::text, 1, 20)), ship_mode.sm_type, call_center.cc_name
         ->  HashAggregate  (cost=359573.06..359581.16 rows=648 width=117)
               Group Key: substr((warehouse.w_warehouse_name)::text, 1, 20), ship_mode.sm_type, call_center.cc_name
               ->  Hash Join  (cost=5.65..355308.62 rows=71074 width=85)
                     Hash Cond: (catalog_sales.cs_warehouse_sk = warehouse.w_warehouse_sk)
                     ->  Hash Join  (cost=4.42..354863.09 rows=71450 width=57)
                           Hash Cond: (catalog_sales.cs_call_center_sk = call_center.cc_call_center_sk)
                           ->  Hash Join  (cost=1.89..354638.91 rows=71816 width=47)
                                 Hash Cond: (catalog_sales.cs_ship_mode_sk = ship_mode.sm_ship_mode_sk)
                                 ->  Nested Loop  (cost=0.43..354407.98 rows=72201 width=20)
                                       ->  Seq Scan on date_dim  (cost=0.00..2500.73 rows=368 width=4)
                                             Filter: ((d_month_seq >= 1188) AND (d_month_seq <= 1199))
                                       ->  Index Scan using catalog_sales_cs_ship_date_sk_idx on catalog_sales  (cost=0.43..881.31 rows=7496 width=20)
                                             Index Cond: (cs_ship_date_sk = date_dim.d_date_sk)
                                 ->  Hash  (cost=1.20..1.20 rows=20 width=35)
                                       ->  Seq Scan on ship_mode  (cost=0.00..1.20 rows=20 width=35)
                           ->  Hash  (cost=2.24..2.24 rows=24 width=18)
                                 ->  Seq Scan on call_center  (cost=0.00..2.24 rows=24 width=18)
                     ->  Hash  (cost=1.10..1.10 rows=10 width=21)
                           ->  Seq Scan on warehouse  (cost=0.00..1.10 rows=10 width=21)
(22 rows)

