diff options
author | Stan Hu <stanhu@gmail.com> | 2017-02-16 12:21:19 +0300 |
---|---|---|
committer | Stan Hu <stanhu@gmail.com> | 2017-02-16 12:25:27 +0300 |
commit | 1df24eaf409d2d760b554c484bd72bf4f32826a8 (patch) | |
tree | 0f8779ed885e52b7dc8e9cffab0534e69253126c /shared | |
parent | 58cc360a45cb03049745668a0134cea1b14b2d9e (diff) |
Add index for slow queries in BuildsController#indexsh-add-ci-build-indexes
The worst queries in loading this page looked like this:
```
SELECT COUNT("ci_builds"."id") FROM "ci_builds" WHERE "ci_builds"."type" IN ('Ci::Build') AND "ci_builds"."gl_project_id" = $1 AND ("ci_builds"."status" != $2) [["gl_project_id", 10], ["status", "created"]]
```
This lead to a bitmap heap scan that took 6-7 seconds in production.
Closes #27389
Diffstat (limited to 'shared')
0 files changed, 0 insertions, 0 deletions