T2

Change label
Query Plan as raw text
Summary
Time Node
Node (ms) Percent
36913.251 100.00% 
 Sort (cost=37569.02..37569.04 rows=1 width=216) (actual time=36913.120..36913.251 rows=460 loops=1)
   Sort Key: supplier.s_acctbal, nation.n_name, supplier.s_name, part.p_partkey
36910.221 99.99% 
   -> Hash Join (cost=9961.3..37568.99 rows=1 width=216) (actual time=1387.566..36910.221 rows=460 loops=1)
         Hash Cond: (partsupp.ps_partkey = part.p_partkey)
         Join Filter: (partsupp.ps_supplycost = (subplan))
36281.820 98.29% 
         -> Nested Loop (cost=0.0..16530.72 rows=160042 width=198) (actual time=25.325..36281.820 rows=158960 loops=1)
35.197 0.10% 
               -> Nested Loop (cost=0.0..190.11 rows=2000 width=187) (actual time=5.041..35.197 rows=1987 loops=1)
1.672 0.00% 
                     -> Nested Loop (cost=0.0..2.77 rows=5 width=33) (actual time=1.641..1.672 rows=5 loops=1)
                           Join Filter: (nation.n_regionkey = region.r_regionkey)
1.611 0.00% 
                           -> Seq Scan on region (cost=0.0..1.09 rows=1 width=4) (actual time=1.610..1.611 rows=1 loops=1)
                                 Filter: (r_name = 'EUROPE'::bpchar)
0.032 0.00% 
                           -> Seq Scan on nation (cost=0.0..1.25 rows=25 width=37) (actual time=0.020..0.032 rows=25 loops=1)
31.120 0.08% 
                     -> Index Scan using supplier_3_idx on supplier (cost=0.0..30.47 rows=400 width=162) (actual time=2.677..6.224 rows=397 loops=5)
                           Index Cond: (supplier.s_nationkey = nation.n_nationkey)
36109.751 97.82% 
               -> Index Scan using partsupp_2_idx on partsupp (cost=0.0..6.77 rows=80 width=19) (actual time=2.284..18.173 rows=80 loops=1987)
                     Index Cond: (supplier.s_suppkey = partsupp.ps_suppkey)
416.399 1.13% 
         -> Hash (cost=9959.38..9959.38 rows=110 width=33) (actual time=416.399..416.399 rows=747 loops=1)
415.189 1.12% 
               -> Seq Scan on part (cost=0.0..9959.38 rows=110 width=33) (actual time=0.215..415.189 rows=747 loops=1)
                     Filter: ((p_size = 15) AND ((p_type)::text ~~ '%BRASS'::text))
         SubPlan
127.758 0.35% 
           -> Aggregate (cost=105.39..105.4 rows=1 width=11) (actual time=0.198..0.199 rows=1 loops=642)
122.622 0.33% 
                 -> Nested Loop (cost=1.69..105.35 rows=4 width=11) (actual time=0.150..0.191 rows=2 loops=642)
                       Join Filter: (nation.n_regionkey = region.r_regionkey)
3.210 0.01% 
                       -> Seq Scan on region (cost=0.0..1.09 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=642)
                             Filter: (r_name = 'EUROPE'::bpchar)
116.844 0.32% 
                       -> Hash Join (cost=1.69..103.93 rows=19 width=15) (actual time=0.136..0.182 rows=4 loops=642)
                             Hash Cond: (supplier.s_nationkey = nation.n_nationkey)
112.350 0.30% 
                             -> Nested Loop (cost=0.0..101.84 rows=19 width=15) (actual time=0.133..0.175 rows=4 loops=642)
90.522 0.25% 
                                   -> Index Scan using partsupp_1_idx on partsupp (cost=0.0..20.9 rows=19 width=15) (actual time=0.125..0.141 rows=4 loops=642)
                                         Index Cond: ($0 = ps_partkey)
15.408 0.04% 
                                   -> Index Scan using supplier_pkey on supplier (cost=0.0..4.24 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=2568)
                                         Index Cond: (supplier.s_suppkey = partsupp.ps_suppkey)
0.046 0.00% 
                             -> Hash (cost=1.25..1.25 rows=25 width=8) (actual time=0.046..0.046 rows=25 loops=1)
0.020 0.00% 
                                   -> Seq Scan on nation (cost=0.0..1.25 rows=25 width=8) (actual time=0.006..0.020 rows=25 loops=1)
Run-time
36.913769 seconds (36913.769 ms)