So right now spotting queries that are being too resource intensive for no reason (such as: running 9 concurrent and exactly-the-same queries!) and swatting them is a bit hard. It involves:
- Finding which user is running these
- Killing the query
- Commenting out crontabs / suspending / killing jobs
- Emailing the user
We need to automate a fair bit more of this.