QUERY PLAN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Merge Join  (cost=70681875.19..70681875.25 rows=1 width=228)
   Output: wswscs.d_week_seq, round((wswscs.sun_sales / wswscs_1.sun_sales), 2), round((wswscs.mon_sales / wswscs_1.mon_sales), 2), round((wswscs.tue_sales / wswscs_1.tue_sales), 2), round((wswscs.wed_sales / wswscs_1.wed_sales), 2), round((wswscs.thu_sales / wswscs_1.thu_sales), 2), round((wswscs.fri_sales / wswscs_1.fri_sales), 2), round((wswscs.sat_sales / wswscs_1.sat_sales), 2)
   Merge Cond: (date_dim.d_week_seq = ((wswscs_1.d_week_seq - 53)))
   CTE wswscs
     ->  Finalize GroupAggregate  (cost=60952324.58..70680200.19 rows=5047 width=228)
           Output: date_dim_2.d_week_seq, sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Sunday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Monday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Tuesday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Wednesday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Thursday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Friday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Saturday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END)
           Group Key: date_dim_2.d_week_seq
           ->  Gather Merge  (cost=60952324.58..70679682.87 rows=10094 width=228)
                 Output: date_dim_2.d_week_seq, (PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Sunday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END)), (PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Monday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END)), (PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Tuesday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END)), (PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Wednesday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END)), (PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Thursday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END)), (PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Friday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END)), (PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Saturday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END))
                 Workers Planned: 2
                 ->  Partial GroupAggregate  (cost=60951324.56..70677517.75 rows=5047 width=228)
                       Output: date_dim_2.d_week_seq, PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Sunday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Monday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Tuesday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Wednesday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Thursday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Friday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END), PARTIAL sum(CASE WHEN ((date_dim_2.d_day_name)::text = 'Saturday'::text) THEN catalog_sales.cs_ext_sales_price ELSE NULL::numeric END)
                       Group Key: date_dim_2.d_week_seq
                       ->  Sort  (cost=60951324.56..61559202.96 rows=243151360 width=18)
                             Output: date_dim_2.d_week_seq, date_dim_2.d_day_name, catalog_sales.cs_ext_sales_price
                             Sort Key: date_dim_2.d_week_seq
                             ->  Hash Join  (cost=1070.88..12124140.17 rows=243151360 width=18)
                                   Output: date_dim_2.d_week_seq, date_dim_2.d_day_name, catalog_sales.cs_ext_sales_price
                                   Inner Unique: true
                                   Hash Cond: (catalog_sales.cs_sold_date_sk = date_dim_2.d_date_sk)
                                   ->  Parallel Append  (cost=0.00..11484720.40 rows=243151360 width=10)
                                         ->  Parallel Seq Scan on tpcds.catalog_sales  (cost=0.00..6836073.13 rows=162162413 width=10)
                                               Output: catalog_sales.cs_ext_sales_price, catalog_sales.cs_sold_date_sk
                                         ->  Parallel Seq Scan on tpcds.web_sales  (cost=0.00..3432890.47 rows=80988947 width=10)
                                               Output: web_sales.ws_ext_sales_price, web_sales.ws_sold_date_sk
                                   ->  Hash  (cost=629.28..629.28 rows=35328 width=16)
                                         Output: date_dim_2.d_week_seq, date_dim_2.d_day_name, date_dim_2.d_date_sk
                                         ->  Seq Scan on tpcds.date_dim date_dim_2  (cost=0.00..629.28 rows=35328 width=16)
                                               Output: date_dim_2.d_week_seq, date_dim_2.d_day_name, date_dim_2.d_date_sk
   ->  Sort  (cost=837.50..837.50 rows=1 width=232)
         Output: wswscs.d_week_seq, wswscs.sun_sales, wswscs.mon_sales, wswscs.tue_sales, wswscs.wed_sales, wswscs.thu_sales, wswscs.fri_sales, wswscs.sat_sales, date_dim.d_week_seq
         Sort Key: wswscs.d_week_seq
         ->  Hash Join  (cost=717.61..837.49 rows=1 width=232)
               Output: wswscs.d_week_seq, wswscs.sun_sales, wswscs.mon_sales, wswscs.tue_sales, wswscs.wed_sales, wswscs.thu_sales, wswscs.fri_sales, wswscs.sat_sales, date_dim.d_week_seq
               Hash Cond: (wswscs.d_week_seq = date_dim.d_week_seq)
               ->  CTE Scan on wswscs  (cost=0.00..100.94 rows=5047 width=228)
                     Output: wswscs.d_week_seq, wswscs.sun_sales, wswscs.mon_sales, wswscs.tue_sales, wswscs.wed_sales, wswscs.thu_sales, wswscs.fri_sales, wswscs.sat_sales
               ->  Hash  (cost=717.60..717.60 rows=1 width=4)
                     Output: date_dim.d_week_seq
                     ->  Seq Scan on tpcds.date_dim  (cost=0.00..717.60 rows=1 width=4)
                           Output: date_dim.d_week_seq
                           Filter: (date_dim.d_year = 2001)
   ->  Sort  (cost=837.50..837.50 rows=1 width=228)
         Output: wswscs_1.sun_sales, wswscs_1.mon_sales, wswscs_1.tue_sales, wswscs_1.wed_sales, wswscs_1.thu_sales, wswscs_1.fri_sales, wswscs_1.sat_sales, wswscs_1.d_week_seq, ((wswscs_1.d_week_seq - 53))
         Sort Key: ((wswscs_1.d_week_seq - 53))
         ->  Hash Join  (cost=717.61..837.49 rows=1 width=228)
               Output: wswscs_1.sun_sales, wswscs_1.mon_sales, wswscs_1.tue_sales, wswscs_1.wed_sales, wswscs_1.thu_sales, wswscs_1.fri_sales, wswscs_1.sat_sales, wswscs_1.d_week_seq, (wswscs_1.d_week_seq - 53)
               Hash Cond: (wswscs_1.d_week_seq = date_dim_1.d_week_seq)
               ->  CTE Scan on wswscs wswscs_1  (cost=0.00..100.94 rows=5047 width=228)
                     Output: wswscs_1.d_week_seq, wswscs_1.sun_sales, wswscs_1.mon_sales, wswscs_1.tue_sales, wswscs_1.wed_sales, wswscs_1.thu_sales, wswscs_1.fri_sales, wswscs_1.sat_sales
               ->  Hash  (cost=717.60..717.60 rows=1 width=4)
                     Output: date_dim_1.d_week_seq
                     ->  Seq Scan on tpcds.date_dim date_dim_1  (cost=0.00..717.60 rows=1 width=4)
                           Output: date_dim_1.d_week_seq
                           Filter: (date_dim_1.d_year = 2002)
 JIT:
   Functions: 45
   Options: Inlining true, Optimization true, Expressions true, Deforming true
(58 rows)