1SELECT 2 ts, 3 tid, 4 CAST(SUBSTR(slices.name, 18) AS int) AS cpu, 5 CAST(key AS int) AS freq, 6 int_value AS time_ms 7FROM slices 8JOIN thread_track ON (slices.track_id = thread_track.id) 9JOIN thread USING (utid) 10JOIN args USING (arg_set_id) 11WHERE slices.name LIKE "time_in_state.%" 12ORDER BY ts, tid, cpu, key; 13