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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
--
-- Copyright 2020 The Android Open Source Project
--
-- Licensed under the Apache License, Version 2.0 (the "License");
-- you may not use this file except in compliance with the License.
-- You may obtain a copy of the License at
--
-- https://www.apache.org/licenses/LICENSE-2.0
--
-- Unless required by applicable law or agreed to in writing, software
-- distributed under the License is distributed on an "AS IS" BASIS,
-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
-- See the License for the specific language governing permissions and
-- limitations under the License.
--
-- Table to map any of the various chrome process names to a type (e.g. Browser,
-- Renderer, GPU Process, etc).
DROP TABLE IF EXISTS chrome_process_name_type_mapping;
CREATE TABLE chrome_process_name_type_mapping (
original_name_pattern TEXT UNIQUE,
type TEXT
);
WITH prefix (value) AS (
SELECT *
FROM (
VALUES ("org.chromium.chrome"),
("com.google.android.apps.chrome"),
("com.android.chrome"),
("com.chrome.beta"),
("com.chrome.canary"),
("com.chrome.dev")
)
),
suffix (value, TYPE) AS (
SELECT *
FROM (
VALUES ("", "Browser"),
(
":sandboxed_process*:org.chromium.content.app.SandboxedProcessService*",
"Sandboxed"
),
(":privileged_process*", "Privileged"),
("_zygote", "Zygote")
)
)
-- Insert the Chrome process names for a normal chrome trace
INSERT INTO chrome_process_name_type_mapping
VALUES ('Browser', 'Browser'),
('Renderer', 'Renderer'),
('GPU Process', 'Gpu'),
('Gpu', 'Gpu'),
('Zygote', 'Zygote'),
('Utility', 'Utility'),
('SandboxHelper', 'SandboxHelper'),
('PpapiPlugin', 'PpapiPlugin'),
('PpapiBroker', 'PpapiBroker')
UNION ALL
-- Construct all the possible Chrome process names for an Android system chrome
-- trace.
SELECT prefix.value || suffix.value AS name,
suffix.type AS type
FROM prefix,
suffix;
-- Use GLOB here instead of LIKE as it's case-sensitive which means we don't
-- match the Android system zygote.
DROP VIEW IF EXISTS all_chrome_processes;
CREATE VIEW all_chrome_processes AS
SELECT upid, m.type AS process_type
FROM process JOIN chrome_process_name_type_mapping m
ON name GLOB original_name_pattern;
-- A view of all Chrome threads.
DROP VIEW IF EXISTS all_chrome_threads;
CREATE VIEW all_chrome_threads AS
SELECT utid, thread.upid, thread.name
FROM thread, all_chrome_processes
WHERE thread.upid = all_chrome_processes.upid;
-- For sandboxed and privileged processes (found in Android system traces), use
-- the main thread name to type of process.
DROP VIEW IF EXISTS chrome_subprocess_types;
CREATE VIEW chrome_subprocess_types AS
-- Sometimes you can get multiple threads in a trace marked main_thread, but
-- they appear to have the same name so just use one of them.
SELECT DISTINCT p.upid,
SUBSTR(t.name, 3, LENGTH(t.name) - 6) AS sandbox_type
FROM all_chrome_processes p
JOIN all_chrome_threads t ON p.upid = t.upid
WHERE process_type IN ("Sandboxed", "Privileged")
AND t.name GLOB "Cr*Main";
-- Contains all the chrome processes from process with an extra column,
-- process_type.
DROP VIEW IF EXISTS chrome_process;
CREATE VIEW chrome_process AS
SELECT PROCESS.*,
IIF(sandbox_type IS NULL, process_type, sandbox_type) AS process_type
FROM PROCESS
JOIN (
SELECT a.upid,
sandbox_type,
process_type
FROM all_chrome_processes a
LEFT JOIN chrome_subprocess_types s ON a.upid = s.upid
) c ON PROCESS.upid = c.upid;
-- Contains all the chrome threads from thread with an extra column,
-- canonical_name, that should contain a thread that's the same in both chrome
-- and system traces.
DROP VIEW IF EXISTS chrome_thread;
CREATE VIEW chrome_thread AS
SELECT thread.*,
CASE
WHEN thread.name GLOB "Cr*Main" THEN "CrProcessMain"
WHEN thread.name IS NULL THEN "Unknown"
ELSE thread.name
END AS canonical_name
FROM (
SELECT t.utid,
p.*
FROM all_chrome_threads t
JOIN chrome_process p ON t.upid = p.upid
) c
JOIN thread ON thread.utid = c.utid;
|
