18_pwa_off.out
application/octet-stream
Filename: 18_pwa_off.out
Type: application/octet-stream
Part: 0
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------
Limit (cost=3487358.51..3487361.26 rows=100 width=71) (actual time=274536.162..274537.750 rows=100 loops=1)
-> GroupAggregate (cost=3487358.51..3502252.90 rows=541614 width=71) (actual time=274536.158..274537.726 rows=100 loops=1)
Group Key: orders_1.o_totalprice, orders_1.o_orderdate, customer.c_custkey, orders_1.o_orderkey
-> Sort (cost=3487358.51..3488712.55 rows=541614 width=44) (actual time=274536.120..274536.217 rows=701 loops=1)
Sort Key: orders_1.o_totalprice DESC, orders_1.o_orderdate, customer.c_custkey, orders_1.o_orderkey
Sort Method: quicksort Memory: 102kB
-> Nested Loop (cost=803226.58..3435778.16 rows=541614 width=44) (actual time=214298.616..274532.842 rows=896 loops=1)
-> Nested Loop (cost=803226.15..1521963.54 rows=135409 width=43) (actual time=214298.466..274504.744 rows=128 loops=1)
-> Nested Loop (cost=803225.72..1459157.38 rows=135409 width=24) (actual time=214298.418..274499.697 rows=128 loops=1)
-> Finalize HashAggregate (cost=803225.29..809318.71 rows=135409 width=4) (actual time=214298.133..274467.045 rows=128 loops=1)
Group Key: lineitem_10_1.l_orderkey
Filter: (sum(lineitem_10_1.l_quantity) > '315'::numeric)
Rows Removed by Filter: 29999872
-> Gather (cost=623469.40..791038.45 rows=1624912 width=36) (actual time=60146.179..96646.809 rows=30010592 loops=1)
Workers Planned: 4
Workers Launched: 4
-> Partial HashAggregate (cost=622469.40..627547.25 rows=406228 width=36) (actual time=60139.396..80334.758 rows=6002118 loops=5)
Group Key: lineitem_10_1.l_orderkey
-> Parallel Append (cost=0.00..472475.82 rows=29998716 width=9) (actual time=0.059..21877.601 rows=23998922 loops=5)
-> Parallel Seq Scan on lineitem_10 lineitem_10_1 (cost=0.00..32264.10 rows=3001346 width=9) (actual time=0.072..9123.339 rows=
12005332 loops=1)
-> Parallel Seq Scan on lineitem_3 lineitem_3_1 (cost=0.00..32259.47 rows=3000914 width=9) (actual time=0.067..8987.154 rows=12
003543 loops=1)
-> Parallel Seq Scan on lineitem_7 lineitem_7_1 (cost=0.00..32257.83 rows=3000761 width=9) (actual time=0.066..9016.777 rows=12
003016 loops=1)
-> Parallel Seq Scan on lineitem_8 lineitem_8_1 (cost=0.00..32251.44 rows=3000177 width=9) (actual time=0.054..8901.798 rows=12
000549 loops=1)
-> Parallel Seq Scan on lineitem_9 lineitem_9_1 (cost=0.00..32251.20 rows=3000152 width=9) (actual time=0.067..4211.476 rows=60
00319 loops=2)
-> Parallel Seq Scan on lineitem_6 lineitem_6_1 (cost=0.00..32247.33 rows=2999789 width=9) (actual time=0.062..8120.305 rows=11
999028 loops=1)
-> Parallel Seq Scan on lineitem_2 lineitem_2_1 (cost=0.00..32245.59 rows=2999625 width=9) (actual time=0.086..8217.501 rows=11
998609 loops=1)
-> Parallel Seq Scan on lineitem_1 lineitem_1_1 (cost=0.00..32244.00 rows=2999481 width=9) (actual time=0.046..1630.776 rows=23
99598 loops=5)
-> Parallel Seq Scan on lineitem_5 lineitem_5_1 (cost=0.00..32241.57 rows=2999251 width=9) (actual time=0.032..4257.257 rows=59
98522 loops=2)
-> Parallel Seq Scan on lineitem_4 lineitem_4_1 (cost=0.00..32219.70 rows=2997220 width=9) (actual time=0.030..8456.053 rows=11
988857 loops=1)
-> Append (cost=0.43..4.69 rows=10 width=20) (actual time=0.172..0.241 rows=1 loops=128)
-> Index Scan using orders_1_pkey on orders_1 (cost=0.43..0.46 rows=1 width=20) (actual time=0.052..0.052 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using orders_2_pkey on orders_2 (cost=0.43..0.46 rows=1 width=20) (actual time=0.019..0.019 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using orders_3_pkey on orders_3 (cost=0.43..0.46 rows=1 width=20) (actual time=0.019..0.019 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using orders_4_pkey on orders_4 (cost=0.43..0.46 rows=1 width=20) (actual time=0.020..0.020 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using orders_5_pkey on orders_5 (cost=0.43..0.46 rows=1 width=20) (actual time=0.021..0.021 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using orders_6_pkey on orders_6 (cost=0.43..0.46 rows=1 width=20) (actual time=0.017..0.017 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using orders_7_pkey on orders_7 (cost=0.43..0.46 rows=1 width=20) (actual time=0.017..0.017 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using orders_8_pkey on orders_8 (cost=0.43..0.46 rows=1 width=20) (actual time=0.021..0.021 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using orders_9_pkey on orders_9 (cost=0.43..0.46 rows=1 width=20) (actual time=0.016..0.016 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using orders_10_pkey on orders_10 (cost=0.43..0.46 rows=1 width=20) (actual time=0.017..0.017 rows=0 loops=128)
Index Cond: (o_orderkey = lineitem_10_1.l_orderkey)
-> Index Scan using customer_pkey on customer (cost=0.43..0.46 rows=1 width=23) (actual time=0.034..0.034 rows=1 loops=128)
Index Cond: (c_custkey = orders_1.o_custkey)
-> Append (cost=0.43..11.17 rows=296 width=9) (actual time=0.126..0.210 rows=7 loops=128)
-> Index Scan using idx_lineitem_orderkey_001 on lineitem_1 (cost=0.43..0.96 rows=29 width=9) (actual time=0.017..0.019 rows=1 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
-> Index Scan using idx_lineitem_orderkey_002 on lineitem_2 (cost=0.43..0.96 rows=29 width=9) (actual time=0.015..0.016 rows=1 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
-> Index Scan using idx_lineitem_orderkey_003 on lineitem_3 (cost=0.43..0.98 rows=30 width=9) (actual time=0.016..0.017 rows=1 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
-> Index Scan using idx_lineitem_orderkey_004 on lineitem_4 (cost=0.43..0.98 rows=30 width=9) (actual time=0.017..0.018 rows=1 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
-> Index Scan using idx_lineitem_orderkey_005 on lineitem_5 (cost=0.43..0.99 rows=31 width=9) (actual time=0.017..0.019 rows=1 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
-> Index Scan using idx_lineitem_orderkey_006 on lineitem_6 (cost=0.43..0.98 rows=30 width=9) (actual time=0.015..0.016 rows=0 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
-> Index Scan using idx_lineitem_orderkey_007 on lineitem_7 (cost=0.43..0.99 rows=31 width=9) (actual time=0.015..0.015 rows=0 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
-> Index Scan using idx_lineitem_orderkey_008 on lineitem_8 (cost=0.43..0.96 rows=29 width=9) (actual time=0.039..0.040 rows=1 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
-> Index Scan using idx_lineitem_orderkey_009 on lineitem_9 (cost=0.43..0.96 rows=29 width=9) (actual time=0.014..0.015 rows=0 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
-> Index Scan using idx_lineitem_orderkey_010 on lineitem_10 (cost=0.43..0.94 rows=28 width=9) (actual time=0.015..0.016 rows=1 loops=128)
Index Cond: (l_orderkey = orders_1.o_orderkey)
Planning time: 18.771 ms
Execution time: 280161.396 ms
(75 rows)