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 = 14 and p_type like '%COPPER' 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;
                                            plan                                            
--------------------------------------------------------------------------------------------
                                            sort                                           
                                                                                           
                                            join                                           
                                            hash                                           
                                                                                           
             join                                        join                              
             hash                                        indexnl                           
                                                                                           
        join         tablescan                        join                        tablescan
        hash         supplier                         hash                        partsupp 
                                                                                           
 tablescan tablescan           tablescan                 groupby                           
 region    nation              part                                                        
                                                           join                            
                                                           hash                            
                                                                                           
                                                     join              earlyprobe          
                                                     hash                                  
                                                                       tablescan          
                                                join         tablescan partsupp           
                                                hash         supplier                      
                                                                                           
                                         tablescan tablescan                               
                                         region    nation                                  
(24 rows)