File: histograms.sql

package info (click to toggle)
chromium 139.0.7258.127-2
  • links: PTS, VCS
  • area: main
  • in suites: forky
  • size: 6,122,156 kB
  • sloc: cpp: 35,100,771; ansic: 7,163,530; javascript: 4,103,002; python: 1,436,920; asm: 946,517; xml: 746,709; pascal: 187,653; perl: 88,691; sh: 88,436; objc: 79,953; sql: 51,488; cs: 44,583; fortran: 24,137; makefile: 22,147; tcl: 15,277; php: 13,980; yacc: 8,984; ruby: 7,485; awk: 3,720; lisp: 3,096; lex: 1,327; ada: 727; jsp: 228; sed: 36
file content (78 lines) | stat: -rw-r--r-- 2,008 bytes parent folder | download | duplicates (10)
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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
-- Copyright 2023 The Chromium Authors
-- Use of this source code is governed by a BSD-style license that can be
-- found in the LICENSE file.

-- A helper view on top of the histogram events emitted by Chrome.
-- Requires "disabled-by-default-histogram_samples" Chrome category or the
-- "org.chromium.histogram_sample" data source.
CREATE PERFETTO TABLE chrome_histograms (
  -- The name of the histogram.
  name STRING,
  -- The value of the histogram sample.
  value LONG,
  -- Alias of |slice.ts|.
  ts TIMESTAMP,
  -- Thread name.
  thread_name STRING,
  -- Utid of the thread.
  utid LONG,
  -- Tid of the thread.
  tid LONG,
  -- Process name.
  process_name STRING,
  -- Upid of the process.
  upid LONG,
  -- Pid of the process.
  pid LONG
) AS
WITH
  -- Select raw histogram sample slices from the slice table.
  hist AS (
    SELECT
      extract_arg(slice.arg_set_id, 'chrome_histogram_sample.name') AS name,
      extract_arg(slice.arg_set_id, 'chrome_histogram_sample.sample') AS value,
      ts,
      track_id
    FROM slice
    WHERE
      slice.name = "HistogramSample"
      AND category = "disabled-by-default-histogram_samples"
  )
-- Part 1: join histogram samples emitted via the track event category.
-- These samples are associated with a specific thread track.
SELECT
  hist.name,
  hist.value,
  hist.ts,
  thread.name AS thread_name,
  thread.utid AS utid,
  thread.tid AS tid,
  process.name AS process_name,
  process.upid,
  process.pid
FROM hist
JOIN thread_track
  ON thread_track.id = hist.track_id
JOIN thread
  USING (utid)
JOIN process
  USING (upid)
UNION ALL
-- Part 2: Join histogram samples emitted via the
-- "org.chromium.histogram_sample" data source. These samples are associated
-- with a process track.
SELECT
  hist.name,
  hist.value,
  hist.ts,
  NULL AS thread_name,
  NULL AS utid,
  NULL AS tid,
  process.name AS process_name,
  process.upid,
  process.pid
FROM hist
JOIN process_track
  ON process_track.id = hist.track_id
JOIN process
  USING (upid);