EXPLAIN select p_brand, p_type, p_size, count(distinct ps_suppkey) as supplier_cnt from partsupp, part where p_partkey = ps_partkey and p_brand <> 'Brand#22' and p_type not like 'ECONOMY BURNISHED%' and p_size in (31, 29, 40, 3, 46, 7, 20, 2) and ps_suppkey not in ( select s_suppkey from supplier where s_comment like '%Customer%Complaints%' ) group by p_brand, p_type, p_size order by supplier_cnt desc, p_brand, p_type, p_size;
             plan              
-------------------------------
             sort             
                              
            groupby           
                              
         rightantijoin        
         hash                 
                              
 tablescan        join        
 supplier         hash        
                              
           tablescan tablescan
           part      partsupp 
(12 rows)