How to query actual "Running" duration for specific slices in slices table?

[BoJunHuang]

I had a repeated task which would be executed every 100ms. I use following SQL command to calculate the average duration of this task:

SELECT AVG(dur) FROM slice WHERE name = 'my_tag'

But when I look into the detail information of each slice on UI, the duration field sometimes might be sum of 3 values: Running, Runnable and Runnable (Preempted). If I want the actual Running duration (exclude Runnable and Runnable (Preempted)), should I use sched_slice instead? Any example SQL command is appreciated.

[LalitMaganti]

You can do this very easily with the standard library of trace processor: https://perfetto.dev/docs/analysis/stdlib-docs#slices-cpu_time. Specifically you want the thread_slice_cpu_time table.

If you want the average across slices as in your example, you would do:

INCLUDE PERFETTO MODULE slices.cpu_time;

SELECT AVG(cpu_time) FROM thread_slice_cpu_time WHERE name = 'my_tag'