commit c519690a33a58b0a72d51c230faa0765de8d0be4
author Hector Dearman <hjd@google.com> Mon Jul 04 12:23:28 2022 +0000
committer Gerrit Code Review <noreply-gerritcodereview@google.com> Mon Jul 04 12:23:28 2022 +0000
tree 497186cb36f92ccbe0a52fdc104ae2754afd01f0
parent 54009f2b3d1032f2c1b6238fd594d34fe8e20cc6
parent 912e4b2ddcdf5566fd764db3d49ca4a563bc730e

Merge "[ui] optimize sched subquery in process sorting"

ui/src/controller/track_decider.ts

diff --git a/ui/src/controller/track_decider.ts b/ui/src/controller/track_decider.ts
index 769c922..32ac21e 100644
--- a/ui/src/controller/track_decider.ts
+++ b/ui/src/controller/track_decider.ts
@@ -1262,9 +1262,14 @@
       union
       select distinct(upid) as upid, 0 as utid from heap_graph_object
     ) the_tracks
-    left join (select upid, sum(dur) as total_dur
-      from sched join thread using(utid)
-      where dur != -1 and utid != 0
+    left join (
+      select upid, sum(thread_total_dur) as total_dur
+      from (
+        select utid, sum(dur) as thread_total_dur
+        from sched where dur != -1 and utid != 0
+        group by utid
+      )
+      join thread using (utid)
       group by upid
     ) using(upid)
     left join (