进程中各线程优先级查询

select process.name as process_name,
       process.pid as process_pid,
       thread.name as thread_name,
       thread.tid,
       sched.priority as priority
from sched 
    inner join thread using(utid)
    inner join process using(upid)
where process.pid in(28058,28011) /*输入多个参数*/
group by thread.tid
order by priority 

进程在各cpu运行时间

select process.name as process_name,
       process.pid as process_pid,
       sched.cpu,
       sum(sched.dur)/1e6
from sched 
    inner join thread using(utid)
    inner join process using(upid)
where process.pid in(28058) /*输入进程pid参数*/
      and sched.ts>= 16850396073998 and sched.ts <= 16851833181075/*输入开始与结束时间 eg:16850396073998 开始时间 16851833181075 结束时间*/
group by sched.cpu
order by sched.cpu 

各线程D状态block_function 相关方法统计

select * 
from (
  select process.name as process_name,
        process.pid as process_pid,
        thread.name as thread_name,
        thread.tid as thread_tid,
        blocked_function,
        sum(dur)/1e3 as dur_time_ms
  from thread_state 
    inner join thread using(utid)
    inner join process using(upid)
  where thread.tid in (5593,5594,5595,5596,5597,5598,5599,5600) /*顺序写线程：5576   随机读写线程：5593,5594,5595,5596,5597,5598,5599,5600*/
        and blocked_function not null 
  group by  blocked_function
  )
order by dur_time_ms desc

统计线程在一段时间内各cpu运行时间

select thread.name as thread_name,
       thread.tid as thread_tid,
       sched.cpu as run_cpu_idx ,
       sum(dur)/1e6 as run_cpu_duration_ms
from sched 
inner join thread using (utid)
where thread.tid = 13087 
      and sched.ts >= (113286094474357 -1) and sched.ts <= ( 113286094474357 + 347372616)
group by  thread.tid,sched.cpu

统计进程在一段时间内各cpu运行时间

select process.name as process_name, sched.cpu as run_cpu_idx , sum(dur)/1e6 as run_cpu_duration_ms from sched inner join thread using (utid) inner join process using (upid) where process.pid = 13087 and sched.ts >= (113286094474357 -1) and sched.ts <= ( 113286094474357 + 347372616) group by sched.cpu