QUERY PLAN                                                                
-----------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=15493271.13..15493271.13 rows=1 width=36) (actual time=331351.099..331351.099 rows=0 loops=1)
   ->  HashAggregate  (cost=15186647.64..15493271.13 rows=20441566 width=36) (actual time=318190.465..330956.383 rows=15000000 loops=1)
         Group Key: lineitem.l_partkey
         Peak Memory Usage: 4775953kB
         ->  Seq Scan on lineitem  (cost=0.00..12936556.76 rows=450018176 width=9) (actual time=0.156..56051.850 rows=450019701 loops=1)
 Planning Time: 0.151 ms
 Execution Time: 331931.239 ms
(7 rows)


                                                                  QUERY PLAN                                                                   
-----------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=81298097.02..81298097.02 rows=1 width=36) (actual time=415344.639..415344.639 rows=0 loops=1)
   ->  GroupAggregate  (cost=77616337.21..81298097.02 rows=20441566 width=36) (actual time=209292.469..414951.954 rows=15000000 loops=1)
         Group Key: lineitem.l_partkey
         ->  Sort  (cost=77616337.21..78741382.65 rows=450018176 width=9) (actual time=209292.435..329583.999 rows=450019701 loops=1)
               Sort Key: lineitem.l_partkey
               Sort Method: quicksort  Memory: 33677586kB
               ->  Seq Scan on lineitem  (cost=0.00..12936556.76 rows=450018176 width=9) (actual time=0.096..72474.733 rows=450019701 loops=1)
 Planning Time: 0.145 ms
 Execution Time: 417157.598 ms
(9 rows)