Android11/external/perfetto/test/trace_processor/slice_with_pid.sql

select s.name, dur, tid, pid
from slice s
join thread_track t on s.track_id = t.id
join thread using(utid)
left join process using(upid);