SELECT COUNT(*) FROM (SELECT tgargs from pg_trigger tr LEFT JOIN pg_depend dep ON dep.objid=tr.oid AND deptype = 'i' LEFT JOIN pg_constraint co ON refobjid = co.oid AND contype = 'f' WHERE co.oid IS NULL GROUP BY tgargs HAVING count(1) = 3) AS foo