   ->  Sort  (cost=54597.49..54597.50 rows=1 width=121) (actual time=6674562.03..6674562.15 rows=175 loops=1)
         Sort Key: nation.n_name, date_part('year'::text,
orders.o_orderdate)
         ->  Aggregate  (cost=54597.45..54597.48 rows=1 width=121) (actual time=6668919.41..6674522.48 rows=175 loops=1)
               ->  Group  (cost=54597.45..54597.47 rows=3 width=121) (actual time=6668872.68..6672136.96 rows=348760 loops=1)
                     ->  Sort  (cost=54597.45..54597.46 rows=3 width=121) (actual time=6668872.65..6669499.95 rows=348760 loops=1)
                           Sort Key: nation.n_name, date_part('year'::text, orders.o_orderdate)
                           ->  Hash Join  (cost=54596.00..54597.42 rows=3
width=121) (actual time=6632768.89..6650192.67 rows=348760 loops=1)
                                 Hash Cond: ("outer".n_nationkey =
"inner".s_nationkey)
                                 ->  Seq Scan on nation  (cost=0.00..1.25 rows=25 width=33) (actual time=6.75..7.13 rows=25 loops=1)
                                 ->  Hash  (cost=54596.00..54596.00 rows=3
width=88) (actual time=6632671.96..6632671.96 rows=0 loops=1)
                                       ->  Nested Loop (cost=0.00..54596.00 rows=3 width=88) (actual time=482.41..6630601.46 rows=348760 loops=1)
                                             Join Filter: ("inner".s_suppkey = "outer".l_suppkey)
                                             ->  Nested Loop (cost=0.00..54586.18 rows=3 width=80) (actual time=383.87..6594984.40 rows=348760 loops=1)
                                                   ->  Nested Loop (cost=0.00..54575.47 rows=4 width=68) (actual time=199.95..3580882.07 rows=348760 loops=1)
                                                         Join Filter: ("outer".p_partkey = "inner".ps_partkey)
                                                         ->  Nested Loop (cost=0.00..22753.33 rows=9343 width=49) (actual time=146.85..3541433.10 rows=348760 loops=1)
                                                               ->  Seq Scan on part  (cost=0.00..7868.00 rows=320 width=4) (actual time=33.64..15651.90 rows=11637 loops=1)

Filter: (p_name ~~ '%green%'::text)
                                                               ->  Index Scan using i_l_partkey on lineitem  (cost=0.00..46.15 rows=29 width=45) (actual time=10.71..302.67 rows=30 loops=11637)
                                                                     Index
Cond: ("outer".p_partkey = lineitem.l_partkey)
                                                         ->  Index Scan using pk_partsupp on partsupp  (cost=0.00..3.39 rows=1 width=19) (actual time=0.09..0.09 rows=1 loops=348760)
                                                               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) (actual time=8.62..8.62 rows=1 loops=348760)
                                                         Index Cond: (orders.o_orderkey = "outer".l_orderkey)
                                             ->  Index Scan using pk_supplier on supplier  (cost=0.00..3.01 rows=1 width=8) (actual time=0.08..0.08 rows=1 loops=348760)
                                                   Index Cond: ("outer".ps_suppkey = supplier.s_suppkey)  Total runtime: 6674724.23 msec (28 rows)

