Follow up on the original bug to make scheduler/ run faster:
https://bugs.chromium.org/p/chromium/issues/detail?id=641290#c56

Quote from:
https://bugs.chromium.org/p/chromium/issues/detail?id=641290#c62

You should try to avoid join with afe_jobs as you suggested. Adding redundant as you suggested is justified if it provides significant performance improvements. Once you do that and create index with (complete, aborted, abort_on) field, this query will take no time at all.

==================

The table change will require some lab down time, as the new field needs to be populated first.

One might need to create a local copy of the lab db, and test out how long the down time could be and how much performance gain with the new field.