diff options
| author | Aleksandr Nogikh <nogikh@google.com> | 2023-10-27 14:40:41 +0200 |
|---|---|---|
| committer | Aleksandr Nogikh <nogikh@google.com> | 2023-10-27 12:50:42 +0000 |
| commit | d0fab643dc51341f1b67cc0e0a553bb67d93bd2b (patch) | |
| tree | 3ce73afaf545e76999058bb2f6ef8b1066288683 | |
| parent | bf285f0cf1f7863e0b0d17980de703fab89476bb (diff) | |
dashboard: speed up Job query for graphs
Add a Namespace x Type index and use it to speed up graphs generation.
| -rw-r--r-- | dashboard/app/graphs.go | 3 | ||||
| -rw-r--r-- | dashboard/app/index.yaml | 5 |
2 files changed, 7 insertions, 1 deletions
diff --git a/dashboard/app/graphs.go b/dashboard/app/graphs.go index 33a478682..125b909a6 100644 --- a/dashboard/app/graphs.go +++ b/dashboard/app/graphs.go @@ -138,13 +138,14 @@ func handleGraphLifetimes(c context.Context, w http.ResponseWriter, r *http.Requ var jobs []*Job keys, err := db.NewQuery("Job"). Filter("Namespace=", hdr.Namespace). + Filter("Type=", JobBisectCause). GetAll(c, &jobs) if err != nil { return err } causeBisects := make(map[string]*Job) for i, job := range jobs { - if job.Type != JobBisectCause || len(job.Commits) != 1 { + if len(job.Commits) != 1 { continue } causeBisects[keys[i].Parent().StringID()] = job diff --git a/dashboard/app/index.yaml b/dashboard/app/index.yaml index c4c6ceaa8..35068ec66 100644 --- a/dashboard/app/index.yaml +++ b/dashboard/app/index.yaml @@ -243,3 +243,8 @@ indexes: - name: Type - name: Finished direction: desc + +- kind: Job + properties: + - name: Namespace + - name: Type |