yes but it seems like only one record was deleted each time, is there a way of mass deleting?

You can use a script to define which records you want to get deleted