QUERY PLAN                                                                              
----------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=2839568.89..2839570.14 rows=100 width=110) (actual time=67158.490..67158.505 rows=100 loops=1)
   ->  Sort  (cost=2839568.89..2839569.73 rows=336 width=110) (actual time=67158.489..67158.497 rows=100 loops=1)
         Sort Key: (substr((web_sales.ws_ship_date_sk)::text, 1, 20)), warehouse.w_warehouse_name, ship_mode.sm_carrier
         Sort Method: top-N heapsort  Memory: 49kB
         ->  HashAggregate  (cost=2839550.59..2839554.79 rows=336 width=110) (actual time=67157.796..67157.885 rows=360 loops=1)
               Group Key: substr((web_sales.ws_ship_date_sk)::text, 1, 20), warehouse.w_warehouse_name, ship_mode.sm_carrier
               Batches: 1  Memory Usage: 157kB
               ->  Nested Loop  (cost=2505.85..2817452.89 rows=368295 width=78) (actual time=9.022..53310.759 rows=14336926 loops=1)
                     ->  Nested Loop  (cost=2505.70..2807569.94 rows=368356 width=36) (actual time=9.014..43690.253 rows=14337390 loops=1)
                           ->  Nested Loop  (cost=2505.55..2798567.14 rows=368430 width=33) (actual time=9.007..37393.316 rows=14338265 loops=1)
                                 ->  Hash Join  (cost=2505.41..2789674.19 rows=368516 width=20) (actual time=8.989..29175.630 rows=14340028 loops=1)
                                       Hash Cond: (web_sales.ws_ship_date_sk = date_dim.d_date_sk)
                                       ->  Seq Scan on web_sales  (cost=0.00..2598153.08 rows=72001808 width=20) (actual time=0.037..16320.734 rows=72001237 loops=1)
                                       ->  Hash  (cost=2500.73..2500.73 rows=374 width=4) (actual time=8.935..8.935 rows=365 loops=1)
                                             Buckets: 1024  Batches: 1  Memory Usage: 21kB
                                             ->  Seq Scan on date_dim  (cost=0.00..2500.73 rows=374 width=4) (actual time=4.243..8.882 rows=365 loops=1)
                                                   Filter: ((d_month_seq >= 1212) AND (d_month_seq <= 1223))
                                                   Rows Removed by Filter: 72684
                                 ->  Result Cache  (cost=0.15..0.16 rows=1 width=21) (actual time=0.000..0.000 rows=1 loops=14340028)
                                       Cache Key: web_sales.ws_warehouse_sk
                                       Hits: 14340012  Misses: 16  Evictions: 0  Overflows: 0  Memory Usage: 2kB
                                       ->  Index Scan using warehouse_pkey on warehouse  (cost=0.14..0.15 rows=1 width=21) (actual time=0.003..0.003 rows=1 loops=16)
                                             Index Cond: (w_warehouse_sk = web_sales.ws_warehouse_sk)
                           ->  Result Cache  (cost=0.15..0.17 rows=1 width=11) (actual time=0.000..0.000 rows=1 loops=14338265)
                                 Cache Key: web_sales.ws_web_site_sk
                                 Hits: 14338248  Misses: 17  Evictions: 0  Overflows: 0  Memory Usage: 2kB
                                 ->  Index Scan using web_site_pkey on web_site  (cost=0.14..0.16 rows=1 width=11) (actual time=0.002..0.002 rows=1 loops=17)
                                       Index Cond: (web_site_sk = web_sales.ws_web_site_sk)
                     ->  Result Cache  (cost=0.15..0.17 rows=1 width=35) (actual time=0.000..0.000 rows=1 loops=14337390)
                           Cache Key: web_sales.ws_ship_mode_sk
                           Hits: 14337369  Misses: 21  Evictions: 0  Overflows: 0  Memory Usage: 3kB
                           ->  Index Scan using ship_mode_pkey on ship_mode  (cost=0.14..0.16 rows=1 width=35) (actual time=0.002..0.002 rows=1 loops=21)
                                 Index Cond: (sm_ship_mode_sk = web_sales.ws_ship_mode_sk)
 Planning Time: 1.597 ms
 Execution Time: 67158.805 ms
(35 rows)

Time: 67161.202 ms (01:07.161)