Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 in_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 = s_ac.member_name_id))
- AND
- (s_fn_bl.SEQUENCE IS NULL OR s_fn_bl.SEQUENCE = s_st.SEQUENCE)
- ) os_fn_bl ON ps_fn_bl.fn = s_st.FUNCTION
- WHERE ac.stacktrace_id = s_st.id
- AND s_fn_bl.fn IS NOT NULL
- LIMIT 1
- )
- AND ac.member_name_id IS NULL
- GROUP BY ac.alloc_id, ac.txn_id, ac.byte_offset, ac.data_type_id, ac.subclass_id, ac.member_name_id
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement