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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
|
-- 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.
INCLUDE PERFETTO MODULE slices.with_context;
-- Access all startups, including those that don't lead to any visible content.
-- If TimeToFirstVisibleContent is available, then this event will be the
-- main event of the startup. Otherwise, the event for the start timestamp will
-- be used.
CREATE PERFETTO VIEW _startup_start_events AS
WITH
starts AS (
SELECT
name,
extract_arg(arg_set_id, 'startup.activity_id') AS activity_id,
ts,
dur,
upid AS browser_upid
FROM thread_slice
WHERE
name = 'Startup.ActivityStart'
),
times_to_first_visible_content AS (
SELECT
name,
extract_arg(arg_set_id, 'startup.activity_id') AS activity_id,
ts,
dur,
upid AS browser_upid
FROM process_slice
WHERE
name = 'Startup.TimeToFirstVisibleContent2'
),
all_activity_ids AS (
SELECT DISTINCT
activity_id,
browser_upid
FROM starts
UNION ALL
SELECT DISTINCT
activity_id,
browser_upid
FROM times_to_first_visible_content
),
activity_ids AS (
SELECT DISTINCT
activity_id,
browser_upid
FROM all_activity_ids
)
SELECT
activity_ids.activity_id,
'Startup' AS name,
coalesce(times_to_first_visible_content.ts, starts.ts) AS startup_begin_ts,
times_to_first_visible_content.ts + times_to_first_visible_content.dur AS first_visible_content_ts,
activity_ids.browser_upid
FROM activity_ids
LEFT JOIN times_to_first_visible_content
USING (activity_id, browser_upid)
LEFT JOIN starts
USING (activity_id, browser_upid);
-- Chrome launch causes, not recorded at start time; use the activity id to
-- join with the actual startup events.
CREATE PERFETTO VIEW _launch_causes AS
SELECT
extract_arg(arg_set_id, 'startup.activity_id') AS activity_id,
extract_arg(arg_set_id, 'startup.launch_cause') AS launch_cause,
upid AS browser_upid
FROM thread_slice
WHERE
name = 'Startup.LaunchCause';
-- Chrome startups, including launch cause.
CREATE PERFETTO TABLE chrome_startups (
-- Unique ID
id LONG,
-- Chrome Activity event id of the launch.
activity_id LONG,
-- Name of the launch start event.
name STRING,
-- Timestamp that the startup occurred.
startup_begin_ts TIMESTAMP,
-- Timestamp to the first visible content.
first_visible_content_ts TIMESTAMP,
-- Launch cause. See Startup.LaunchCauseType in chrome_track_event.proto.
launch_cause STRING,
-- Process ID of the Browser where the startup occurred.
browser_upid LONG
) AS
SELECT
row_number() OVER (ORDER BY start_events.startup_begin_ts) AS id,
start_events.activity_id,
start_events.name,
start_events.startup_begin_ts,
start_events.first_visible_content_ts,
launches.launch_cause,
start_events.browser_upid
FROM _startup_start_events AS start_events
LEFT JOIN _launch_causes AS launches
USING (activity_id, browser_upid);
|
