
set join_cache_level=0;
explain format=json
SELECT * 
FROM 
  t 
  JOIN nation  ON (t.a = nation.n_nationkey) 
  LEFT JOIN region ON ( r_regionkey = n_regionkey )
  JOIN supplier ON ( s_nationkey = n_nationkey )
  JOIN partsupp ON ( s_suppkey = ps_suppkey ) 
  JOIN lineitem ON ( ps_partkey = l_partkey ) 
  JOIN orders ON ( l_orderkey = o_orderkey ) 
  JOIN customer 
WHERE o_totalprice = 151 OR c_nationkey = s_nationkey AND s_acctbal > 187;



