EXPLAIN
-- (ANALYZE, BUFFERS)
SELECT ac.alloc_id, ac.txn_id, MAX(ac.ac_type) AS TYPE, ac.subclass_id AS subclass_id, ac.member_name_id, ac.byte_offset, ac.data_type_id
            FROM accesses_flat ac
            WHERE ac.txn_id IS NOT NULL
            AND NOT EXISTS
            (
                -- Get all accesses that happened on an init path or accessed a blacklisted member
                SELECT 1
                FROM stacktraces AS s_st
                LEFT JOIN (SELECT *
                           FROM function_blacklist sfn_bl
                           WHERE
                      ((in_sfn_bl .subclass_id IS NULL  AND s_fn_bl.member_name_id IS NULL) -- globally blacklisted function
                      OR
                      (s_fn_bl.subclass_id = s_ac.subclass_id AND s_fn_bl.member_name_id IS NULL) -- for this data type blacklisted
                      OR
                      (s_fn_bl.subclass_id = s_ac.subclass_id AND s_fn_bl.member_name_id = ac.member_name_id))
                           AND
                       (s_fn_bl.SEQUENCE IS NULL OR s_fn_bl.SEQUENCE = s_st.SEQUENCE)
                    ) os_fn_bl ON os_fn_bl.fn = s_st.FUNCTION
                WHERE ac.stacktrace_id = s_st.id
                AND os_fn_bl.fn IS NOT NULL
                LIMIT 1
            )
            AND NOT EXISTS (SELECT 1
             FROM member_blacklist m_bl
             WHERE m_bl.subclass_id = ac.subclass_id
             AND m_bl.member_name_id = ac.member_name_id)
            GROUP BY ac.alloc_id, ac.txn_id, ac.byte_offset, ac.data_type_id, ac.subclass_id, ac.member_name_id