File: scroll_interactions.sql

package info (click to toggle)
chromium 138.0.7204.183-1
  • links: PTS, VCS
  • area: main
  • in suites: trixie
  • size: 6,071,908 kB
  • sloc: cpp: 34,937,088; ansic: 7,176,967; javascript: 4,110,704; python: 1,419,953; asm: 946,768; xml: 739,971; pascal: 187,324; sh: 89,623; perl: 88,663; objc: 79,944; sql: 50,304; cs: 41,786; fortran: 24,137; makefile: 21,806; php: 13,980; tcl: 13,166; yacc: 8,925; ruby: 7,485; awk: 3,720; lisp: 3,096; lex: 1,327; ada: 727; jsp: 228; sed: 36
file content (62 lines) | stat: -rw-r--r-- 1,978 bytes parent folder | download | duplicates (9)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
-- Copyright 2024 The Chromium Authors
-- Use of this source code is governed by a BSD-style license that can be
-- found in the LICENSE file.

INCLUDE PERFETTO MODULE slices.with_context;

-- Top level scroll events, with metrics.
CREATE PERFETTO TABLE chrome_scroll_interactions (
  -- Unique id for an individual scroll.
  id LONG,
  -- Name of the scroll event.
  name STRING,
  -- Start timestamp of the scroll.
  ts TIMESTAMP,
  -- Duration of the scroll.
  dur DURATION,
  -- The total number of frames in the scroll.
  frame_count LONG,
  -- The total number of vsyncs in the scroll.
  vsync_count LONG,
  -- The maximum number of vsyncs missed during any and all janks.
  missed_vsync_max LONG,
  -- The total number of vsyncs missed during any and all janks.
  missed_vsync_sum LONG,
  -- The number of delayed frames.
  delayed_frame_count LONG,
  -- The number of frames that are deemed janky to the human eye after Chrome
  -- has applied its scroll prediction algorithm.
  predictor_janky_frame_count LONG,
  -- The process id this event occurred on.
  renderer_upid LONG
) AS
WITH
  scroll_metrics AS (
    SELECT
      id,
      ts,
      dur,
      extract_arg(arg_set_id, 'scroll_metrics.frame_count') AS frame_count,
      extract_arg(arg_set_id, 'scroll_metrics.vsync_count') AS vsync_count,
      extract_arg(arg_set_id, 'scroll_metrics.missed_vsync_max') AS missed_vsync_max,
      extract_arg(arg_set_id, 'scroll_metrics.missed_vsync_sum') AS missed_vsync_sum,
      extract_arg(arg_set_id, 'scroll_metrics.delayed_frame_count') AS delayed_frame_count,
      extract_arg(arg_set_id, 'scroll_metrics.predictor_janky_frame_count') AS predictor_janky_frame_count,
      upid AS renderer_upid
    FROM process_slice
    WHERE
      name = 'Scroll'
  )
SELECT
  id,
  'Scroll' AS name,
  ts,
  dur,
  frame_count,
  vsync_count,
  missed_vsync_max,
  missed_vsync_sum,
  delayed_frame_count,
  predictor_janky_frame_count,
  renderer_upid
FROM scroll_metrics;