Android Perfetto 系列 12：Trace 数据流与丢失排查

1
2

trace_quality_status,affected_sources,affected_metrics,usable_metrics,unusable_metrics,evidence_grade,fallback_used,recapture_required,recapture_reason,next_trace_config_change
partial,ftrace;sched,Runnable;wakeup,FrameTimeline;AppTrackEvent,RunnableNegativeConclusion,weak,false,true,ftrace_cpu_has_data_loss,reduce_ftrace_events+increase_ftrace_buffer

1
2
3
4
5
6
7
8
9
10
11

SELECT name, idx, severity, source, value
FROM stats
WHERE value != 0
  AND (
    severity IN ('error', 'data_loss')
    OR name IN (
      'traced_buf_chunks_overwritten',
      'traced_buf_chunks_discarded'
    )
  )
ORDER BY name, idx;

1
2
3
4
5

SELECT 'actual' AS table_name, COUNT(*) AS row_count
FROM actual_frame_timeline_slice
UNION ALL
SELECT 'expected' AS table_name, COUNT(*) AS row_count
FROM expected_frame_timeline_slice;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

INCLUDE PERFETTO MODULE time.conversion;

WITH target_window(start_ts, end_ts) AS (
  VALUES (123000000000, 123500000000)
)
SELECT
  'actual' AS table_name,
  COUNT(*) AS row_count,
  time_to_ms(MIN(a.ts)) AS min_ts_ms,
  time_to_ms(MAX(a.ts + a.dur)) AS max_end_ms
FROM actual_frame_timeline_slice a
JOIN target_window w
WHERE a.ts < w.end_ts
  AND a.ts + a.dur > w.start_ts
UNION ALL
SELECT
  'expected' AS table_name,
  COUNT(*) AS row_count,
  time_to_ms(MIN(e.ts)) AS min_ts_ms,
  time_to_ms(MAX(e.ts + e.dur)) AS max_end_ms
FROM expected_frame_timeline_slice e
JOIN target_window w
WHERE e.ts < w.end_ts
  AND e.ts + e.dur > w.start_ts;

1
2
3
4
5
6
7
8
9

SELECT name, idx, severity, source, value
FROM stats
WHERE value != 0
ORDER BY CASE severity
  WHEN 'data_loss' THEN 0
  WHEN 'error' THEN 1
  WHEN 'notice' THEN 2
  ELSE 3
END, name, idx;