Ok, looks like it’s running 3 copies of this query (with 3 different pids)
DELETE FROM user_actions USING user_actions ua2
WHERE ( user_actions.action_type = ua2.action_type AND
user_actions.user_id = ua2.user_id AND
user_actions.acting_user_id = ua2.acting_user_id AND
user_actions.target_post_id = ua2.target_post_id AND
user_actions.target_post_id > 0 AND
user_actions.id > ua2.id
)
Full copy/paste here: http://pastebin.com/pTTThKir
I’ll let it run for a while and see what happens. Maybe I’m just being impatient