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

[?]
Feb 11, 2020, 5:52 PM
GUHKIKQRAVZD6DLK34XY46EQEYCE2MM5HLOBD76UBC3VPSCLGU4AC

Dependencies

  • [2] OT4YGU4Q Builds: index literally what latest-finished queries
  • [*] N22GPKYT * Put info about logs / build products in the DB.
  • [*] APURLT2Q Revert "Apply IndexBuildsOnJobFinishedId to unfinished builds only"
  • [*] D5QIOJGP * Move everything up one directory.

Change contents

  • edit in src/sql/hydra.sql at line 685
    [5.100]
    [2.0]
    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_id
    create index IndexBuildsOnJobsetIdFinishedId on Builds(id DESC, finished, job, jobset_id);