->  Sort  (cost=360630.16..360630.16 rows=1 width=121) (actual time=119039.15..119039.27 rows=175 loops=1)
         Sort Key: nation.n_name, date_part('year'::text,
orders.o_orderdate)
         ->  Aggregate  (cost=360630.13..360630.15 rows=1 width=121) (actual time=113515.96..119037.50 rows=175 loops=1)
               ->  Group  (cost=360630.13..360630.14 rows=2 width=121) (actual time=113481.12..116728.38 rows=348760 loops=1)
                     ->  Sort  (cost=360630.13..360630.13 rows=2
width=121) (actual time=113481.10..114095.94 rows=348760 loops=1)
                           Sort Key: nation.n_name, date_part('year'::text, orders.o_orderdate)
                           ->  Hash Join  (cost=360628.72..360630.12 rows=2 width=121) (actual time=92430.19..95230.68 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=9.55..9.97 rows=25 loops=1)
                                 ->  Hash  (cost=360628.72..360628.72 rows=2 width=88) (actual time=92420.44..92420.44 rows=0 loops=1)
                                       ->  Hash Join (cost=306669.69..360628.72 rows=2 width=88) (actual time=53474.51..91355.74 rows=348760 loops=1)
                                             Hash Cond: ("outer".o_orderkey = "inner".l_orderkey)
                                             ->  Seq Scan on orders (cost=0.00..46459.00 rows=1500000 width=12) (actual time=10.87..6298.62 rows=1500000 loops=1)
                                             ->  Hash (cost=306669.69..306669.69 rows=2 width=76) (actual time=53463.43..53463.43 rows=0 loops=1)
                                                   ->  Hash Join (cost=40618.91..306669.69 rows=2 width=76) (actual time=5633.60..52291.78 rows=348760 loops=1)
                                                         Hash Cond: ("outer".l_partkey = "inner".ps_partkey)
                                                         Join Filter: ("inner".s_suppkey = "outer".l_suppkey)
                                                         ->  Seq Scan on lineitem (cost=0.00..235620.15 rows=6001215 width=45) (actual time=21.10..25686.20 rows=6001215 loops=1)
                                                         ->  Hash (cost=40615.76..40615.76 rows=1261 width=31) (actual time=5612.06..5612.06 rows=0 loops=1)
                                                               ->  Hash Join  (cost=40174.00..40615.76 rows=1261 width=31) (actual time=5235.18..5528.55 rows=46548 loops=1)
                                                                     Hash
Cond: ("outer".s_suppkey = "inner".ps_suppkey)
                                                                     -> Seq Scan on supplier  (cost=0.00..351.00 rows=10000 width=8) (actual time=24.60..170.81 rows=10000 loops=1)
                                                                     -> Hash  (cost=40170.80..40170.80 rows=1280 width=23) (actual time=5210.24..5210.24 rows=0 loops=1)

->  Hash Join  (cost=7867.80..40170.80 rows=1280 width=23) (actual
time=1215.96..5108.35 rows=46548 loops=1)

Hash Cond: ("outer".ps_partkey = "inner".p_partkey)

->  Seq Scan on partsupp  (cost=0.00..26287.00 rows=800000 width=19)
(actual time=0.01..2784.12 rows=800000 loops=1)

->  Hash  (cost=7867.00..7867.00 rows=320 width=4) (actual
time=1215.38..1215.38 rows=0 loops=1)

    ->  Seq Scan on part  (cost=0.00..7867.00 rows=320 width=4) (actual time=11.64..1187.37 rows=11637 loops=1)

          Filter: (p_name ~~ '%green%'::text)
 Total runtime: 119058.34 msec
(31 rows)