QUERY PLAN --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Finalize Aggregate (cost=1848031.51..1848031.52 rows=1 width=152) (actual time=8291.235..8291.235 rows=1 loops=1) Output: sum(lineitem_prt_23.l_linenumber), avg(lineitem_prt_23.l_linenumber), avg(lineitem_prt_23.l_quantity), avg(lineitem_prt_23.l_extendedprice), avg(lineitem_prt_23.l_discount), sum(CASE WHEN ((orders_prt_19.o_orderpriority = '1-URGENT'::bpchar) OR (orders_prt_19.o_orderpriority = '2-HIGH'::bpchar)) THEN 1 ELSE 0 END), sum(CASE WHEN ((orders_prt_19.o_orderpriority <> '1-URGENT'::bpchar) AND (orders_prt_19.o_orderpriority <> '2-HIGH'::bpchar)) THEN 1 ELSE 0 END) -> Gather (cost=1848030.74..1848031.35 rows=6 width=152) (actual time=8286.973..8304.944 rows=7 loops=1) Output: (PARTIAL sum(lineitem_prt_23.l_linenumber)), (PARTIAL avg(lineitem_prt_23.l_linenumber)), (PARTIAL avg(lineitem_prt_23.l_quantity)), (PARTIAL avg(lineitem_prt_23.l_extendedprice)), (PARTIAL avg(lineitem_prt_23.l_discount)), (PARTIAL sum(CASE WHEN ((orders_prt_19.o_orderpriority = '1-URGENT'::bpchar) OR (orders_prt_19.o_orderpriority = '2-HIGH'::bpchar)) THEN 1 ELSE 0 END)), (PARTIAL sum(CASE WHEN ((orders_prt_19.o_orderpriority <> '1-URGENT'::bpchar) AND (orders_prt_19.o_orderpriority <> '2-HIGH'::bpchar)) THEN 1 ELSE 0 END)) Workers Planned: 6 Workers Launched: 6 -> Partial Aggregate (cost=1847030.74..1847030.75 rows=1 width=152) (actual time=8233.930..8233.930 rows=1 loops=7) Output: PARTIAL sum(lineitem_prt_23.l_linenumber), PARTIAL avg(lineitem_prt_23.l_linenumber), PARTIAL avg(lineitem_prt_23.l_quantity), PARTIAL avg(lineitem_prt_23.l_extendedprice), PARTIAL avg(lineitem_prt_23.l_discount), PARTIAL sum(CASE WHEN ((orders_prt_19.o_orderpriority = '1-URGENT'::bpchar) OR (orders_prt_19.o_orderpriority = '2-HIGH'::bpchar)) THEN 1 ELSE 0 END), PARTIAL sum(CASE WHEN ((orders_prt_19.o_orderpriority <> '1-URGENT'::bpchar) AND (orders_prt_19.o_orderpriority <> '2-HIGH'::bpchar)) THEN 1 ELSE 0 END) Worker 0: actual time=8218.151..8218.151 rows=1 loops=1 Worker 1: actual time=8219.888..8219.888 rows=1 loops=1 Worker 2: actual time=8232.625..8232.625 rows=1 loops=1 Worker 3: actual time=8218.239..8218.239 rows=1 loops=1 Worker 4: actual time=8235.190..8235.190 rows=1 loops=1 Worker 5: actual time=8232.298..8232.298 rows=1 loops=1 -> Parallel Hash Join (cost=1493182.48..1845707.68 rows=48111 width=37) (actual time=6318.982..8189.512 rows=44656 loops=7) Output: lineitem_prt_23.l_linenumber, lineitem_prt_23.l_quantity, lineitem_prt_23.l_extendedprice, lineitem_prt_23.l_discount, orders_prt_19.o_orderpriority Hash Cond: (orders_prt_19.o_orderkey = lineitem_prt_23.l_orderkey) Worker 0: actual time=6308.181..8174.387 rows=53510 loops=1 Worker 1: actual time=6298.074..8194.775 rows=41531 loops=1 Worker 2: actual time=6312.769..8167.075 rows=44474 loops=1 Worker 3: actual time=6298.151..8173.567 rows=38796 loops=1 Worker 4: actual time=6324.487..8194.048 rows=41711 loops=1 Worker 5: actual time=6330.174..8201.139 rows=39245 loops=1 -> Parallel Append (cost=0.00..343070.00 rows=2500001 width=24) (actual time=0.021..1068.065 rows=2142857 loops=7) Worker 0: actual time=0.026..1055.706 rows=2570991 loops=1 Worker 1: actual time=0.021..1117.115 rows=1982487 loops=1 Worker 2: actual time=0.020..1119.378 rows=2143060 loops=1 Worker 3: actual time=0.024..1019.026 rows=1852490 loops=1 Worker 4: actual time=0.025..1082.680 rows=2010016 loops=1 Worker 5: actual time=0.024..1031.712 rows=1878197 loops=1 -> Parallel Seq Scan on public.orders_prt_19 (cost=0.00..10359.21 rows=195821 width=24) (actual time=0.023..212.275 rows=469970 loops=1) Output: orders_prt_19.o_orderpriority, orders_prt_19.o_orderkey Worker 3: actual time=0.023..212.275 rows=469970 loops=1 -> Parallel Seq Scan on public.orders_prt_23 (cost=0.00..10353.82 rows=195782 width=24) (actual time=0.019..129.244 rows=469876 loops=1) Output: orders_prt_23.o_orderpriority, orders_prt_23.o_orderkey Worker 2: actual time=0.019..129.244 rows=469876 loops=1 -> Parallel Seq Scan on public.orders_prt_8 (cost=0.00..10351.44 rows=195744 width=24) (actual time=0.020..187.365 rows=469786 loops=1) Output: orders_prt_8.o_orderpriority, orders_prt_8.o_orderkey Worker 1: actual time=0.020..187.365 rows=469786 loops=1 -> Parallel Seq Scan on public.orders_prt_17 (cost=0.00..10347.28 rows=195628 width=24) (actual time=0.022..120.398 rows=469507 loops=1) Output: orders_prt_17.o_orderpriority, orders_prt_17.o_orderkey Worker 0: actual time=0.022..120.398 rows=469507 loops=1 -> Parallel Seq Scan on public.orders_prt_9 (cost=0.00..10346.06 rows=195606 width=24) (actual time=0.021..211.906 rows=469454 loops=1) Output: orders_prt_9.o_orderpriority, orders_prt_9.o_orderkey Worker 4: actual time=0.021..211.906 rows=469454 loops=1 -> Parallel Seq Scan on public.orders_prt_21 (cost=0.00..10342.17 rows=195518 width=24) (actual time=0.023..194.941 rows=469242 loops=1) Output: orders_prt_21.o_orderpriority, orders_prt_21.o_orderkey Worker 5: actual time=0.023..194.941 rows=469242 loops=1 -> Parallel Seq Scan on public.orders_prt_18 (cost=0.00..10340.58 rows=195458 width=24) (actual time=0.026..226.315 rows=469098 loops=1) Output: orders_prt_18.o_orderpriority, orders_prt_18.o_orderkey Worker 0: actual time=0.026..226.315 rows=469098 loops=1 -> Parallel Seq Scan on public.orders_prt_3 (cost=0.00..10339.00 rows=195500 width=24) (actual time=0.025..195.223 rows=469199 loops=1) Output: orders_prt_3.o_orderpriority, orders_prt_3.o_orderkey Worker 2: actual time=0.025..195.223 rows=469199 loops=1 -> Parallel Seq Scan on public.orders_prt_22 (cost=0.00..10338.98 rows=195498 width=24) (actual time=0.028..197.891 rows=469195 loops=1) Output: orders_prt_22.o_orderpriority, orders_prt_22.o_orderkey Worker 3: actual time=0.028..197.891 rows=469195 loops=1 -> Parallel Seq Scan on public.orders_prt_11 (cost=0.00..10336.90 rows=195490 width=24) (actual time=0.019..158.856 rows=469176 loops=1) Output: orders_prt_11.o_orderpriority, orders_prt_11.o_orderkey Worker 1: actual time=0.019..158.856 rows=469176 loops=1 -> Parallel Seq Scan on public.orders_prt_24 (cost=0.00..10333.75 rows=195375 width=24) (actual time=0.028..125.197 rows=468900 loops=1) Output: orders_prt_24.o_orderpriority, orders_prt_24.o_orderkey Worker 4: actual time=0.028..125.197 rows=468900 loops=1 -> Parallel Seq Scan on public.orders_prt_28 (cost=0.00..10333.33 rows=195333 width=24) (actual time=0.027..166.603 rows=468799 loops=1) Output: orders_prt_28.o_orderpriority, orders_prt_28.o_orderkey Worker 5: actual time=0.027..166.603 rows=468799 loops=1 -> Parallel Seq Scan on public.orders_prt_1 (cost=0.00..10333.22 rows=195422 width=24) (actual time=0.027..179.282 rows=469012 loops=1) Output: orders_prt_1.o_orderpriority, orders_prt_1.o_orderkey Worker 2: actual time=0.027..179.282 rows=469012 loops=1 -> Parallel Seq Scan on public.orders_prt_13 (cost=0.00..10332.91 rows=195391 width=24) (actual time=0.025..163.508 rows=468939 loops=1) Output: orders_prt_13.o_orderpriority, orders_prt_13.o_orderkey Worker 0: actual time=0.025..163.508 rows=468939 loops=1 -> Parallel Seq Scan on public.orders_prt_12 (cost=0.00..10332.23 rows=195323 width=24) (actual time=0.026..205.367 rows=468775 loops=1) Output: orders_prt_12.o_orderpriority, orders_prt_12.o_orderkey Worker 4: actual time=0.026..205.367 rows=468775 loops=1 -> Parallel Seq Scan on public.orders_prt_25 (cost=0.00..10330.50 rows=195350 width=24) (actual time=0.021..206.590 rows=468840 loops=1) Output: orders_prt_25.o_orderpriority, orders_prt_25.o_orderkey Worker 1: actual time=0.021..206.590 rows=468840 loops=1 -> Parallel Seq Scan on public.orders_prt_29 (cost=0.00..10328.96 rows=195296 width=24) (actual time=0.028..186.116 rows=468711 loops=1) Output: orders_prt_29.o_orderpriority, orders_prt_29.o_orderkey Worker 5: actual time=0.028..186.116 rows=468711 loops=1 -> Parallel Seq Scan on public.orders_prt_20 (cost=0.00..10327.57 rows=195257 width=24) (actual time=0.021..178.884 rows=468617 loops=1) Output: orders_prt_20.o_orderpriority, orders_prt_20.o_orderkey Worker 3: actual time=0.021..178.884 rows=468617 loops=1 -> Parallel Seq Scan on public.orders_prt_10 (cost=0.00..10327.24 rows=195224 width=24) (actual time=0.027..157.358 rows=468538 loops=1) Output: orders_prt_10.o_orderpriority, orders_prt_10.o_orderkey Worker 0: actual time=0.027..157.358 rows=468538 loops=1 -> Parallel Seq Scan on public.orders_prt_0 (cost=0.00..10326.63 rows=195263 width=24) (actual time=0.026..183.058 rows=468632 loops=1) Output: orders_prt_0.o_orderpriority, orders_prt_0.o_orderkey Worker 2: actual time=0.026..183.058 rows=468632 loops=1 -> Parallel Seq Scan on public.orders_prt_16 (cost=0.00..10326.01 rows=195201 width=24) (actual time=0.027..255.008 rows=468482 loops=1) Output: orders_prt_16.o_orderpriority, orders_prt_16.o_orderkey Worker 4: actual time=0.027..255.008 rows=468482 loops=1 -> Parallel Seq Scan on public.orders_prt_6 (cost=0.00..10325.42 rows=195242 width=24) (actual time=0.022..110.162 rows=234290 loops=2) Output: orders_prt_6.o_orderpriority, orders_prt_6.o_orderkey Worker 0: actual time=0.020..3.825 rows=17372 loops=1 Worker 1: actual time=0.024..216.499 rows=451208 loops=1 -> Parallel Seq Scan on public.orders_prt_27 (cost=0.00..10325.32 rows=195132 width=24) (actual time=0.023..122.759 rows=234158 loops=2) Output: orders_prt_27.o_orderpriority, orders_prt_27.o_orderkey Worker 0: actual time=0.021..20.462 rows=98481 loops=1 Worker 3: actual time=0.026..225.056 rows=369835 loops=1 -> Parallel Seq Scan on public.orders_prt_2 (cost=0.00..10324.02 rows=195202 width=24) (actual time=0.027..118.881 rows=234243 loops=2) Output: orders_prt_2.o_orderpriority, orders_prt_2.o_orderkey Worker 1: actual time=0.025..30.169 rows=61877 loops=1 Worker 5: actual time=0.028..207.593 rows=406609 loops=1 -> Parallel Seq Scan on public.orders_prt_15 (cost=0.00..10323.85 rows=195185 width=24) (actual time=0.026..131.108 rows=468443 loops=1) Output: orders_prt_15.o_orderpriority, orders_prt_15.o_orderkey Worker 0: actual time=0.026..131.108 rows=468443 loops=1 -> Parallel Seq Scan on public.orders_prt_4 (cost=0.00..10323.09 rows=195209 width=24) (actual time=0.022..39.354 rows=78084 loops=6) Output: orders_prt_4.o_orderpriority, orders_prt_4.o_orderkey Worker 0: actual time=0.028..23.045 rows=110613 loops=1 Worker 1: actual time=0.023..32.435 rows=61600 loops=1 Worker 2: actual time=0.025..168.006 rows=266341 loops=1 Worker 3: actual time=0.021..6.735 rows=2023 loops=1 Worker 5: actual time=0.027..2.938 rows=14326 loops=1 -> Parallel Seq Scan on public.orders_prt_7 (cost=0.00..10321.29 rows=195129 width=24) (actual time=0.018..44.724 rows=117077 loops=4) Output: orders_prt_7.o_orderpriority, orders_prt_7.o_orderkey Worker 3: actual time=0.013..14.996 rows=72850 loops=1 Worker 4: actual time=0.026..73.752 rows=134405 loops=1 Worker 5: actual time=0.022..10.528 rows=50510 loops=1 -> Parallel Seq Scan on public.orders_prt_5 (cost=0.00..10317.45 rows=195045 width=24) (actual time=0.009..108.618 rows=468109 loops=1) Output: orders_prt_5.o_orderpriority, orders_prt_5.o_orderkey -> Parallel Seq Scan on public.orders_prt_14 (cost=0.00..10311.32 rows=194932 width=24) (actual time=0.008..125.199 rows=467836 loops=1) Output: orders_prt_14.o_orderpriority, orders_prt_14.o_orderkey -> Parallel Seq Scan on public.orders_prt_26 (cost=0.00..10310.82 rows=194982 width=24) (actual time=0.009..133.015 rows=467956 loops=1) Output: orders_prt_26.o_orderpriority, orders_prt_26.o_orderkey -> Parallel Seq Scan on public.orders_prt_30 (cost=0.00..10308.53 rows=194853 width=24) (actual time=0.008..172.444 rows=467647 loops=1) Output: orders_prt_30.o_orderpriority, orders_prt_30.o_orderkey -> Parallel Seq Scan on public.orders_prt_31 (cost=0.00..10291.12 rows=194612 width=24) (actual time=0.008..155.843 rows=467069 loops=1) Output: orders_prt_31.o_orderpriority, orders_prt_31.o_orderkey -> Parallel Hash (cost=1492581.10..1492581.10 rows=48111 width=29) (actual time=6310.727..6310.727 rows=44656 loops=7) Output: lineitem_prt_23.l_linenumber, lineitem_prt_23.l_quantity, lineitem_prt_23.l_extendedprice, lineitem_prt_23.l_discount, lineitem_prt_23.l_orderkey Buckets: 524288 Batches: 1 Memory Usage: 23744kB Worker 0: actual time=6297.835..6297.835 rows=53535 loops=1 Worker 1: actual time=6297.795..6297.795 rows=44930 loops=1 Worker 2: actual time=6312.325..6312.325 rows=42709 loops=1 Worker 3: actual time=6297.771..6297.772 rows=38138 loops=1 Worker 4: actual time=6314.257..6314.257 rows=45069 loops=1 Worker 5: actual time=6311.983..6311.983 rows=44806 loops=1 -> Parallel Append (cost=0.00..1492581.10 rows=48111 width=29) (actual time=0.131..6264.766 rows=44656 loops=7) Worker 0: actual time=0.054..6231.696 rows=53535 loops=1 Worker 1: actual time=0.035..6248.843 rows=44930 loops=1 Worker 2: actual time=0.094..6282.718 rows=42709 loops=1 Worker 3: actual time=0.077..6232.846 rows=38138 loops=1 Worker 4: actual time=0.212..6280.559 rows=45069 loops=1 Worker 5: actual time=0.167..6277.023 rows=44806 loops=1 -> Parallel Seq Scan on public.lineitem_prt_23 (cost=0.00..46766.35 rows=2216 width=29) (actual time=0.210..952.519 rows=9628 loops=1) Output: lineitem_prt_23.l_linenumber, lineitem_prt_23.l_quantity, lineitem_prt_23.l_extendedprice, lineitem_prt_23.l_discount, lineitem_prt_23.l_orderkey Filter: ((lineitem_prt_23.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_23.l_commitdate < lineitem_prt_23.l_receiptdate) AND (lineitem_prt_23.l_shipdate < lineitem_prt_23.l_commitdate) AND (lineitem_prt_23.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_23.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1870257 Worker 4: actual time=0.210..952.519 rows=9628 loops=1 -> Parallel Seq Scan on public.lineitem_prt_19 (cost=0.00..46741.40 rows=2335 width=29) (actual time=0.093..1243.797 rows=9972 loops=1) Output: lineitem_prt_19.l_linenumber, lineitem_prt_19.l_quantity, lineitem_prt_19.l_extendedprice, lineitem_prt_19.l_discount, lineitem_prt_19.l_orderkey Filter: ((lineitem_prt_19.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_19.l_commitdate < lineitem_prt_19.l_receiptdate) AND (lineitem_prt_19.l_shipdate < lineitem_prt_19.l_commitdate) AND (lineitem_prt_19.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_19.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1868855 Worker 2: actual time=0.093..1243.797 rows=9972 loops=1 -> Parallel Seq Scan on public.lineitem_prt_17 (cost=0.00..46733.69 rows=2349 width=29) (actual time=0.166..1133.392 rows=9871 loops=1) Output: lineitem_prt_17.l_linenumber, lineitem_prt_17.l_quantity, lineitem_prt_17.l_extendedprice, lineitem_prt_17.l_discount, lineitem_prt_17.l_orderkey Filter: ((lineitem_prt_17.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_17.l_commitdate < lineitem_prt_17.l_receiptdate) AND (lineitem_prt_17.l_shipdate < lineitem_prt_17.l_commitdate) AND (lineitem_prt_17.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_17.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1868474 Worker 5: actual time=0.166..1133.392 rows=9871 loops=1 -> Parallel Seq Scan on public.lineitem_prt_13 (cost=0.00..46707.68 rows=2244 width=29) (actual time=0.053..1643.150 rows=9737 loops=1) Output: lineitem_prt_13.l_linenumber, lineitem_prt_13.l_quantity, lineitem_prt_13.l_extendedprice, lineitem_prt_13.l_discount, lineitem_prt_13.l_orderkey Filter: ((lineitem_prt_13.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_13.l_commitdate < lineitem_prt_13.l_receiptdate) AND (lineitem_prt_13.l_shipdate < lineitem_prt_13.l_commitdate) AND (lineitem_prt_13.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_13.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1867718 Worker 0: actual time=0.053..1643.150 rows=9737 loops=1 -> Parallel Seq Scan on public.lineitem_prt_8 (cost=0.00..46702.87 rows=2216 width=29) (actual time=0.034..912.335 rows=9831 loops=1) Output: lineitem_prt_8.l_linenumber, lineitem_prt_8.l_quantity, lineitem_prt_8.l_extendedprice, lineitem_prt_8.l_discount, lineitem_prt_8.l_orderkey Filter: ((lineitem_prt_8.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_8.l_commitdate < lineitem_prt_8.l_receiptdate) AND (lineitem_prt_8.l_shipdate < lineitem_prt_8.l_commitdate) AND (lineitem_prt_8.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_8.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1867479 Worker 1: actual time=0.034..912.335 rows=9831 loops=1 -> Parallel Seq Scan on public.lineitem_prt_9 (cost=0.00..46700.28 rows=2261 width=29) (actual time=0.076..1493.591 rows=9838 loops=1) Output: lineitem_prt_9.l_linenumber, lineitem_prt_9.l_quantity, lineitem_prt_9.l_extendedprice, lineitem_prt_9.l_discount, lineitem_prt_9.l_orderkey Filter: ((lineitem_prt_9.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_9.l_commitdate < lineitem_prt_9.l_receiptdate) AND (lineitem_prt_9.l_shipdate < lineitem_prt_9.l_commitdate) AND (lineitem_prt_9.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_9.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1867368 Worker 3: actual time=0.076..1493.591 rows=9838 loops=1 -> Parallel Seq Scan on public.lineitem_prt_18 (cost=0.00..46694.57 rows=2272 width=29) (actual time=0.089..2349.084 rows=9811 loops=1) Output: lineitem_prt_18.l_linenumber, lineitem_prt_18.l_quantity, lineitem_prt_18.l_extendedprice, lineitem_prt_18.l_discount, lineitem_prt_18.l_orderkey Filter: ((lineitem_prt_18.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_18.l_commitdate < lineitem_prt_18.l_receiptdate) AND (lineitem_prt_18.l_shipdate < lineitem_prt_18.l_commitdate) AND (lineitem_prt_18.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_18.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1867090 Worker 1: actual time=0.089..2349.084 rows=9811 loops=1 -> Parallel Seq Scan on public.lineitem_prt_24 (cost=0.00..46676.51 rows=2264 width=29) (actual time=0.887..2268.638 rows=9555 loops=1) Output: lineitem_prt_24.l_linenumber, lineitem_prt_24.l_quantity, lineitem_prt_24.l_extendedprice, lineitem_prt_24.l_discount, lineitem_prt_24.l_orderkey Filter: ((lineitem_prt_24.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_24.l_commitdate < lineitem_prt_24.l_receiptdate) AND (lineitem_prt_24.l_shipdate < lineitem_prt_24.l_commitdate) AND (lineitem_prt_24.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_24.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1866802 Worker 4: actual time=0.887..2268.638 rows=9555 loops=1 -> Parallel Seq Scan on public.lineitem_prt_21 (cost=0.00..46671.74 rows=2248 width=29) (actual time=0.975..2169.380 rows=9849 loops=1) Output: lineitem_prt_21.l_linenumber, lineitem_prt_21.l_quantity, lineitem_prt_21.l_extendedprice, lineitem_prt_21.l_discount, lineitem_prt_21.l_orderkey Filter: ((lineitem_prt_21.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_21.l_commitdate < lineitem_prt_21.l_receiptdate) AND (lineitem_prt_21.l_shipdate < lineitem_prt_21.l_commitdate) AND (lineitem_prt_21.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_21.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1866193 Worker 5: actual time=0.975..2169.380 rows=9849 loops=1 -> Parallel Seq Scan on public.lineitem_prt_3 (cost=0.00..46670.84 rows=2232 width=29) (actual time=3.980..2466.125 rows=9719 loops=1) Output: lineitem_prt_3.l_linenumber, lineitem_prt_3.l_quantity, lineitem_prt_3.l_extendedprice, lineitem_prt_3.l_discount, lineitem_prt_3.l_orderkey Filter: ((lineitem_prt_3.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_3.l_commitdate < lineitem_prt_3.l_receiptdate) AND (lineitem_prt_3.l_shipdate < lineitem_prt_3.l_commitdate) AND (lineitem_prt_3.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_3.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1866342 Worker 2: actual time=3.980..2466.125 rows=9719 loops=1 -> Parallel Seq Scan on public.lineitem_prt_11 (cost=0.00..46658.98 rows=2329 width=29) (actual time=17.691..2354.138 rows=9951 loops=1) Output: lineitem_prt_11.l_linenumber, lineitem_prt_11.l_quantity, lineitem_prt_11.l_extendedprice, lineitem_prt_11.l_discount, lineitem_prt_11.l_orderkey Filter: ((lineitem_prt_11.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_11.l_commitdate < lineitem_prt_11.l_receiptdate) AND (lineitem_prt_11.l_shipdate < lineitem_prt_11.l_commitdate) AND (lineitem_prt_11.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_11.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1865601 Worker 3: actual time=17.691..2354.138 rows=9951 loops=1 -> Parallel Seq Scan on public.lineitem_prt_22 (cost=0.00..46657.65 rows=2274 width=29) (actual time=0.038..668.056 rows=9771 loops=1) Output: lineitem_prt_22.l_linenumber, lineitem_prt_22.l_quantity, lineitem_prt_22.l_extendedprice, lineitem_prt_22.l_discount, lineitem_prt_22.l_orderkey Filter: ((lineitem_prt_22.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_22.l_commitdate < lineitem_prt_22.l_receiptdate) AND (lineitem_prt_22.l_shipdate < lineitem_prt_22.l_commitdate) AND (lineitem_prt_22.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_22.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1865545 Worker 0: actual time=0.038..668.056 rows=9771 loops=1 -> Parallel Seq Scan on public.lineitem_prt_1 (cost=0.00..46646.26 rows=2190 width=29) (actual time=1.109..956.929 rows=9858 loops=1) Output: lineitem_prt_1.l_linenumber, lineitem_prt_1.l_quantity, lineitem_prt_1.l_extendedprice, lineitem_prt_1.l_discount, lineitem_prt_1.l_orderkey Filter: ((lineitem_prt_1.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_1.l_commitdate < lineitem_prt_1.l_receiptdate) AND (lineitem_prt_1.l_shipdate < lineitem_prt_1.l_commitdate) AND (lineitem_prt_1.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_1.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1865210 Worker 0: actual time=1.109..956.929 rows=9858 loops=1 -> Parallel Seq Scan on public.lineitem_prt_12 (cost=0.00..46643.33 rows=2319 width=29) (actual time=1.400..1274.470 rows=9899 loops=1) Output: lineitem_prt_12.l_linenumber, lineitem_prt_12.l_quantity, lineitem_prt_12.l_extendedprice, lineitem_prt_12.l_discount, lineitem_prt_12.l_orderkey Filter: ((lineitem_prt_12.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_12.l_commitdate < lineitem_prt_12.l_receiptdate) AND (lineitem_prt_12.l_shipdate < lineitem_prt_12.l_commitdate) AND (lineitem_prt_12.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_12.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1865004 Worker 4: actual time=1.400..1274.470 rows=9899 loops=1 -> Parallel Seq Scan on public.lineitem_prt_2 (cost=0.00..46643.03 rows=2208 width=29) (actual time=4.732..1368.053 rows=9625 loops=1) Output: lineitem_prt_2.l_linenumber, lineitem_prt_2.l_quantity, lineitem_prt_2.l_extendedprice, lineitem_prt_2.l_discount, lineitem_prt_2.l_orderkey Filter: ((lineitem_prt_2.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_2.l_commitdate < lineitem_prt_2.l_receiptdate) AND (lineitem_prt_2.l_shipdate < lineitem_prt_2.l_commitdate) AND (lineitem_prt_2.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_2.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1865224 Worker 1: actual time=4.732..1368.053 rows=9625 loops=1 -> Parallel Seq Scan on public.lineitem_prt_5 (cost=0.00..46636.07 rows=2254 width=29) (actual time=2.271..1238.292 rows=9575 loops=1) Output: lineitem_prt_5.l_linenumber, lineitem_prt_5.l_quantity, lineitem_prt_5.l_extendedprice, lineitem_prt_5.l_discount, lineitem_prt_5.l_orderkey Filter: ((lineitem_prt_5.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_5.l_commitdate < lineitem_prt_5.l_receiptdate) AND (lineitem_prt_5.l_shipdate < lineitem_prt_5.l_commitdate) AND (lineitem_prt_5.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_5.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1864927 Worker 0: actual time=2.271..1238.292 rows=9575 loops=1 -> Parallel Seq Scan on public.lineitem_prt_10 (cost=0.00..46632.70 rows=2264 width=29) (actual time=0.188..1189.879 rows=9730 loops=1) Output: lineitem_prt_10.l_linenumber, lineitem_prt_10.l_quantity, lineitem_prt_10.l_extendedprice, lineitem_prt_10.l_discount, lineitem_prt_10.l_orderkey Filter: ((lineitem_prt_10.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_10.l_commitdate < lineitem_prt_10.l_receiptdate) AND (lineitem_prt_10.l_shipdate < lineitem_prt_10.l_commitdate) AND (lineitem_prt_10.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_10.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1864528 Worker 5: actual time=0.188..1189.879 rows=9730 loops=1 -> Parallel Seq Scan on public.lineitem_prt_29 (cost=0.00..46630.93 rows=2216 width=29) (actual time=0.164..987.497 rows=9793 loops=1) Output: lineitem_prt_29.l_linenumber, lineitem_prt_29.l_quantity, lineitem_prt_29.l_extendedprice, lineitem_prt_29.l_discount, lineitem_prt_29.l_orderkey Filter: ((lineitem_prt_29.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_29.l_commitdate < lineitem_prt_29.l_receiptdate) AND (lineitem_prt_29.l_shipdate < lineitem_prt_29.l_commitdate) AND (lineitem_prt_29.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_29.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1864684 Worker 2: actual time=0.164..987.497 rows=9793 loops=1 -> Parallel Seq Scan on public.lineitem_prt_7 (cost=0.00..46627.35 rows=2220 width=29) (actual time=0.139..1210.634 rows=9603 loops=1) Output: lineitem_prt_7.l_linenumber, lineitem_prt_7.l_quantity, lineitem_prt_7.l_extendedprice, lineitem_prt_7.l_discount, lineitem_prt_7.l_orderkey Filter: ((lineitem_prt_7.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_7.l_commitdate < lineitem_prt_7.l_receiptdate) AND (lineitem_prt_7.l_shipdate < lineitem_prt_7.l_commitdate) AND (lineitem_prt_7.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_7.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1864593 Worker 3: actual time=0.139..1210.634 rows=9603 loops=1 -> Parallel Seq Scan on public.lineitem_prt_28 (cost=0.00..46621.98 rows=2201 width=29) (actual time=0.218..1212.274 rows=9894 loops=1) Output: lineitem_prt_28.l_linenumber, lineitem_prt_28.l_quantity, lineitem_prt_28.l_extendedprice, lineitem_prt_28.l_discount, lineitem_prt_28.l_orderkey Filter: ((lineitem_prt_28.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_28.l_commitdate < lineitem_prt_28.l_receiptdate) AND (lineitem_prt_28.l_shipdate < lineitem_prt_28.l_commitdate) AND (lineitem_prt_28.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_28.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1864058 Worker 4: actual time=0.218..1212.274 rows=9894 loops=1 -> Parallel Seq Scan on public.lineitem_prt_15 (cost=0.00..46612.80 rows=2268 width=29) (actual time=0.250..1239.148 rows=9730 loops=1) Output: lineitem_prt_15.l_linenumber, lineitem_prt_15.l_quantity, lineitem_prt_15.l_extendedprice, lineitem_prt_15.l_discount, lineitem_prt_15.l_orderkey Filter: ((lineitem_prt_15.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_15.l_commitdate < lineitem_prt_15.l_receiptdate) AND (lineitem_prt_15.l_shipdate < lineitem_prt_15.l_commitdate) AND (lineitem_prt_15.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_15.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1863834 Worker 5: actual time=0.250..1239.148 rows=9730 loops=1 -> Parallel Seq Scan on public.lineitem_prt_0 (cost=0.00..46610.67 rows=2298 width=29) (actual time=0.065..1053.506 rows=9779 loops=1) Output: lineitem_prt_0.l_linenumber, lineitem_prt_0.l_quantity, lineitem_prt_0.l_extendedprice, lineitem_prt_0.l_discount, lineitem_prt_0.l_orderkey Filter: ((lineitem_prt_0.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_0.l_commitdate < lineitem_prt_0.l_receiptdate) AND (lineitem_prt_0.l_shipdate < lineitem_prt_0.l_commitdate) AND (lineitem_prt_0.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_0.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1863763 Worker 0: actual time=0.065..1053.506 rows=9779 loops=1 -> Parallel Seq Scan on public.lineitem_prt_25 (cost=0.00..46609.91 rows=2253 width=29) (actual time=0.139..886.545 rows=9797 loops=1) Output: lineitem_prt_25.l_linenumber, lineitem_prt_25.l_quantity, lineitem_prt_25.l_extendedprice, lineitem_prt_25.l_discount, lineitem_prt_25.l_orderkey Filter: ((lineitem_prt_25.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_25.l_commitdate < lineitem_prt_25.l_receiptdate) AND (lineitem_prt_25.l_shipdate < lineitem_prt_25.l_commitdate) AND (lineitem_prt_25.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_25.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1863610 Worker 1: actual time=0.139..886.545 rows=9797 loops=1 -> Parallel Seq Scan on public.lineitem_prt_26 (cost=0.00..46605.04 rows=2218 width=29) (actual time=0.029..552.519 rows=4898 loops=2) Output: lineitem_prt_26.l_linenumber, lineitem_prt_26.l_quantity, lineitem_prt_26.l_extendedprice, lineitem_prt_26.l_discount, lineitem_prt_26.l_orderkey Filter: ((lineitem_prt_26.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_26.l_commitdate < lineitem_prt_26.l_receiptdate) AND (lineitem_prt_26.l_shipdate < lineitem_prt_26.l_commitdate) AND (lineitem_prt_26.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_26.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 931728 Worker 2: actual time=0.029..1087.781 rows=9531 loops=1 Worker 5: actual time=0.030..17.257 rows=264 loops=1 -> Parallel Seq Scan on public.lineitem_prt_27 (cost=0.00..46596.72 rows=2273 width=29) (actual time=0.073..608.313 rows=4908 loops=2) Output: lineitem_prt_27.l_linenumber, lineitem_prt_27.l_quantity, lineitem_prt_27.l_extendedprice, lineitem_prt_27.l_discount, lineitem_prt_27.l_orderkey Filter: ((lineitem_prt_27.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_27.l_commitdate < lineitem_prt_27.l_receiptdate) AND (lineitem_prt_27.l_shipdate < lineitem_prt_27.l_commitdate) AND (lineitem_prt_27.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_27.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 931600 Worker 3: actual time=0.037..946.834 rows=7045 loops=1 Worker 5: actual time=0.110..269.793 rows=2771 loops=1 -> Parallel Seq Scan on public.lineitem_prt_16 (cost=0.00..46577.84 rows=2290 width=29) (actual time=0.042..407.437 rows=3233 loops=3) Output: lineitem_prt_16.l_linenumber, lineitem_prt_16.l_quantity, lineitem_prt_16.l_extendedprice, lineitem_prt_16.l_discount, lineitem_prt_16.l_orderkey Filter: ((lineitem_prt_16.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_16.l_commitdate < lineitem_prt_16.l_receiptdate) AND (lineitem_prt_16.l_shipdate < lineitem_prt_16.l_commitdate) AND (lineitem_prt_16.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_16.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 620876 Worker 1: actual time=0.031..702.221 rows=5481 loops=1 Worker 2: actual time=0.059..470.575 rows=3556 loops=1 Worker 4: actual time=0.038..49.514 rows=661 loops=1 -> Parallel Seq Scan on public.lineitem_prt_20 (cost=0.00..46574.45 rows=2254 width=29) (actual time=0.155..161.223 rows=1375 loops=7) Output: lineitem_prt_20.l_linenumber, lineitem_prt_20.l_quantity, lineitem_prt_20.l_extendedprice, lineitem_prt_20.l_discount, lineitem_prt_20.l_orderkey Filter: ((lineitem_prt_20.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_20.l_commitdate < lineitem_prt_20.l_receiptdate) AND (lineitem_prt_20.l_shipdate < lineitem_prt_20.l_commitdate) AND (lineitem_prt_20.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_20.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 266090 Worker 0: actual time=0.390..665.723 rows=4815 loops=1 Worker 1: actual time=0.025..25.754 rows=385 loops=1 Worker 2: actual time=0.049..21.933 rows=138 loops=1 Worker 3: actual time=0.338..81.621 rows=643 loops=1 Worker 4: actual time=0.073..34.189 rows=360 loops=1 Worker 5: actual time=0.089..222.067 rows=2116 loops=1 -> Parallel Seq Scan on public.lineitem_prt_6 (cost=0.00..46567.66 rows=2218 width=29) (actual time=0.169..348.846 rows=3253 loops=3) Output: lineitem_prt_6.l_linenumber, lineitem_prt_6.l_quantity, lineitem_prt_6.l_extendedprice, lineitem_prt_6.l_discount, lineitem_prt_6.l_orderkey Filter: ((lineitem_prt_6.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_6.l_commitdate < lineitem_prt_6.l_receiptdate) AND (lineitem_prt_6.l_shipdate < lineitem_prt_6.l_commitdate) AND (lineitem_prt_6.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_6.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 620667 Worker 3: actual time=0.167..140.674 rows=1058 loops=1 Worker 4: actual time=0.080..484.115 rows=5072 loops=1 -> Parallel Seq Scan on public.lineitem_prt_14 (cost=0.00..46562.63 rows=2237 width=29) (actual time=0.174..563.195 rows=4880 loops=2) Output: lineitem_prt_14.l_linenumber, lineitem_prt_14.l_quantity, lineitem_prt_14.l_extendedprice, lineitem_prt_14.l_discount, lineitem_prt_14.l_orderkey Filter: ((lineitem_prt_14.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_14.l_commitdate < lineitem_prt_14.l_receiptdate) AND (lineitem_prt_14.l_shipdate < lineitem_prt_14.l_commitdate) AND (lineitem_prt_14.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_14.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 930998 Worker 5: actual time=0.051..31.763 rows=475 loops=1 -> Parallel Seq Scan on public.lineitem_prt_4 (cost=0.00..46549.20 rows=2263 width=29) (actual time=4.262..1118.324 rows=9744 loops=1) Output: lineitem_prt_4.l_linenumber, lineitem_prt_4.l_quantity, lineitem_prt_4.l_extendedprice, lineitem_prt_4.l_discount, lineitem_prt_4.l_orderkey Filter: ((lineitem_prt_4.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_4.l_commitdate < lineitem_prt_4.l_receiptdate) AND (lineitem_prt_4.l_shipdate < lineitem_prt_4.l_commitdate) AND (lineitem_prt_4.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_4.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1861403 -> Parallel Seq Scan on public.lineitem_prt_31 (cost=0.00..46542.50 rows=2288 width=29) (actual time=0.794..2110.198 rows=9852 loops=1) Output: lineitem_prt_31.l_linenumber, lineitem_prt_31.l_quantity, lineitem_prt_31.l_extendedprice, lineitem_prt_31.l_discount, lineitem_prt_31.l_orderkey Filter: ((lineitem_prt_31.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_31.l_commitdate < lineitem_prt_31.l_receiptdate) AND (lineitem_prt_31.l_shipdate < lineitem_prt_31.l_commitdate) AND (lineitem_prt_31.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_31.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1860992 -> Parallel Seq Scan on public.lineitem_prt_30 (cost=0.00..46466.90 rows=2194 width=29) (actual time=0.274..1473.314 rows=9725 loops=1) Output: lineitem_prt_30.l_linenumber, lineitem_prt_30.l_quantity, lineitem_prt_30.l_extendedprice, lineitem_prt_30.l_discount, lineitem_prt_30.l_orderkey Filter: ((lineitem_prt_30.l_shipmode = ANY ('{TRUCK,AIR}'::bpchar[])) AND (lineitem_prt_30.l_commitdate < lineitem_prt_30.l_receiptdate) AND (lineitem_prt_30.l_shipdate < lineitem_prt_30.l_commitdate) AND (lineitem_prt_30.l_receiptdate >= '1996-01-01'::date) AND (lineitem_prt_30.l_receiptdate < '1997-01-01 00:00:00'::timestamp without time zone)) Rows Removed by Filter: 1857991 Planning Time: 7.694 ms Execution Time: 8305.550 ms (315 rows)