tp: speed up queries in chrome_tasks
This CL does the following:
* adds an index on chrome_mojo_slices_tbl which is necessary as we
often query this table by id.
* removes the temporary mitigation from aosp/2195476 for chrome_tasks
* adds some functions to make code easier to follow
* removes unnecessary ORDER BYs which slightly reduce performance
* fold some tables which do not need to be exposed at the top level into
WITH statements
* rename some tables for better clarity
On the chrome_page_load_all_categories_not_extended.pftrace.gz trace:
* Before SQLite bump: 990ms
* After SQLite bump (before mitigation): 1500ms
* After this CL: 890ms (10% improvement from before)
Change-Id: Ie9636b32bc0eba43755ffce6d23eb029d17ab1a4
Bug: 243897379
diff --git a/BUILD b/BUILD
index 1cf3b0c..067fadd 100644
--- a/BUILD
+++ b/BUILD
@@ -1352,6 +1352,7 @@
"src/trace_processor/metrics/sql/chrome/touch_flow_event.sql",
"src/trace_processor/metrics/sql/chrome/touch_flow_event_queuing_delay.sql",
"src/trace_processor/metrics/sql/chrome/touch_jank.sql",
+ "src/trace_processor/metrics/sql/common/parent_slice.sql",
"src/trace_processor/metrics/sql/experimental/blink_gc_metric.sql",
"src/trace_processor/metrics/sql/experimental/chrome_dropped_frames.sql",
"src/trace_processor/metrics/sql/experimental/chrome_long_latency.sql",
