DELETE
FROM PUBLIC.mail_followers
WHERE mail_followers.id NOT IN (
 SELECT MIN(mail_followers.id)
 FROM PUBLIC.mail_followers
 GROUP BY
 mail_followers.res_model,
 mail_followers.partner_id,
 mail_followers.res_id
);