Timebox each delete query to prevent cases where db instance getting throttled

[aezomz]

Time box each delete query, especially the long tail deletion.

1. for each delete with limit 1000 -> relatively fast due to early return
2. until the remaining <1000 -> this is slow and normally does a deeper scan based on the query plan and scanning, chances of this being stucked is much higher

Track the deletion duration and it shouldnt exceed 1 minute -default (configurable)
If exceeded, safely abort / kill the query.