hydra.sql: add an index for slow queries in production
[?]
Feb 11, 2020, 5:52 PM
GUHKIKQRAVZD6DLK34XY46EQEYCE2MM5HLOBD76UBC3VPSCLGU4ACDependencies
- [2]
OT4YGU4QBuilds: index literally what latest-finished queries - [*]
N22GPKYT* Put info about logs / build products in the DB. - [*]
APURLT2QRevert "Apply IndexBuildsOnJobFinishedId to unfinished builds only" - [*]
D5QIOJGP* Move everything up one directory.
Change contents
- edit in src/sql/hydra.sql at line 685
create index IndexBuildsOnJobsetIdFinishedId on Builds(id DESC, finished, job, jobset_id); - file addition: upgrade-65.sql[6.3004]
-- Add an index like IndexBuildsOnJobFinishedId using jobset_idcreate index IndexBuildsOnJobsetIdFinishedId on Builds(id DESC, finished, job, jobset_id);