### \u8fdb\u7a0b\u4e2d\u5404\u7ebf\u7a0b\u4f18\u5148\u7ea7\u67e5\u8be2
\n“`
\nselect process.name as process_name,
\n process.pid as process_pid,
\n thread.name as thread_name,
\n thread.tid,
\n sched.priority as priority
\nfrom sched
\n inner join thread using(utid)
\n inner join process using(upid)
\nwhere process.pid in(28058,28011) \/*\u8f93\u5165\u591a\u4e2a\u53c2\u6570*\/
\ngroup by thread.tid
\norder by priority
\n“`
\n### \u8fdb\u7a0b\u5728\u5404cpu\u8fd0\u884c\u65f6\u95f4
\n“`
\nselect process.name as process_name,
\n process.pid as process_pid,
\n sched.cpu,
\n sum(sched.dur)\/1e6
\nfrom sched
\n inner join thread using(utid)
\n inner join process using(upid)
\nwhere process.pid in(28058) \/*\u8f93\u5165\u8fdb\u7a0bpid\u53c2\u6570*\/
\n and sched.ts>= 16850396073998 and sched.ts <= 16851833181075\/*\u8f93\u5165\u5f00\u59cb\u4e0e\u7ed3\u675f\u65f6\u95f4 eg:16850396073998 \u5f00\u59cb\u65f6\u95f4 16851833181075 \u7ed3\u675f\u65f6\u95f4*\/\ngroup by sched.cpu\norder by sched.cpu \n```\n### \u5404\u7ebf\u7a0bD\u72b6\u6001block_function \u76f8\u5173\u65b9\u6cd5\u7edf\u8ba1\n```\nselect * \nfrom (\n select process.name as process_name,\n process.pid as process_pid,\n thread.name as thread_name,\n thread.tid as thread_tid,\n blocked_function,\n sum(dur)\/1e3 as dur_time_ms\n from thread_state \n inner join thread using(utid)\n inner join process using(upid)\n where thread.tid in (5593,5594,5595,5596,5597,5598,5599,5600) \/*\u987a\u5e8f\u5199\u7ebf\u7a0b\uff1a5576 \u968f\u673a\u8bfb\u5199\u7ebf\u7a0b\uff1a5593,5594,5595,5596,5597,5598,5599,5600*\/\n and blocked_function not null \n group by blocked_function\n )\norder by dur_time_ms desc\n```\n\n### \u7edf\u8ba1\u7ebf\u7a0b\u5728\u4e00\u6bb5\u65f6\u95f4\u5185\u5404cpu\u8fd0\u884c\u65f6\u95f4\n```\nselect thread.name as thread_name,\n thread.tid as thread_tid,\n sched.cpu as run_cpu_idx ,\n sum(dur)\/1e6 as run_cpu_duration_ms\nfrom sched \ninner join thread using (utid)\nwhere thread.tid = 13087 \n and sched.ts >= (113286094474357 -1) and sched.ts <= ( 113286094474357 + 347372616)\ngroup by thread.tid,sched.cpu\n```\n### \u7edf\u8ba1\u8fdb\u7a0b\u5728\u4e00\u6bb5\u65f6\u95f4\u5185\u5404cpu\u8fd0\u884c\u65f6\u95f4\nselect process.name as process_name,\n sched.cpu as run_cpu_idx ,\n sum(dur)\/1e6 as run_cpu_duration_ms\nfrom sched \ninner join thread using (utid)\ninner join process using (upid)\nwhere process.pid = 13087 \n and sched.ts >= (113286094474357 -1) and sched.ts <= ( 113286094474357 + 347372616)\ngroup by sched.cpu\n\n\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"