set enable_memoize = off;
set enable_mergejoin = off;
set enable_hashjoin = off;
--set enable_nestloop = off;

explain analyze
    SELECT
       COUNT(*)
    FROM
       t1
    LEFT JOIN
        t2
            ON
            t2.b = t1.a
            AND
            t2.c = 0
            ;

