trace_processor/parsing/thread_time_in_state.sql

SELECT
  ts,
  tid,
  EXTRACT_ARG(counter.arg_set_id, 'time_in_state_cpu_id') AS cpu,
  EXTRACT_ARG(counter.arg_set_id, 'freq') AS freq,
  CAST(value AS INT) time_ms
FROM counter
JOIN thread_counter_track ON (counter.track_id = thread_counter_track.id)
JOIN thread USING (utid)
WHERE thread_counter_track.name = 'time_in_state'
ORDER BY ts, tid, cpu, freq;