third_party/perfetto/src/trace_processor/metrics/sql/android/android_hwui_metric.sql - cobalt - Git at Google

 --
 -- Copyright 2020 The Android Open Source Project
 --
 -- Licensed under the Apache License, Version 2.0 (the "License");
 -- you may not use this file except in compliance with the License.
 -- You may obtain a copy of the License at
 --
 --     https://www.apache.org/licenses/LICENSE-2.0
 --
 -- Unless required by applicable law or agreed to in writing, software
 -- distributed under the License is distributed on an "AS IS" BASIS,
 -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 --


 -- TOP processes that have a RenderThread, sorted by CPU time on RT
 DROP VIEW IF EXISTS hwui_processes;
 CREATE VIEW hwui_processes AS
 SELECT
   process.name AS process_name,
   process.upid AS process_upid,
   CAST(SUM(sched.dur) / 1e6 AS INT64) AS rt_cpu_time_ms,
   thread.utid AS render_thread_id
 FROM sched
 JOIN thread ON (thread.utid = sched.utid AND thread.name = 'RenderThread')
 JOIN process ON (process.upid = thread.upid)
 GROUP BY process.name
 ORDER BY rt_cpu_time_ms DESC;

 DROP VIEW IF EXISTS hwui_draw_frame;
 CREATE VIEW hwui_draw_frame AS
 SELECT
   count(*) AS draw_frame_count,
   max(dur) AS draw_frame_max,
   min(dur) AS draw_frame_min,
   avg(dur) AS draw_frame_avg,
   thread_track.utid AS render_thread_id
 FROM slice
 JOIN thread_track ON (thread_track.id = slice.track_id)
 WHERE slice.name GLOB 'DrawFrame*' AND slice.dur >= 0
 GROUP BY thread_track.utid;

 DROP VIEW IF EXISTS hwui_flush_commands;
 CREATE VIEW hwui_flush_commands AS
 SELECT
   count(*) AS flush_count,
   max(dur) AS flush_max,
   min(dur) AS flush_min,
   avg(dur) AS flush_avg,
   thread_track.utid AS render_thread_id
 FROM slice
 JOIN thread_track ON (thread_track.id = slice.track_id)
 WHERE slice.name = 'flush commands' AND slice.dur >= 0
 GROUP BY thread_track.utid;

 DROP VIEW IF EXISTS hwui_prepare_tree;
 CREATE VIEW hwui_prepare_tree AS
 SELECT
   count(*) AS prepare_tree_count,
   max(dur) AS prepare_tree_max,
   min(dur) AS prepare_tree_min,
   avg(dur) AS prepare_tree_avg,
   thread_track.utid AS render_thread_id
 FROM slice
 JOIN thread_track ON (thread_track.id = slice.track_id)
 WHERE slice.name = 'prepareTree' AND slice.dur >= 0
 GROUP BY thread_track.utid;

 DROP VIEW IF EXISTS hwui_gpu_completion;
 CREATE VIEW hwui_gpu_completion AS
 SELECT
   count(*) AS gpu_completion_count,
   max(dur) AS gpu_completion_max,
   min(dur) AS gpu_completion_min,
   avg(dur) AS gpu_completion_avg,
   thread.upid AS process_upid
 FROM slice
 JOIN thread_track ON (thread_track.id = slice.track_id)
 JOIN thread ON (thread.name = 'GPU completion' AND thread.utid = thread_track.utid)
 WHERE slice.name GLOB 'waiting for GPU completion*' AND slice.dur >= 0
 GROUP BY thread_track.utid;

 DROP VIEW IF EXISTS hwui_ui_record;
 CREATE VIEW hwui_ui_record AS
 SELECT
   count(*) AS ui_record_count,
   max(dur) AS ui_record_max,
   min(dur) AS ui_record_min,
   avg(dur) AS ui_record_avg,
   thread.upid AS process_upid
 FROM slice
 JOIN thread_track ON (thread_track.id = slice.track_id)
 JOIN thread ON (thread.name = substr(process.name, -15) AND thread.utid = thread_track.utid)
 JOIN process ON (process.upid = thread.upid)
 WHERE slice.name = 'Record View#draw()' AND slice.dur >= 0
 GROUP BY thread_track.utid;

 DROP VIEW IF EXISTS hwui_shader_compile;
 CREATE VIEW hwui_shader_compile AS
 SELECT
   count(*) AS shader_compile_count,
   sum(dur) AS shader_compile_time,
   avg(dur) AS shader_compile_avg,
   thread_track.utid AS render_thread_id
 FROM slice
 JOIN thread_track ON (thread_track.id = slice.track_id)
 WHERE slice.name = 'shader_compile' AND slice.dur >= 0
 GROUP BY thread_track.utid;

 DROP VIEW IF EXISTS hwui_cache_hit;
 CREATE VIEW hwui_cache_hit AS
 SELECT
   count(*) AS cache_hit_count,
   sum(dur) AS cache_hit_time,
   avg(dur) AS cache_hit_avg,
   thread_track.utid AS render_thread_id
 FROM slice
 JOIN thread_track ON (thread_track.id = slice.track_id)
 WHERE slice.name = 'cache_hit' AND slice.dur >= 0
 GROUP BY thread_track.utid;

 DROP VIEW IF EXISTS hwui_cache_miss;
 CREATE VIEW hwui_cache_miss AS
 SELECT
   count(*) AS cache_miss_count,
   sum(dur) AS cache_miss_time,
   avg(dur) AS cache_miss_avg,
   thread_track.utid AS render_thread_id
 FROM slice
 JOIN thread_track ON (thread_track.id = slice.track_id)
 WHERE slice.name = 'cache_miss' AND slice.dur >= 0
 GROUP BY thread_track.utid;

 DROP VIEW IF EXISTS hwui_graphics_cpu_mem;
 CREATE VIEW hwui_graphics_cpu_mem AS
 SELECT
   max(value) AS graphics_cpu_mem_max,
   min(value) AS graphics_cpu_mem_min,
   avg(value) AS graphics_cpu_mem_avg,
   process_counter_track.upid AS process_upid
 FROM counter
 JOIN process_counter_track ON (counter.track_id = process_counter_track.id)
 WHERE name = 'HWUI CPU Memory' AND counter.value >= 0
 GROUP BY process_counter_track.upid;

 DROP VIEW IF EXISTS hwui_graphics_gpu_mem;
 CREATE VIEW hwui_graphics_gpu_mem AS
 SELECT
   max(value) AS graphics_gpu_mem_max,
   min(value) AS graphics_gpu_mem_min,
   avg(value) AS graphics_gpu_mem_avg,
   process_counter_track.upid AS process_upid
 FROM counter
 JOIN process_counter_track ON (counter.track_id = process_counter_track.id)
 WHERE name = 'HWUI Misc Memory' AND counter.value >= 0
 GROUP BY process_counter_track.upid;

 DROP VIEW IF EXISTS hwui_texture_mem;
 CREATE VIEW hwui_texture_mem AS
 SELECT
   max(value) AS texture_mem_max,
   min(value) AS texture_mem_min,
   avg(value) AS texture_mem_avg,
   process_counter_track.upid AS process_upid
 FROM counter
 JOIN process_counter_track ON (counter.track_id = process_counter_track.id)
 WHERE name = 'HWUI Texture Memory' AND counter.value >= 0
 GROUP BY process_counter_track.upid;

 DROP VIEW IF EXISTS hwui_all_mem;
 CREATE VIEW hwui_all_mem AS
 SELECT
   max(value) AS all_mem_max,
   min(value) AS all_mem_min,
   avg(value) AS all_mem_avg,
   process_counter_track.upid AS process_upid
 FROM counter
 JOIN process_counter_track ON (counter.track_id = process_counter_track.id)
 WHERE name = 'HWUI All Memory' AND counter.value >= 0
 GROUP BY process_counter_track.upid;

 DROP VIEW IF EXISTS android_hwui_metric_output;
 CREATE VIEW android_hwui_metric_output AS
 SELECT AndroidHwuiMetric(
   'process_info', (
     SELECT RepeatedField(
       ProcessRenderInfo(
         'process_name', process_name,
         'rt_cpu_time_ms', rt_cpu_time_ms,

         'draw_frame_count', hwui_draw_frame.draw_frame_count,
         'draw_frame_max', hwui_draw_frame.draw_frame_max,
         'draw_frame_min', hwui_draw_frame.draw_frame_min,
         'draw_frame_avg', hwui_draw_frame.draw_frame_avg,

         'flush_count', hwui_flush_commands.flush_count,
         'flush_max', hwui_flush_commands.flush_max,
         'flush_min', hwui_flush_commands.flush_min,
         'flush_avg', hwui_flush_commands.flush_avg,

         'prepare_tree_count', hwui_prepare_tree.prepare_tree_count,
         'prepare_tree_max', hwui_prepare_tree.prepare_tree_max,
         'prepare_tree_min', hwui_prepare_tree.prepare_tree_min,
         'prepare_tree_avg', hwui_prepare_tree.prepare_tree_avg,

         'gpu_completion_count', hwui_gpu_completion.gpu_completion_count,
         'gpu_completion_max', hwui_gpu_completion.gpu_completion_max,
         'gpu_completion_min', hwui_gpu_completion.gpu_completion_min,
         'gpu_completion_avg', hwui_gpu_completion.gpu_completion_avg,

         'ui_record_count', hwui_ui_record.ui_record_count,
         'ui_record_max', hwui_ui_record.ui_record_max,
         'ui_record_min', hwui_ui_record.ui_record_min,
         'ui_record_avg', hwui_ui_record.ui_record_avg,

         'shader_compile_count', hwui_shader_compile.shader_compile_count,
         'shader_compile_time', hwui_shader_compile.shader_compile_time,
         'shader_compile_avg', hwui_shader_compile.shader_compile_avg,

         'cache_hit_count', hwui_cache_hit.cache_hit_count,
         'cache_hit_time', hwui_cache_hit.cache_hit_time,
         'cache_hit_avg', hwui_cache_hit.cache_hit_avg,

         'cache_miss_count', hwui_cache_miss.cache_miss_count,
         'cache_miss_time', hwui_cache_miss.cache_miss_time,
         'cache_miss_avg', hwui_cache_miss.cache_miss_avg,

         'graphics_cpu_mem_max', CAST(hwui_graphics_cpu_mem.graphics_cpu_mem_max AS INT64),
         'graphics_cpu_mem_min', CAST(hwui_graphics_cpu_mem.graphics_cpu_mem_min AS INT64),
         'graphics_cpu_mem_avg', hwui_graphics_cpu_mem.graphics_cpu_mem_avg,

         'graphics_gpu_mem_max', CAST(hwui_graphics_gpu_mem.graphics_gpu_mem_max AS INT64),
         'graphics_gpu_mem_min', CAST(hwui_graphics_gpu_mem.graphics_gpu_mem_min AS INT64),
         'graphics_gpu_mem_avg', hwui_graphics_gpu_mem.graphics_gpu_mem_avg,

         'texture_mem_max', CAST(hwui_texture_mem.texture_mem_max AS INT64),
         'texture_mem_min', CAST(hwui_texture_mem.texture_mem_min AS INT64),
         'texture_mem_avg', hwui_texture_mem.texture_mem_avg,

         'all_mem_max', CAST(hwui_all_mem.all_mem_max AS INT64),
         'all_mem_min', CAST(hwui_all_mem.all_mem_min AS INT64),
         'all_mem_avg', hwui_all_mem.all_mem_avg
       )
     )
     FROM hwui_processes
     LEFT JOIN hwui_draw_frame ON (hwui_draw_frame.render_thread_id = hwui_processes.render_thread_id)
     LEFT JOIN hwui_flush_commands ON (hwui_flush_commands.render_thread_id = hwui_processes.render_thread_id)
     LEFT JOIN hwui_prepare_tree ON (hwui_prepare_tree.render_thread_id = hwui_processes.render_thread_id)
     LEFT JOIN hwui_gpu_completion ON (hwui_gpu_completion.process_upid = hwui_processes.process_upid)
     LEFT JOIN hwui_ui_record ON (hwui_ui_record.process_upid = hwui_processes.process_upid)
     LEFT JOIN hwui_shader_compile ON (hwui_shader_compile.render_thread_id = hwui_processes.render_thread_id)
     LEFT JOIN hwui_cache_hit ON (hwui_cache_hit.render_thread_id = hwui_processes.render_thread_id)
     LEFT JOIN hwui_cache_miss ON (hwui_cache_miss.render_thread_id = hwui_processes.render_thread_id)
     LEFT JOIN hwui_graphics_cpu_mem ON (hwui_graphics_cpu_mem.process_upid = hwui_processes.process_upid)
     LEFT JOIN hwui_graphics_gpu_mem ON (hwui_graphics_gpu_mem.process_upid = hwui_processes.process_upid)
     LEFT JOIN hwui_texture_mem ON (hwui_texture_mem.process_upid = hwui_processes.process_upid)
     LEFT JOIN hwui_all_mem ON (hwui_all_mem.process_upid = hwui_processes.process_upid)
   )
 );
	--
	-- Copyright 2020 The Android Open Source Project
	--
	-- Licensed under the Apache License, Version 2.0 (the "License");
	-- you may not use this file except in compliance with the License.
	-- You may obtain a copy of the License at
	--
	-- https://www.apache.org/licenses/LICENSE-2.0
	--
	-- Unless required by applicable law or agreed to in writing, software
	-- distributed under the License is distributed on an "AS IS" BASIS,
	-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
	-- See the License for the specific language governing permissions and
	-- limitations under the License.
	--


	-- TOP processes that have a RenderThread, sorted by CPU time on RT
	DROP VIEW IF EXISTS hwui_processes;
	CREATE VIEW hwui_processes AS
	SELECT
	process.name AS process_name,
	process.upid AS process_upid,
	CAST(SUM(sched.dur) / 1e6 AS INT64) AS rt_cpu_time_ms,
	thread.utid AS render_thread_id
	FROM sched
	JOIN thread ON (thread.utid = sched.utid AND thread.name = 'RenderThread')
	JOIN process ON (process.upid = thread.upid)
	GROUP BY process.name
	ORDER BY rt_cpu_time_ms DESC;

	DROP VIEW IF EXISTS hwui_draw_frame;
	CREATE VIEW hwui_draw_frame AS
	SELECT
	count(*) AS draw_frame_count,
	max(dur) AS draw_frame_max,
	min(dur) AS draw_frame_min,
	avg(dur) AS draw_frame_avg,
	thread_track.utid AS render_thread_id
	FROM slice
	JOIN thread_track ON (thread_track.id = slice.track_id)
	WHERE slice.name GLOB 'DrawFrame*' AND slice.dur >= 0
	GROUP BY thread_track.utid;

	DROP VIEW IF EXISTS hwui_flush_commands;
	CREATE VIEW hwui_flush_commands AS
	SELECT
	count(*) AS flush_count,
	max(dur) AS flush_max,
	min(dur) AS flush_min,
	avg(dur) AS flush_avg,
	thread_track.utid AS render_thread_id
	FROM slice
	JOIN thread_track ON (thread_track.id = slice.track_id)
	WHERE slice.name = 'flush commands' AND slice.dur >= 0
	GROUP BY thread_track.utid;

	DROP VIEW IF EXISTS hwui_prepare_tree;
	CREATE VIEW hwui_prepare_tree AS
	SELECT
	count(*) AS prepare_tree_count,
	max(dur) AS prepare_tree_max,
	min(dur) AS prepare_tree_min,
	avg(dur) AS prepare_tree_avg,
	thread_track.utid AS render_thread_id
	FROM slice
	JOIN thread_track ON (thread_track.id = slice.track_id)
	WHERE slice.name = 'prepareTree' AND slice.dur >= 0
	GROUP BY thread_track.utid;

	DROP VIEW IF EXISTS hwui_gpu_completion;
	CREATE VIEW hwui_gpu_completion AS
	SELECT
	count(*) AS gpu_completion_count,
	max(dur) AS gpu_completion_max,
	min(dur) AS gpu_completion_min,
	avg(dur) AS gpu_completion_avg,
	thread.upid AS process_upid
	FROM slice
	JOIN thread_track ON (thread_track.id = slice.track_id)
	JOIN thread ON (thread.name = 'GPU completion' AND thread.utid = thread_track.utid)
	WHERE slice.name GLOB 'waiting for GPU completion*' AND slice.dur >= 0
	GROUP BY thread_track.utid;

	DROP VIEW IF EXISTS hwui_ui_record;
	CREATE VIEW hwui_ui_record AS
	SELECT
	count(*) AS ui_record_count,
	max(dur) AS ui_record_max,
	min(dur) AS ui_record_min,
	avg(dur) AS ui_record_avg,
	thread.upid AS process_upid
	FROM slice
	JOIN thread_track ON (thread_track.id = slice.track_id)
	JOIN thread ON (thread.name = substr(process.name, -15) AND thread.utid = thread_track.utid)
	JOIN process ON (process.upid = thread.upid)
	WHERE slice.name = 'Record View#draw()' AND slice.dur >= 0
	GROUP BY thread_track.utid;

	DROP VIEW IF EXISTS hwui_shader_compile;
	CREATE VIEW hwui_shader_compile AS
	SELECT
	count(*) AS shader_compile_count,
	sum(dur) AS shader_compile_time,
	avg(dur) AS shader_compile_avg,
	thread_track.utid AS render_thread_id
	FROM slice
	JOIN thread_track ON (thread_track.id = slice.track_id)
	WHERE slice.name = 'shader_compile' AND slice.dur >= 0
	GROUP BY thread_track.utid;

	DROP VIEW IF EXISTS hwui_cache_hit;
	CREATE VIEW hwui_cache_hit AS
	SELECT
	count(*) AS cache_hit_count,
	sum(dur) AS cache_hit_time,
	avg(dur) AS cache_hit_avg,
	thread_track.utid AS render_thread_id
	FROM slice
	JOIN thread_track ON (thread_track.id = slice.track_id)
	WHERE slice.name = 'cache_hit' AND slice.dur >= 0
	GROUP BY thread_track.utid;

	DROP VIEW IF EXISTS hwui_cache_miss;
	CREATE VIEW hwui_cache_miss AS
	SELECT
	count(*) AS cache_miss_count,
	sum(dur) AS cache_miss_time,
	avg(dur) AS cache_miss_avg,
	thread_track.utid AS render_thread_id
	FROM slice
	JOIN thread_track ON (thread_track.id = slice.track_id)
	WHERE slice.name = 'cache_miss' AND slice.dur >= 0
	GROUP BY thread_track.utid;

	DROP VIEW IF EXISTS hwui_graphics_cpu_mem;
	CREATE VIEW hwui_graphics_cpu_mem AS
	SELECT
	max(value) AS graphics_cpu_mem_max,
	min(value) AS graphics_cpu_mem_min,
	avg(value) AS graphics_cpu_mem_avg,
	process_counter_track.upid AS process_upid
	FROM counter
	JOIN process_counter_track ON (counter.track_id = process_counter_track.id)
	WHERE name = 'HWUI CPU Memory' AND counter.value >= 0
	GROUP BY process_counter_track.upid;

	DROP VIEW IF EXISTS hwui_graphics_gpu_mem;
	CREATE VIEW hwui_graphics_gpu_mem AS
	SELECT
	max(value) AS graphics_gpu_mem_max,
	min(value) AS graphics_gpu_mem_min,
	avg(value) AS graphics_gpu_mem_avg,
	process_counter_track.upid AS process_upid
	FROM counter
	JOIN process_counter_track ON (counter.track_id = process_counter_track.id)
	WHERE name = 'HWUI Misc Memory' AND counter.value >= 0
	GROUP BY process_counter_track.upid;

	DROP VIEW IF EXISTS hwui_texture_mem;
	CREATE VIEW hwui_texture_mem AS
	SELECT
	max(value) AS texture_mem_max,
	min(value) AS texture_mem_min,
	avg(value) AS texture_mem_avg,
	process_counter_track.upid AS process_upid
	FROM counter
	JOIN process_counter_track ON (counter.track_id = process_counter_track.id)
	WHERE name = 'HWUI Texture Memory' AND counter.value >= 0
	GROUP BY process_counter_track.upid;

	DROP VIEW IF EXISTS hwui_all_mem;
	CREATE VIEW hwui_all_mem AS
	SELECT
	max(value) AS all_mem_max,
	min(value) AS all_mem_min,
	avg(value) AS all_mem_avg,
	process_counter_track.upid AS process_upid
	FROM counter
	JOIN process_counter_track ON (counter.track_id = process_counter_track.id)
	WHERE name = 'HWUI All Memory' AND counter.value >= 0
	GROUP BY process_counter_track.upid;

	DROP VIEW IF EXISTS android_hwui_metric_output;
	CREATE VIEW android_hwui_metric_output AS
	SELECT AndroidHwuiMetric(
	'process_info', (
	SELECT RepeatedField(
	ProcessRenderInfo(
	'process_name', process_name,
	'rt_cpu_time_ms', rt_cpu_time_ms,

	'draw_frame_count', hwui_draw_frame.draw_frame_count,
	'draw_frame_max', hwui_draw_frame.draw_frame_max,
	'draw_frame_min', hwui_draw_frame.draw_frame_min,
	'draw_frame_avg', hwui_draw_frame.draw_frame_avg,

	'flush_count', hwui_flush_commands.flush_count,
	'flush_max', hwui_flush_commands.flush_max,
	'flush_min', hwui_flush_commands.flush_min,
	'flush_avg', hwui_flush_commands.flush_avg,

	'prepare_tree_count', hwui_prepare_tree.prepare_tree_count,
	'prepare_tree_max', hwui_prepare_tree.prepare_tree_max,
	'prepare_tree_min', hwui_prepare_tree.prepare_tree_min,
	'prepare_tree_avg', hwui_prepare_tree.prepare_tree_avg,

	'gpu_completion_count', hwui_gpu_completion.gpu_completion_count,
	'gpu_completion_max', hwui_gpu_completion.gpu_completion_max,
	'gpu_completion_min', hwui_gpu_completion.gpu_completion_min,
	'gpu_completion_avg', hwui_gpu_completion.gpu_completion_avg,

	'ui_record_count', hwui_ui_record.ui_record_count,
	'ui_record_max', hwui_ui_record.ui_record_max,
	'ui_record_min', hwui_ui_record.ui_record_min,
	'ui_record_avg', hwui_ui_record.ui_record_avg,

	'shader_compile_count', hwui_shader_compile.shader_compile_count,
	'shader_compile_time', hwui_shader_compile.shader_compile_time,
	'shader_compile_avg', hwui_shader_compile.shader_compile_avg,

	'cache_hit_count', hwui_cache_hit.cache_hit_count,
	'cache_hit_time', hwui_cache_hit.cache_hit_time,
	'cache_hit_avg', hwui_cache_hit.cache_hit_avg,

	'cache_miss_count', hwui_cache_miss.cache_miss_count,
	'cache_miss_time', hwui_cache_miss.cache_miss_time,
	'cache_miss_avg', hwui_cache_miss.cache_miss_avg,

	'graphics_cpu_mem_max', CAST(hwui_graphics_cpu_mem.graphics_cpu_mem_max AS INT64),
	'graphics_cpu_mem_min', CAST(hwui_graphics_cpu_mem.graphics_cpu_mem_min AS INT64),
	'graphics_cpu_mem_avg', hwui_graphics_cpu_mem.graphics_cpu_mem_avg,

	'graphics_gpu_mem_max', CAST(hwui_graphics_gpu_mem.graphics_gpu_mem_max AS INT64),
	'graphics_gpu_mem_min', CAST(hwui_graphics_gpu_mem.graphics_gpu_mem_min AS INT64),
	'graphics_gpu_mem_avg', hwui_graphics_gpu_mem.graphics_gpu_mem_avg,

	'texture_mem_max', CAST(hwui_texture_mem.texture_mem_max AS INT64),
	'texture_mem_min', CAST(hwui_texture_mem.texture_mem_min AS INT64),
	'texture_mem_avg', hwui_texture_mem.texture_mem_avg,

	'all_mem_max', CAST(hwui_all_mem.all_mem_max AS INT64),
	'all_mem_min', CAST(hwui_all_mem.all_mem_min AS INT64),
	'all_mem_avg', hwui_all_mem.all_mem_avg
	)
	)
	FROM hwui_processes
	LEFT JOIN hwui_draw_frame ON (hwui_draw_frame.render_thread_id = hwui_processes.render_thread_id)
	LEFT JOIN hwui_flush_commands ON (hwui_flush_commands.render_thread_id = hwui_processes.render_thread_id)
	LEFT JOIN hwui_prepare_tree ON (hwui_prepare_tree.render_thread_id = hwui_processes.render_thread_id)
	LEFT JOIN hwui_gpu_completion ON (hwui_gpu_completion.process_upid = hwui_processes.process_upid)
	LEFT JOIN hwui_ui_record ON (hwui_ui_record.process_upid = hwui_processes.process_upid)
	LEFT JOIN hwui_shader_compile ON (hwui_shader_compile.render_thread_id = hwui_processes.render_thread_id)
	LEFT JOIN hwui_cache_hit ON (hwui_cache_hit.render_thread_id = hwui_processes.render_thread_id)
	LEFT JOIN hwui_cache_miss ON (hwui_cache_miss.render_thread_id = hwui_processes.render_thread_id)
	LEFT JOIN hwui_graphics_cpu_mem ON (hwui_graphics_cpu_mem.process_upid = hwui_processes.process_upid)
	LEFT JOIN hwui_graphics_gpu_mem ON (hwui_graphics_gpu_mem.process_upid = hwui_processes.process_upid)
	LEFT JOIN hwui_texture_mem ON (hwui_texture_mem.process_upid = hwui_processes.process_upid)
	LEFT JOIN hwui_all_mem ON (hwui_all_mem.process_upid = hwui_processes.process_upid)
	)
	);