perfetto-sql

To query Android Perfetto trace files, execute SQL queries against local trace files using trace_processor to extract slice, thread, or memory performance data. You can calculate specific durations by filtering slice names with GLOB patterns.

Yes, you can use SQL to extract thread and memory information from Perfetto traces. The Skill translates data intents into syntactically valid Perfetto SQL queries, executing them locally to retrieve specific performance metrics.

Analyzing Android performance traces is done by translating natural language intents into syntactically valid Perfetto SQL queries. However, this process requires trace_processor and existing Perfetto SQL syntax knowledge to execute queries correctly.

Perfetto SQL execution requires the trace_processor dependency and local trace files. You need Perfetto SQL syntax knowledge to execute queries and successfully extract performance data from your Android trace files.

To calculate the total duration of specific slices in a Perfetto trace, execute a SQL query summing slice durations while filtering by name. Use trace_end() to handle slices with a duration of -1 for accurate total time calculation.

You need Perfetto SQL syntax knowledge because the Skill translates natural language intents into syntactically valid Perfetto SQL queries. This ensures accurate execution against local trace files to extract the required slice, thread, or memory data.