QUERY PLAN --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Finalize Aggregate (cost=1848031.51..1848031.52 rows=1 width=152) (actual time=13861.626..13861.626 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=13856.802..13868.633 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 JIT for worker 0: Functions: 202 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 37.860 ms, Inlining 70.311 ms, Optimization 3262.274 ms, Emission 1807.332 ms, Total 5177.778 ms JIT for worker 1: Functions: 202 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 27.833 ms, Inlining 117.093 ms, Optimization 3917.001 ms, Emission 2027.251 ms, Total 6089.177 ms JIT for worker 2: Functions: 202 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 28.310 ms, Inlining 108.926 ms, Optimization 3530.616 ms, Emission 1749.873 ms, Total 5417.726 ms JIT for worker 3: Functions: 202 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 64.993 ms, Inlining 123.108 ms, Optimization 3191.771 ms, Emission 1852.028 ms, Total 5231.900 ms JIT for worker 4: Functions: 202 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 39.323 ms, Inlining 137.094 ms, Optimization 3878.024 ms, Emission 2036.600 ms, Total 6091.042 ms JIT for worker 5: Functions: 202 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 72.013 ms, Inlining 126.110 ms, Optimization 3906.258 ms, Emission 1683.333 ms, Total 5787.715 ms -> Partial Aggregate (cost=1847030.74..1847030.75 rows=1 width=152) (actual time=13787.428..13787.428 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=13769.355..13769.356 rows=1 loops=1 Worker 1: actual time=13801.125..13801.125 rows=1 loops=1 Worker 2: actual time=13799.754..13799.754 rows=1 loops=1 Worker 3: actual time=13761.837..13761.837 rows=1 loops=1 Worker 4: actual time=13767.015..13767.016 rows=1 loops=1 Worker 5: actual time=13757.460..13757.460 rows=1 loops=1 -> Parallel Hash Join (cost=1493182.48..1845707.68 rows=48111 width=37) (actual time=11619.596..13748.160 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=11604.291..13745.594 rows=42454 loops=1 Worker 1: actual time=11634.312..13759.839 rows=46358 loops=1 Worker 2: actual time=11630.360..13754.647 rows=49993 loops=1 Worker 3: actual time=11595.083..13716.915 rows=42910 loops=1 Worker 4: actual time=11594.702..13721.657 rows=44030 loops=1 Worker 5: actual time=11593.321..13736.250 rows=41020 loops=1 -> Parallel Append (cost=0.00..343070.00 rows=2500001 width=24) (actual time=0.025..1204.785 rows=2142857 loops=7) Worker 0: actual time=0.026..1259.350 rows=2044652 loops=1 Worker 1: actual time=0.027..1228.402 rows=2223664 loops=1 Worker 2: actual time=0.027..1194.004 rows=2396554 loops=1 Worker 3: actual time=0.030..1230.115 rows=2053769 loops=1 Worker 4: actual time=0.022..1163.329 rows=2118191 loops=1 Worker 5: actual time=0.028..1275.972 rows=1965820 loops=1 -> Parallel Seq Scan on public.orders_prt_19 (cost=0.00..10359.21 rows=195821 width=24) (actual time=0.030..154.920 rows=469970 loops=1) Output: orders_prt_19.o_orderpriority, orders_prt_19.o_orderkey Worker 3: actual time=0.030..154.920 rows=469970 loops=1 -> Parallel Seq Scan on public.orders_prt_23 (cost=0.00..10353.82 rows=195782 width=24) (actual time=0.026..196.565 rows=469876 loops=1) Output: orders_prt_23.o_orderpriority, orders_prt_23.o_orderkey Worker 2: actual time=0.026..196.565 rows=469876 loops=1 -> Parallel Seq Scan on public.orders_prt_8 (cost=0.00..10351.44 rows=195744 width=24) (actual time=0.026..112.736 rows=469786 loops=1) Output: orders_prt_8.o_orderpriority, orders_prt_8.o_orderkey Worker 1: actual time=0.026..112.736 rows=469786 loops=1 -> Parallel Seq Scan on public.orders_prt_17 (cost=0.00..10347.28 rows=195628 width=24) (actual time=0.025..202.386 rows=469507 loops=1) Output: orders_prt_17.o_orderpriority, orders_prt_17.o_orderkey Worker 0: actual time=0.025..202.386 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..182.613 rows=469454 loops=1) Output: orders_prt_9.o_orderpriority, orders_prt_9.o_orderkey Worker 4: actual time=0.021..182.613 rows=469454 loops=1 -> Parallel Seq Scan on public.orders_prt_21 (cost=0.00..10342.17 rows=195518 width=24) (actual time=0.027..219.263 rows=469242 loops=1) Output: orders_prt_21.o_orderpriority, orders_prt_21.o_orderkey Worker 5: actual time=0.027..219.263 rows=469242 loops=1 -> Parallel Seq Scan on public.orders_prt_18 (cost=0.00..10340.58 rows=195458 width=24) (actual time=0.042..218.769 rows=469098 loops=1) Output: orders_prt_18.o_orderpriority, orders_prt_18.o_orderkey Worker 1: actual time=0.042..218.769 rows=469098 loops=1 -> Parallel Seq Scan on public.orders_prt_3 (cost=0.00..10339.00 rows=195500 width=24) (actual time=0.051..162.059 rows=469199 loops=1) Output: orders_prt_3.o_orderpriority, orders_prt_3.o_orderkey Worker 3: actual time=0.051..162.059 rows=469199 loops=1 -> Parallel Seq Scan on public.orders_prt_22 (cost=0.00..10338.98 rows=195498 width=24) (actual time=0.033..127.121 rows=469195 loops=1) Output: orders_prt_22.o_orderpriority, orders_prt_22.o_orderkey Worker 4: actual time=0.033..127.121 rows=469195 loops=1 -> Parallel Seq Scan on public.orders_prt_11 (cost=0.00..10336.90 rows=195490 width=24) (actual time=0.037..137.450 rows=469176 loops=1) Output: orders_prt_11.o_orderpriority, orders_prt_11.o_orderkey Worker 2: actual time=0.037..137.450 rows=469176 loops=1 -> Parallel Seq Scan on public.orders_prt_24 (cost=0.00..10333.75 rows=195375 width=24) (actual time=0.041..194.650 rows=468900 loops=1) Output: orders_prt_24.o_orderpriority, orders_prt_24.o_orderkey Worker 0: actual time=0.041..194.650 rows=468900 loops=1 -> Parallel Seq Scan on public.orders_prt_28 (cost=0.00..10333.33 rows=195333 width=24) (actual time=0.045..196.804 rows=468799 loops=1) Output: orders_prt_28.o_orderpriority, orders_prt_28.o_orderkey Worker 5: actual time=0.045..196.804 rows=468799 loops=1 -> Parallel Seq Scan on public.orders_prt_1 (cost=0.00..10333.22 rows=195422 width=24) (actual time=0.038..193.250 rows=469012 loops=1) Output: orders_prt_1.o_orderpriority, orders_prt_1.o_orderkey Worker 1: actual time=0.038..193.250 rows=469012 loops=1 -> Parallel Seq Scan on public.orders_prt_13 (cost=0.00..10332.91 rows=195391 width=24) (actual time=0.034..230.925 rows=468939 loops=1) Output: orders_prt_13.o_orderpriority, orders_prt_13.o_orderkey Worker 3: actual time=0.034..230.925 rows=468939 loops=1 -> Parallel Seq Scan on public.orders_prt_12 (cost=0.00..10332.23 rows=195323 width=24) (actual time=0.038..175.252 rows=468775 loops=1) Output: orders_prt_12.o_orderpriority, orders_prt_12.o_orderkey Worker 2: actual time=0.038..175.252 rows=468775 loops=1 -> Parallel Seq Scan on public.orders_prt_25 (cost=0.00..10330.50 rows=195350 width=24) (actual time=0.036..171.237 rows=468840 loops=1) Output: orders_prt_25.o_orderpriority, orders_prt_25.o_orderkey Worker 4: actual time=0.036..171.237 rows=468840 loops=1 -> Parallel Seq Scan on public.orders_prt_29 (cost=0.00..10328.96 rows=195296 width=24) (actual time=0.038..214.361 rows=468711 loops=1) Output: orders_prt_29.o_orderpriority, orders_prt_29.o_orderkey Worker 0: actual time=0.038..214.361 rows=468711 loops=1 -> Parallel Seq Scan on public.orders_prt_20 (cost=0.00..10327.57 rows=195257 width=24) (actual time=0.036..224.781 rows=468617 loops=1) Output: orders_prt_20.o_orderpriority, orders_prt_20.o_orderkey Worker 5: actual time=0.036..224.781 rows=468617 loops=1 -> Parallel Seq Scan on public.orders_prt_10 (cost=0.00..10327.24 rows=195224 width=24) (actual time=0.041..142.496 rows=468538 loops=1) Output: orders_prt_10.o_orderpriority, orders_prt_10.o_orderkey Worker 1: actual time=0.041..142.496 rows=468538 loops=1 -> Parallel Seq Scan on public.orders_prt_0 (cost=0.00..10326.63 rows=195263 width=24) (actual time=0.039..124.673 rows=468632 loops=1) Output: orders_prt_0.o_orderpriority, orders_prt_0.o_orderkey Worker 2: actual time=0.039..124.673 rows=468632 loops=1 -> Parallel Seq Scan on public.orders_prt_16 (cost=0.00..10326.01 rows=195201 width=24) (actual time=0.035..152.734 rows=468482 loops=1) Output: orders_prt_16.o_orderpriority, orders_prt_16.o_orderkey Worker 4: actual time=0.035..152.734 rows=468482 loops=1 -> Parallel Seq Scan on public.orders_prt_6 (cost=0.00..10325.42 rows=195242 width=24) (actual time=0.035..215.648 rows=468580 loops=1) Output: orders_prt_6.o_orderpriority, orders_prt_6.o_orderkey Worker 3: actual time=0.035..215.648 rows=468580 loops=1 -> Parallel Seq Scan on public.orders_prt_27 (cost=0.00..10325.32 rows=195132 width=24) (actual time=0.036..153.752 rows=468316 loops=1) Output: orders_prt_27.o_orderpriority, orders_prt_27.o_orderkey Worker 0: actual time=0.036..153.752 rows=468316 loops=1 -> Parallel Seq Scan on public.orders_prt_2 (cost=0.00..10324.02 rows=195202 width=24) (actual time=0.035..119.131 rows=234243 loops=2) Output: orders_prt_2.o_orderpriority, orders_prt_2.o_orderkey Worker 0: actual time=0.037..8.723 rows=31025 loops=1 Worker 5: actual time=0.033..229.539 rows=437461 loops=1 -> Parallel Seq Scan on public.orders_prt_15 (cost=0.00..10323.85 rows=195185 width=24) (actual time=0.043..111.153 rows=234222 loops=2) Output: orders_prt_15.o_orderpriority, orders_prt_15.o_orderkey Worker 0: actual time=0.048..32.767 rows=48285 loops=1 Worker 2: actual time=0.038..189.539 rows=420158 loops=1 -> Parallel Seq Scan on public.orders_prt_4 (cost=0.00..10323.09 rows=195209 width=24) (actual time=0.768..135.317 rows=156167 loops=3) Output: orders_prt_4.o_orderpriority, orders_prt_4.o_orderkey Worker 0: actual time=0.032..29.536 rows=23980 loops=1 Worker 1: actual time=0.036..252.797 rows=336351 loops=1 Worker 5: actual time=2.236..123.617 rows=108170 loops=1 -> Parallel Seq Scan on public.orders_prt_7 (cost=0.00..10321.29 rows=195129 width=24) (actual time=0.256..77.816 rows=66901 loops=7) Output: orders_prt_7.o_orderpriority, orders_prt_7.o_orderkey Worker 0: actual time=0.040..27.612 rows=25238 loops=1 Worker 1: actual time=0.028..31.653 rows=10879 loops=1 Worker 2: actual time=0.750..112.229 rows=99937 loops=1 Worker 3: actual time=0.030..45.594 rows=42808 loops=1 Worker 4: actual time=0.037..237.461 rows=242220 loops=1 Worker 5: actual time=0.891..34.861 rows=13531 loops=1 -> Parallel Seq Scan on public.orders_prt_5 (cost=0.00..10317.45 rows=195045 width=24) (actual time=0.026..128.063 rows=156036 loops=3) Output: orders_prt_5.o_orderpriority, orders_prt_5.o_orderkey Worker 0: actual time=0.025..50.737 rows=40690 loops=1 Worker 3: actual time=0.034..155.252 rows=134273 loops=1 -> Parallel Seq Scan on public.orders_prt_14 (cost=0.00..10311.32 rows=194932 width=24) (actual time=0.018..130.643 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.018..128.473 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.018..188.287 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.016..191.822 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=11616.688..11616.689 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: 23776kB Worker 0: actual time=11602.299..11602.300 rows=40734 loops=1 Worker 1: actual time=11626.235..11626.236 rows=31471 loops=1 Worker 2: actual time=11629.918..11629.918 rows=39494 loops=1 Worker 3: actual time=11594.782..11594.783 rows=49140 loops=1 Worker 4: actual time=11592.850..11592.851 rows=39811 loops=1 Worker 5: actual time=11589.021..11589.022 rows=38682 loops=1 -> Parallel Append (cost=0.00..1492581.10 rows=48111 width=29) (actual time=5686.772..11566.385 rows=44656 loops=7) Worker 0: actual time=5145.256..11569.629 rows=40734 loops=1 Worker 1: actual time=6067.248..11586.793 rows=31471 loops=1 Worker 2: actual time=5394.909..11564.953 rows=39494 loops=1 Worker 3: actual time=5172.325..11521.721 rows=49140 loops=1 Worker 4: actual time=6057.145..11562.597 rows=39811 loops=1 Worker 5: actual time=5721.140..11529.915 rows=38682 loops=1 -> Parallel Seq Scan on public.lineitem_prt_23 (cost=0.00..46766.35 rows=2216 width=29) (actual time=5394.907..6259.247 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 2: actual time=5394.907..6259.247 rows=9628 loops=1 -> Parallel Seq Scan on public.lineitem_prt_19 (cost=0.00..46741.40 rows=2335 width=29) (actual time=6067.246..6971.510 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 1: actual time=6067.246..6971.510 rows=9972 loops=1 -> Parallel Seq Scan on public.lineitem_prt_17 (cost=0.00..46733.69 rows=2349 width=29) (actual time=5145.255..6143.433 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 0: actual time=5145.255..6143.433 rows=9871 loops=1 -> Parallel Seq Scan on public.lineitem_prt_13 (cost=0.00..46707.68 rows=2244 width=29) (actual time=5172.324..6130.994 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 3: actual time=5172.324..6130.994 rows=9737 loops=1 -> Parallel Seq Scan on public.lineitem_prt_8 (cost=0.00..46702.87 rows=2216 width=29) (actual time=6057.143..6692.321 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 4: actual time=6057.143..6692.321 rows=9831 loops=1 -> Parallel Seq Scan on public.lineitem_prt_9 (cost=0.00..46700.28 rows=2261 width=29) (actual time=5721.139..6507.956 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 5: actual time=5721.139..6507.956 rows=9838 loops=1 -> Parallel Seq Scan on public.lineitem_prt_18 (cost=0.00..46694.57 rows=2272 width=29) (actual time=0.063..936.765 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 0: actual time=0.063..936.765 rows=9811 loops=1 -> Parallel Seq Scan on public.lineitem_prt_24 (cost=0.00..46676.51 rows=2264 width=29) (actual time=0.080..683.585 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 3: actual time=0.080..683.585 rows=9555 loops=1 -> Parallel Seq Scan on public.lineitem_prt_21 (cost=0.00..46671.74 rows=2248 width=29) (actual time=0.082..983.830 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 2: actual time=0.082..983.830 rows=9849 loops=1 -> Parallel Seq Scan on public.lineitem_prt_3 (cost=0.00..46670.84 rows=2232 width=29) (actual time=0.119..777.912 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 5: actual time=0.119..777.912 rows=9719 loops=1 -> Parallel Seq Scan on public.lineitem_prt_11 (cost=0.00..46658.98 rows=2329 width=29) (actual time=0.109..483.052 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 4: actual time=0.109..483.052 rows=9951 loops=1 -> Parallel Seq Scan on public.lineitem_prt_22 (cost=0.00..46657.65 rows=2274 width=29) (actual time=0.037..915.332 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 3: actual time=0.037..915.332 rows=9771 loops=1 -> Parallel Seq Scan on public.lineitem_prt_1 (cost=0.00..46646.26 rows=2190 width=29) (actual time=0.048..1991.454 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 1: actual time=0.048..1991.454 rows=9858 loops=1 -> Parallel Seq Scan on public.lineitem_prt_12 (cost=0.00..46643.33 rows=2319 width=29) (actual time=21.759..1974.102 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 0: actual time=21.759..1974.102 rows=9899 loops=1 -> Parallel Seq Scan on public.lineitem_prt_2 (cost=0.00..46643.03 rows=2208 width=29) (actual time=0.064..1916.224 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 4: actual time=0.064..1916.224 rows=9625 loops=1 -> Parallel Seq Scan on public.lineitem_prt_5 (cost=0.00..46636.07 rows=2254 width=29) (actual time=0.236..2083.316 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 2: actual time=0.236..2083.316 rows=9575 loops=1 -> Parallel Seq Scan on public.lineitem_prt_10 (cost=0.00..46632.70 rows=2264 width=29) (actual time=0.048..1966.662 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.048..1966.662 rows=9730 loops=1 -> Parallel Seq Scan on public.lineitem_prt_29 (cost=0.00..46630.93 rows=2216 width=29) (actual time=1.384..1537.796 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 3: actual time=1.384..1537.796 rows=9793 loops=1 -> Parallel Seq Scan on public.lineitem_prt_7 (cost=0.00..46627.35 rows=2220 width=29) (actual time=7.978..2100.750 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 1: actual time=7.978..2100.750 rows=9603 loops=1 -> Parallel Seq Scan on public.lineitem_prt_28 (cost=0.00..46621.98 rows=2201 width=29) (actual time=0.887..2177.801 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 0: actual time=0.887..2177.801 rows=9894 loops=1 -> Parallel Seq Scan on public.lineitem_prt_15 (cost=0.00..46612.80 rows=2268 width=29) (actual time=0.537..1111.865 rows=4865 loops=2) 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: 931917 Worker 0: actual time=0.091..39.853 rows=221 loops=1 Worker 4: actual time=0.982..2183.877 rows=9509 loops=1 -> Parallel Seq Scan on public.lineitem_prt_0 (cost=0.00..46610.67 rows=2298 width=29) (actual time=0.384..777.462 rows=3260 loops=3) 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: 621254 Worker 0: actual time=0.082..147.159 rows=604 loops=1 Worker 3: actual time=0.854..48.756 rows=222 loops=1 Worker 5: actual time=0.218..2136.470 rows=8953 loops=1 -> Parallel Seq Scan on public.lineitem_prt_25 (cost=0.00..46609.91 rows=2253 width=29) (actual time=7.316..1081.757 rows=4898 loops=2) 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: 931805 Worker 3: actual time=13.754..2058.677 rows=9501 loops=1 Worker 4: actual time=0.878..104.837 rows=296 loops=1 -> Parallel Seq Scan on public.lineitem_prt_26 (cost=0.00..46605.04 rows=2218 width=29) (actual time=0.691..1018.731 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=1.334..2036.418 rows=9770 loops=1 Worker 3: actual time=0.048..1.044 rows=25 loops=1 -> Parallel Seq Scan on public.lineitem_prt_27 (cost=0.00..46596.72 rows=2273 width=29) (actual time=0.375..300.552 rows=1402 loops=7) 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: 266172 Worker 0: actual time=0.522..134.441 rows=434 loops=1 Worker 1: actual time=0.060..519.144 rows=2038 loops=1 Worker 2: actual time=0.062..184.339 rows=672 loops=1 Worker 3: actual time=0.359..134.691 rows=536 loops=1 Worker 4: actual time=0.180..176.059 rows=599 loops=1 Worker 5: actual time=1.322..135.050 rows=442 loops=1 -> Parallel Seq Scan on public.lineitem_prt_16 (cost=0.00..46577.84 rows=2290 width=29) (actual time=0.027..555.575 rows=9698 loops=1) 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: 1862629 -> Parallel Seq Scan on public.lineitem_prt_20 (cost=0.00..46574.45 rows=2254 width=29) (actual time=0.268..637.291 rows=9626 loops=1) 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: 1862631 -> Parallel Seq Scan on public.lineitem_prt_6 (cost=0.00..46567.66 rows=2218 width=29) (actual time=0.163..646.329 rows=9760 loops=1) 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: 1862001 -> Parallel Seq Scan on public.lineitem_prt_14 (cost=0.00..46562.63 rows=2237 width=29) (actual time=0.228..539.883 rows=9761 loops=1) 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: 1861995 -> Parallel Seq Scan on public.lineitem_prt_4 (cost=0.00..46549.20 rows=2263 width=29) (actual time=0.062..702.425 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.026..706.107 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=6249.378..7013.571 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: 5.533 ms JIT: Functions: 1416 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 292.786 ms, Inlining 733.186 ms, Optimization 25759.399 ms, Emission 13262.542 ms, Total 40047.913 ms Execution Time: 13891.937 ms (341 rows)