The full schema isn’t listed, but the indices don’t make sense to me. (id, cluster_id) sounds like it could / should be the PK If the jobs are cleared once th

The full schema isn’t listed, but the indices don’t make sense to me. (id, cluster_id) sounds like it could / should be the PK If the jobs are cleared once they’ve succeeded, and presumably retried if they’ve failed or stalled, then the table should be quite small; so small, that a. The query planner is unlikely to use the partial index on (status) b. The bloat from the rapidity of DELETEs likely overshadows the live tuple size.