|
Hello, we noticed that in the presence of a schema with many partitions the jitting overhead penalizes the total query execution time so much that the planner should have decided not to jit at all. For example without jitting we go a 8.3 s execution time and with jitting enabled 13.8 s.
Attached you can find the TPC-h schema, a query to trigger it and the plans that we obtained.
Setup: Current master from PSQL git repo, only compiled with llvm TPC-h schema attached, plus a single index per table, and a scale factor of 10. Tables where analyzed. The query is variation of query 12 to make the effect more relevant. Max_workers_per_gather is 8 And we only vary the jit flag, we do not modify the costs.
Is this behavior expected? Is the cost function for jitting missing some circumstances?
Cheers
Dr. Luis M. Carril Rodríguez
Senior Software Engineer
luis.carril@xxxxxxxxxxx Swarm64 AS Parkveien 41 B | 0258 Oslo | Norway Registered at Brønnøysundregistrene in Norway under Org.-Number 911 662 787 CEO/Geschäftsführer (Daglig Leder): Dr. Karsten Rönner; Chairman/Vorsitzender (Styrets Leder): Dr. Sverre Munck Swarm64 AS Zweigstelle Hive Ullsteinstr. 120 | 12109 Berlin | Germany
Registered at Amtsgericht Charlottenburg - HRB 154382 B  |
Attachment:
tpch-schema-part.sql
Description: tpch-schema-part.sql
Attachment:
12-jit-slow.sql
Description: 12-jit-slow.sql
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)
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)
