EXPLAIN select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment from part, supplier, partsupp, nation, region where p_partkey = ps_partkey and s_suppkey = ps_suppkey and p_size = 30 and p_type like '%STEEL' and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = 'MIDDLE EAST' and ps_supplycost = ( select min(ps_supplycost) from partsupp, supplier, nation, region where p_partkey = ps_partkey and s_suppkey = ps_suppkey and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = 'MIDDLE EAST' ) order by s_acctbal desc, n_name, s_name, p_partkey LIMIT 100;
                                                             QUERY PLAN                                                              
-------------------------------------------------------------------------------------------------------------------------------------
 Limit  (cost=1874443.04..1874443.04 rows=1 width=190)
   ->  Sort  (cost=1874443.04..1874443.04 rows=1 width=190)
         Sort Key: supplier.s_acctbal, nation.n_name, supplier.s_name, part.p_partkey
         ->  Merge Join  (cost=641979.80..1874443.03 rows=1 width=190)
               Merge Cond: (part.p_partkey = partsupp.ps_partkey)
               Join Filter: (partsupp.ps_supplycost = (SubPlan 1))
               ->  Index Scan using part_pkey on part  (cost=0.43..102573.29 rows=9096 width=30)
                     Filter: (((p_type)::text ~~ '%STEEL'::text) AND (p_size = 30))
               ->  Materialize  (cost=641979.37..649940.37 rows=1592199 width=168)
                     ->  Sort  (cost=641979.37..645959.87 rows=1592199 width=168)
                           Sort Key: partsupp.ps_partkey
                           ->  Nested Loop  (cost=2.00..216736.26 rows=1592199 width=168)
                                 ->  Nested Loop  (cost=1.56..5807.62 rows=20000 width=164)
                                       Join Filter: (nation.n_regionkey = region.r_regionkey)
                                       ->  Seq Scan on region  (cost=0.00..1.06 rows=1 width=4)
                                             Filter: (r_name = 'MIDDLE EAST'::bpchar)
                                       ->  Hash Join  (cost=1.56..4556.56 rows=100000 width=168)
                                             Hash Cond: (supplier.s_nationkey = nation.n_nationkey)
                                             ->  Seq Scan on supplier  (cost=0.00..3180.00 rows=100000 width=142)
                                             ->  Hash  (cost=1.25..1.25 rows=25 width=34)
                                                   ->  Seq Scan on nation  (cost=0.00..1.25 rows=25 width=34)
                                 ->  Index Scan using i_ps_suppkey on partsupp  (cost=0.43..9.75 rows=80 width=12)
                                       Index Cond: (ps_suppkey = supplier.s_suppkey)
               SubPlan 1
                 ->  Aggregate  (cost=154.34..154.35 rows=1 width=4)
                       ->  Nested Loop  (cost=0.86..154.34 rows=3 width=4)
                             Join Filter: (nation_1.n_regionkey = region_1.r_regionkey)
                             ->  Seq Scan on region region_1  (cost=0.00..1.06 rows=1 width=4)
                                   Filter: (r_name = 'MIDDLE EAST'::bpchar)
                             ->  Nested Loop  (cost=0.86..153.06 rows=17 width=8)
                                   ->  Nested Loop  (cost=0.72..150.21 rows=17 width=8)
                                         ->  Index Scan using i_ps_partkey on partsupp partsupp_1  (cost=0.43..8.73 rows=17 width=8)
                                               Index Cond: (part.p_partkey = ps_partkey)
                                         ->  Index Scan using supplier_pkey on supplier supplier_1  (cost=0.29..8.31 rows=1 width=8)
                                               Index Cond: (s_suppkey = partsupp_1.ps_suppkey)
                                   ->  Index Scan using nation_pkey on nation nation_1  (cost=0.14..0.16 rows=1 width=8)
                                         Index Cond: (n_nationkey = supplier_1.s_nationkey)
(37 rows)