                                                                         QUERY PLAN                                                                         
------------------------------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=2786961.30..2786977.38 rows=1 width=24)
   ->  Finalize GroupAggregate  (cost=2786961.30..2787041.72 rows=5 width=24)
         Group Key: orders.o_orderpriority
         ->  Gather Merge  (cost=2786961.30..2787041.52 rows=30 width=24)
               Workers Planned: 6
               ->  Partial GroupAggregate  (cost=2785961.20..2786037.78 rows=5 width=24)
                     Group Key: orders.o_orderpriority
                     ->  Sort  (cost=2785961.20..2785986.71 rows=10204 width=16)
                           Sort Key: orders.o_orderpriority
                           ->  Parallel Hash Semi Join  (cost=2287128.17..2785281.77 rows=10204 width=16)
                                 Hash Cond: (orders.o_orderkey = lineitem_1997_03.l_orderkey)
                                 ->  Parallel Seq Scan on orders  (cost=0.00..478035.10 rows=149709 width=20)
                                       Filter: ((o_orderdate >= '1993-06-01'::date) AND (o_orderdate < '1993-09-01 00:00:00'::timestamp without time zone))
                                 ->  Parallel Hash  (cost=2212136.03..2212136.03 rows=4570891 width=4)
                                       ->  Parallel Append  (cost=0.00..2212136.03 rows=4570891 width=4)
                                             ->  Parallel Seq Scan on lineitem_1997_03  (cost=0.00..28247.60 rows=133296 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_05  (cost=0.00..28239.48 rows=133239 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_03  (cost=0.00..28234.29 rows=133208 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_03  (cost=0.00..28232.52 rows=133214 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_12  (cost=0.00..28228.67 rows=133191 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_05  (cost=0.00..28227.92 rows=133198 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_07  (cost=0.00..28223.68 rows=133165 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_01  (cost=0.00..28221.08 rows=133149 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_10  (cost=0.00..28215.69 rows=133138 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_08  (cost=0.00..28208.01 rows=133094 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_07  (cost=0.00..28201.06 rows=133068 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_01  (cost=0.00..28199.42 rows=133051 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_08  (cost=0.00..28198.89 rows=133037 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_08  (cost=0.00..28195.98 rows=133039 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_12  (cost=0.00..28195.76 rows=133034 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_08  (cost=0.00..28193.47 rows=133026 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_08  (cost=0.00..28193.09 rows=133016 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_01  (cost=0.00..28187.39 rows=132997 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_07  (cost=0.00..28179.71 rows=132952 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_07  (cost=0.00..28177.90 rows=132957 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_08  (cost=0.00..28176.21 rows=132939 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_07  (cost=0.00..28173.37 rows=132943 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_05  (cost=0.00..28173.21 rows=132939 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_10  (cost=0.00..28173.21 rows=132939 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_10  (cost=0.00..28173.08 rows=132935 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_10  (cost=0.00..28171.46 rows=132919 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_01  (cost=0.00..28168.52 rows=132894 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_10  (cost=0.00..28167.94 rows=132905 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_12  (cost=0.00..28166.50 rows=132894 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_01  (cost=0.00..28151.17 rows=132831 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_05  (cost=0.00..28150.97 rows=132826 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_05  (cost=0.00..28149.86 rows=132823 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_03  (cost=0.00..28149.69 rows=132818 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_03  (cost=0.00..28149.31 rows=132835 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_03  (cost=0.00..28148.78 rows=132821 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_05  (cost=0.00..28147.49 rows=132813 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_07  (cost=0.00..28146.85 rows=132796 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_12  (cost=0.00..28146.18 rows=132805 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_07  (cost=0.00..28145.33 rows=132809 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_01  (cost=0.00..28145.01 rows=132800 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_05  (cost=0.00..28142.34 rows=132783 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_12  (cost=0.00..28127.02 rows=132720 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_12  (cost=0.00..28116.86 rows=132663 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_10  (cost=0.00..28107.16 rows=132618 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_04  (cost=0.00..27343.12 rows=129016 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_09  (cost=0.00..27341.79 rows=129008 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_04  (cost=0.00..27327.82 rows=128955 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_04  (cost=0.00..27317.58 rows=128895 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_11  (cost=0.00..27317.05 rows=128881 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_11  (cost=0.00..27315.06 rows=128882 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_09  (cost=0.00..27310.53 rows=128867 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_06  (cost=0.00..27308.90 rows=128851 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_09  (cost=0.00..27308.34 rows=128836 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_09  (cost=0.00..27305.88 rows=128850 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_06  (cost=0.00..27302.65 rows=128817 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_06  (cost=0.00..27301.10 rows=128803 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_09  (cost=0.00..27295.75 rows=128794 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_09  (cost=0.00..27291.96 rows=128772 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_06  (cost=0.00..27289.69 rows=128765 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_11  (cost=0.00..27280.56 rows=128708 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_04  (cost=0.00..27271.01 rows=128667 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_11  (cost=0.00..27255.59 rows=128602 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_06  (cost=0.00..27254.25 rows=128593 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_06  (cost=0.00..27252.50 rows=128574 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_04  (cost=0.00..27247.56 rows=128548 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_06  (cost=0.00..27237.40 rows=128517 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_04  (cost=0.00..27226.10 rows=128456 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_11  (cost=0.00..27222.30 rows=128435 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_11  (cost=0.00..27213.19 rows=128405 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1996_02  (cost=0.00..26339.62 rows=124283 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1997_02  (cost=0.00..25510.27 rows=120354 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1993_02  (cost=0.00..25503.68 rows=120338 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1995_02  (cost=0.00..25470.81 rows=120182 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1994_02  (cost=0.00..25435.96 rows=120025 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_02  (cost=0.00..25408.64 rows=119884 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_08  (cost=0.00..25144.09 rows=118643 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_04  (cost=0.00..23734.94 rows=111998 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_03  (cost=0.00..17481.08 rows=82482 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_09  (cost=0.00..17478.56 rows=82468 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_10  (cost=0.00..11511.79 rows=66715 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_02  (cost=0.00..10309.36 rows=59743 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1992_01  (cost=0.00..4010.35 rows=30116 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_11  (cost=0.00..3926.15 rows=22751 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
                                             ->  Parallel Seq Scan on lineitem_1998_12  (cost=0.00..9.49 rows=66 width=4)
                                                   Filter: (l_commitdate < l_receiptdate)
(183 rows)
