Add Renderthread frame times for CUJ jank tracking
* Add a new table android_sysui_cuj_missed_frames_render_thread_times
that contains frame boundaries for the renderthread period of an
app frame. This will allow greater classification accuracy for jank
causes based on render thread slices.
Change-Id: Iacd2d951356a67a2ec33b1ec71bf3f73f288de8c
diff --git a/src/trace_processor/metrics/sql/android/android_sysui_cuj.sql b/src/trace_processor/metrics/sql/android/android_sysui_cuj.sql
index 9785e32..7acfd3e 100644
--- a/src/trace_processor/metrics/sql/android/android_sysui_cuj.sql
+++ b/src/trace_processor/metrics/sql/android/android_sysui_cuj.sql
@@ -328,6 +328,14 @@
ts_render_thread_end - ts_main_thread_start AS dur
FROM android_sysui_cuj_missed_frames;
+DROP TABLE IF EXISTS android_sysui_cuj_missed_frames_render_thread_times;
+CREATE TABLE android_sysui_cuj_missed_frames_render_thread_times AS
+SELECT
+ *,
+ ts_render_thread_start AS ts,
+ dur_render_thread AS dur
+FROM android_sysui_cuj_missed_frames;
+
DROP TABLE IF EXISTS android_sysui_cuj_jit_slices_join_table;
CREATE VIRTUAL TABLE android_sysui_cuj_jit_slices_join_table
USING span_join(android_sysui_cuj_missed_frames_hwui_times partitioned frame_number, android_sysui_cuj_jit_slices);
