   ->  Sort  (cost=54597.49..54597.50 rows=1 width=121)
         Sort Key: nation.n_name, date_part('year'::text,orders.o_orderdate)
         ->  Aggregate  (cost=54597.45..54597.48 rows=1 width=121)
               ->  Group  (cost=54597.45..54597.47 rows=3 width=121)
                     ->  Sort  (cost=54597.45..54597.46 rows=3 width=121)
                           Sort Key: nation.n_name, date_part('year'::text, orders.o_orderdate)
                           ->  Hash Join  (cost=54596.00..54597.42 rows=3 width=121)
                                 Hash Cond: ("outer".n_nationkey = "inner".s_nationkey)
                                 ->  Seq Scan on nation  (cost=0.00..1.25 rows=25 width=33)
                                 ->  Hash  (cost=54596.00..54596.00 rows=3 width=88)
                                       ->  Nested Loop (cost=0.00..54596.00 rows=3 width=88)
                                             Join Filter: ("inner".s_suppkey = "outer".l_suppkey)
                                             ->  Nested Loop (cost=0.00..54586.18 rows=3 width=80)
                                                   ->  Nested Loop (cost=0.00..54575.47 rows=4 width=68)
                                                         Join Filter: ("outer".p_partkey = "inner".ps_partkey)
                                                         ->  Nested Loop (cost=0.00..22753.33 rows=9343 width=49)
                                                               ->  Seq Scan on part  (cost=0.00..7868.00 rows=320 width=4) 
Filter: (p_name ~~ '%green%'::text)
                                                               ->  Index Scan using i_l_partkey on lineitem  (cost=0.00..46.15 rows=29 width=45)
                                                                     Index
Cond: ("outer".p_partkey = lineitem.l_partkey)
                                                         ->  Index Scan using pk_partsupp on partsupp  (cost=0.00..3.39 rows=1 width=19)
                                                               Index Cond: ((partsupp.ps_partkey = "outer".l_partkey) AND (partsupp.ps_suppkey =
"outer".l_suppkey))
                                                   ->  Index Scan using pk_orders on orders  (cost=0.00..3.01 rows=1 width=12)
                                                         Index Cond: (orders.o_orderkey = "outer".l_orderkey)
                                             ->  Index Scan using pk_supplier on supplier  (cost=0.00..3.01 rows=1 width=8)
                                                   Index Cond: ("outer".ps_suppkey = supplier.s_suppkey) (27 rows)

