add completed jobs index
Testing in development would indicate:
create index idx_jobs_completed on jobs (status,job_id) where status = 'Completed';
speeds up some of our job status queries for workflow code significantly. It should remain a small index due to the where clause...
It would be good to add this to the official sql schema and roll into the upcoming v3_0_0 release.