github.com/pf-qiu/concourse/v6@v6.7.3-0.20201207032516-1f455d73275f/atc/db/migration/migrations/1579713182_add_builds_status_index.up.sql (about)

     1  BEGIN;
     2    CREATE INDEX builds_job_id_succeeded_idx ON builds (job_id, id DESC) where status = 'succeeded';
     3  COMMIT;