From d0fab643dc51341f1b67cc0e0a553bb67d93bd2b Mon Sep 17 00:00:00 2001
From: Aleksandr Nogikh <nogikh@google.com>
Date: Fri, 27 Oct 2023 14:40:41 +0200
Subject: dashboard: speed up Job query for graphs

Add a Namespace x Type index and use it to speed up graphs generation.
---
 dashboard/app/graphs.go  | 3 ++-
 dashboard/app/index.yaml | 5 +++++
 2 files changed, 7 insertions(+), 1 deletion(-)

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
-- 
cgit mrf-deployment