L1

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
562656.369 100.00% 
 GroupAggregate (cost=22078.75..22079.03 rows=3 width=76) (actual time=560578.121..562656.369 rows=175 loops=1)
561349.131 99.77% 
   -> Sort (cost=22078.75..22078.78 rows=3 width=76) (actual time=560570.190..561349.131 rows=348760 loops=1)
         Sort Key: nation.n_name, date_part('year'::text, (orders.o_orderdate)::timestamp without time zone)
556266.824 98.86% 
         -> Nested Loop (cost=0.0..22078.68 rows=3 width=76) (actual time=5.260..556266.824 rows=348760 loops=1)
               Join Filter: (supplier.s_nationkey = nation.n_nationkey)
548080.157 97.41% 
               -> Nested Loop (cost=0.0..22073.58 rows=3 width=51) (actual time=5.191..548080.157 rows=348760 loops=1)
545894.598 97.02% 
                     -> Nested Loop (cost=0.0..22063.02 rows=3 width=55) (actual time=5.119..545894.598 rows=348760 loops=1)
452110.242 80.35% 
                           -> Nested Loop (cost=0.0..22052.1 rows=3 width=55) (actual time=5.032..452110.242 rows=348760 loops=1)
13916.015 2.47% 
                                 -> Nested Loop (cost=0.0..14451.95 rows=1282 width=23) (actual time=0.119..13916.015 rows=46548 loops=1)
530.623 0.09% 
                                       -> Seq Scan on part (cost=0.0..8459.26 rows=320 width=4) (actual time=0.029..530.623 rows=11637 loops=1)
                                             Filter: ((p_name)::text ~~ '%green%'::text)
13324.365 2.37% 
                                       -> Index Scan using partsupp_1_idx on partsupp (cost=0.0..18.39 rows=19 width=19) (actual time=1.088..1.145 rows=4 loops=11637)
                                             Index Cond: (part.p_partkey = partsupp.ps_partkey)
437783.940 77.81% 
                                 -> Index Scan using lineitem_1_idx on lineitem (cost=0.0..5.9 rows=1 width=44) (actual time=1.647..9.405 rows=7 loops=46548)
                                       Index Cond: ((partsupp.ps_partkey = lineitem.l_partkey) AND (partsupp.ps_suppkey = lineitem.l_suppkey))
93118.920 16.55% 
                           -> Index Scan using orders_pkey on orders (cost=0.0..3.62 rows=1 width=8) (actual time=0.266..0.267 rows=1 loops=348760)
                                 Index Cond: (orders.o_orderkey = lineitem.l_orderkey)
1395.040 0.25% 
                     -> Index Scan using supplier_pkey on supplier (cost=0.0..3.5 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=348760)
                           Index Cond: (supplier.s_suppkey = lineitem.l_suppkey)
3138.840 0.56% 
               -> Seq Scan on nation (cost=0.0..1.25 rows=25 width=33) (actual time=0.002..0.009 rows=25 loops=348760)
Run-time
9 minutes 22.656954 seconds (562656.954 ms)