WITH active_db AS (SELECT t.tgname AS trigger_name,
c.relname AS table_name
FROM pg_catalog.pg_namespace n,
pg_catalog.pg_class c,
pg_catalog.pg_trigger t
WHERE n.oid = c.relnamespace 
AND c.oid = t.tgrelid 
AND t.tgisinternal=FALSE
AND n.nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)
UNION ALL SELECT r.rulename, r.tablename
FROM 
pg_catalog.pg_rules r,  pg_catalog.pg_namespace n, pg_catalog.pg_authid u
WHERE r.schemaname = n.nspname 
AND n.nspowner = u.oid 
AND (n.nspname = 'public' OR u.rolname <> 'postgres'))
SELECT pattern, Count(*) AS cnt
FROM (SELECT replace(trigger_name, lower(table_name), 'table') AS pattern
FROM active_db) AS pat
GROUP BY pattern
ORDER BY Count(*) DESC, pattern;