| commit | 9c3174900907e9b046755076056b240d740e0d10 | [log] [tgz] |
|---|---|---|
| author | Lalit Maganti <lalitm@google.com> | Tue Sep 13 20:01:55 2022 +0100 |
| committer | Lalit Maganti <lalitm@google.com> | Wed Sep 14 13:28:01 2022 +0000 |
| tree | 9c546b73980dc05c3a3457128054f94da78c57ae | |
| parent | 41b70f41fa0200e2d13e30d873fa645e1268eba6 [diff] |
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
Perfetto is a production-grade open-source stack for performance instrumentation and trace analysis. It offers services and libraries and for recording system-level and app-level traces, native + java heap profiling, a library for analyzing traces using SQL and a web-based UI to visualize and explore multi-GB traces.
See https://perfetto.dev/docs or the /docs/ directory for documentation.