Postgres using 100% of CPU

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 :slight_smile:

2 Likes