1select 2 utid, 3 tid, 4 upid, 5 pid, 6 thread.name as threadName, 7 process.name as processName, 8 total_dur as totalDur 9from 10 thread 11 left join process using(upid) 12 left join (select upid, sum(dur) as total_dur 13 from sched join thread using(utid) 14 group by upid 15 ) using(upid) group by utid, upid 16order by total_dur desc, upid, utid 17