grahamc/hydra2 - Change GUHKIKQRAVZD6DLK34XY46EQEYCE2MM5HLOBD76UBC3VPSCLGU4AC

hydra.sql: add an index for slow queries in production

These queries used to use (jobset, project) based indexes, and the addition of jobset_id makes most of those indexes unusable now.

Created by Graham Christensen on February 11, 2020

GUHKIKQRAVZD6DLK34XY46EQEYCE2MM5HLOBD76UBC3VPSCLGU4AC

Dependencies

[2] OT4YGU4Q2ADFH372RUWU7FJCNOSKPGEBIFZQ5ZGABUSAHTDDTLCAC
[3] APURLT2Q3OKS6VF4HUWI3MGENXAKSSUDXI7CQOEGCRTYJRGUNT6QC
[4] N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC
[5] D5QIOJGPKQJIYBUCSC3MFJ3TXLPNZ2XMI37GXMFRVRFWWR2VMTFAC

In channels

main

Change contents

Insertion in src/sql/hydra.sql at line 685 [4.1]

[3.100]

[2.0]

create index IndexBuildsOnJobsetIdFinishedId on Builds(id DESC, finished, job, jobset_id);

File addition: upgrade-65.sql (----------)

[5.3004]

-- Add an index like IndexBuildsOnJobFinishedId using jobset_id
create index IndexBuildsOnJobsetIdFinishedId on Builds(id DESC, finished, job, jobset_id);