tree 9c546b73980dc05c3a3457128054f94da78c57ae
parent 41b70f41fa0200e2d13e30d873fa645e1268eba6
author Lalit Maganti <lalitm@google.com> 1663095715 +0100
committer Lalit Maganti <lalitm@google.com> 1663162081 +0000

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