We've been facing a lot of performance issues, specially related to this query:

SELECT COUNT(DISTINCT t.triggerid) AS cnt,
t.status,
t.value
FROM triggers t
WHERE NOT EXISTS(SELECT f.functionid
FROM functions f JOIN items...