---

SELECT
    n.nspname AS schema_name,
    p.proname AS function_name,
    substr(
        p.prosrc,
        greatest(
            position('mail.api_new_message_group(' in lower(p.prosrc)) - 150,
            1
        ),
        600
    ) AS call_fragment
FROM pg_proc p
JOIN pg_namespace n
    ON n.oid = p.pronamespace
WHERE position(
          'mail.api_new_message_group('
          in lower(p.prosrc)
      ) > 0
ORDER BY n.nspname, p.proname;