Limit (cost=15600476.15..15600476.40 rows=100 width=88) -> Sort (cost=15600476.15..15600481.81 rows=2262 width=88) Sort Key: ('store channel'::text), (('store'::text || (ssr.s_store_id)::text)) -> MixedAggregate (cost=6712029.63..15600389.70 rows=2262 width=88) Hash Key: ('store channel'::text), (('store'::text || (ssr.s_store_id)::text)) Hash Key: ('store channel'::text) Group Key: () -> Append (cost=6712029.63..15599748.69 rows=20613 width=88) -> Subquery Scan on ssr (cost=6712029.63..6712531.30 rows=201 width=88) -> Finalize GroupAggregate (cost=6712029.63..6712528.29 rows=201 width=49) Group Key: store.s_store_id -> Gather Merge (cost=6712029.63..6712390.60 rows=10854 width=49) Workers Planned: 54 -> Partial GroupAggregate (cost=6712028.04..6712048.12 rows=201 width=49) Group Key: store.s_store_id -> Sort (cost=6712028.04..6712031.05 rows=1205 width=49) Sort Key: store.s_store_id -> Parallel Hash Join (cost=1960.47..6711966.37 rows=1205 width=49) Hash Cond: ("*SELECT* 1".store_sk = store.s_store_sk) -> Parallel Hash Join (cost=1943.30..6711944.48 rows=1205 width=36) Hash Cond: ("*SELECT* 1".date_sk = date_dim.d_date_sk) -> Parallel Append (cost=0.00..6629332.86 rows=5866729 width=40) -> Subquery Scan on "*SELECT* 1" (cost=0.00..6072030.64 rows=5333426 width=40) -> Parallel Seq Scan on store_sales (cost=0.00..5992029.26 rows=5333426 width=52) -> Subquery Scan on "*SELECT* 2" (cost=0.00..527968.57 rows=533303 width=40) -> Parallel Seq Scan on store_returns (cost=0.00..519969.03 rows=533303 width=52) -> Parallel Hash (cost=1943.29..1943.29 rows=1 width=4) -> Parallel Seq Scan on date_dim (cost=0.00..1943.29 rows=1 width=4) Filter: ((d_date >= '2000-08-27'::date) AND (d_date <= '2000-09-10'::date)) -> Parallel Hash (cost=17.07..17.07 rows=7 width=21) -> Parallel Seq Scan on store (cost=0.00..17.07 rows=7 width=21) -> Subquery Scan on csr (cost=4526646.86..4528599.23 rows=20400 width=88) -> Finalize GroupAggregate (cost=4526646.86..4528293.23 rows=20400 width=49) Group Key: catalog_page.cp_catalog_page_id -> Gather Merge (cost=4526646.86..4527682.88 rows=32508 width=49) Workers Planned: 54 -> Partial GroupAggregate (cost=4526645.27..4526660.32 rows=602 width=49) Group Key: catalog_page.cp_catalog_page_id -> Sort (cost=4526645.27..4526646.77 rows=602 width=49) Sort Key: catalog_page.cp_catalog_page_id -> Parallel Hash Join (cost=2401.81..4526617.48 rows=602 width=49) Hash Cond: ("*SELECT* 1_1".page_sk = catalog_page.cp_catalog_page_sk) -> Parallel Hash Join (cost=1943.30..4526156.60 rows=602 width=36) Hash Cond: ("*SELECT* 1_1".date_sk = date_dim_1.d_date_sk) -> Parallel Append (cost=0.00..4483880.33 rows=2933278 width=40) -> Subquery Scan on "*SELECT* 1_1" (cost=0.00..4146301.47 rows=2666699 width=40) -> Parallel Seq Scan on catalog_sales (cost=0.00..4106300.99 rows=2666699 width=52) -> Subquery Scan on "*SELECT* 2_1" (cost=0.00..322912.47 rows=266579 width=40) -> Parallel Seq Scan on catalog_returns (cost=0.00..318913.79 rows=266579 width=52) -> Parallel Hash (cost=1943.29..1943.29 rows=1 width=4) -> Parallel Seq Scan on date_dim date_dim_1 (cost=0.00..1943.29 rows=1 width=4) Filter: ((d_date >= '2000-08-27'::date) AND (d_date <= '2000-09-10'::date)) -> Parallel Hash (cost=453.78..453.78 rows=378 width=21) -> Parallel Seq Scan on catalog_page (cost=0.00..453.78 rows=378 width=21) -> Subquery Scan on wsr (cost=4358485.68..4358515.10 rows=12 width=88) -> Finalize GroupAggregate (cost=4358485.68..4358514.92 rows=12 width=49) Group Key: web_site.web_site_id -> Gather Merge (cost=4358485.68..4358506.70 rows=648 width=49) Workers Planned: 54 -> Partial GroupAggregate (cost=4358484.09..4358484.75 rows=12 width=49) Group Key: web_site.web_site_id -> Sort (cost=4358484.09..4358484.18 rows=36 width=49) Sort Key: web_site.web_site_id -> Parallel Hash Join (cost=1944.32..4358483.16 rows=36 width=49) Hash Cond: ("*SELECT* 2_2".wsr_web_site_sk = web_site.web_site_sk) -> Parallel Hash Join (cost=1943.30..4358481.00 rows=301 width=36) Hash Cond: ("*SELECT* 2_2".date_sk = date_dim_2.d_date_sk) -> Parallel Append (cost=0.00..4336368.29 rows=1466851 width=40) -> Subquery Scan on "*SELECT* 2_2" (cost=2089739.58..2239294.46 rows=133348 width=40) -> Parallel Hash Left Join (cost=2089739.58..2237294.24 rows=133348 width=52) Hash Cond: ((web_returns.wr_item_sk = web_sales.ws_item_sk) AND (web_returns.wr_order_number = web_sales.ws_order_number)) -> Parallel Seq Scan on web_returns (cost=0.00..142887.48 rows=133348 width=28) -> Parallel Hash (cost=2069737.03..2069737.03 rows=1333503 width=12) -> Parallel Seq Scan on web_sales (cost=0.00..2069737.03 rows=1333503 width=12) -> Subquery Scan on "*SELECT* 1_2" (cost=0.00..2089739.58 rows=1333503 width=40) -> Parallel Seq Scan on web_sales web_sales_1 (cost=0.00..2069737.03 rows=1333503 width=52) -> Parallel Hash (cost=1943.29..1943.29 rows=1 width=4) -> Parallel Seq Scan on date_dim date_dim_2 (cost=0.00..1943.29 rows=1 width=4) Filter: ((d_date >= '2000-08-27'::date) AND (d_date <= '2000-09-10'::date)) -> Parallel Hash (cost=1.00..1.00 rows=1 width=21) -> Parallel Seq Scan on web_site (cost=0.00..1.00 rows=1 width=21)