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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
|
--
-- Copyright 2019 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.
--
SELECT IMPORT('android.battery');
DROP VIEW IF EXISTS battery_view;
CREATE VIEW battery_view AS
SELECT * FROM android_battery_charge;
DROP TABLE IF EXISTS android_batt_wakelocks_merged;
CREATE TABLE android_batt_wakelocks_merged AS
SELECT
MIN(ts) AS ts,
MAX(ts_end) AS ts_end
FROM (
SELECT
*,
SUM(new_group) OVER (ORDER BY ts) AS group_id
FROM (
SELECT
ts,
ts + dur AS ts_end,
-- There is a new group if there was a gap before this wakelock.
-- i.e. the max end timestamp of all preceding wakelocks is before
-- the start timestamp of this one.
-- The null check is for the first row which is always a new group.
IFNULL(
MAX(ts + dur) OVER (
ORDER BY ts
ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING
) < ts,
TRUE
) AS new_group
FROM slice
WHERE slice.name GLOB 'WakeLock *' AND dur != -1
)
)
GROUP BY group_id;
DROP TABLE IF EXISTS suspend_slice_;
CREATE TABLE suspend_slice_ AS
SELECT
ts,
dur
FROM
slice
JOIN
track
ON slice.track_id = track.id
WHERE
track.name = 'Suspend/Resume Latency'
AND (slice.name = 'syscore_resume(0)' OR slice.name = 'timekeeping_freeze(0)')
AND dur != -1;
SELECT RUN_METRIC('android/counter_span_view_merged.sql',
'table_name', 'screen_state',
'counter_name', 'ScreenState');
SELECT RUN_METRIC('android/counter_span_view_merged.sql',
'table_name', 'doze_light_state',
'counter_name', 'DozeLightState');
SELECT RUN_METRIC('android/counter_span_view_merged.sql',
'table_name', 'doze_deep_state',
'counter_name', 'DozeDeepState');
SELECT RUN_METRIC('android/counter_span_view_merged.sql',
'table_name', 'battery_status',
'counter_name', 'BatteryStatus');
SELECT RUN_METRIC('android/counter_span_view_merged.sql',
'table_name', 'plug_type',
'counter_name', 'PlugType');
DROP TABLE IF EXISTS screen_state_span_with_suspend;
CREATE VIRTUAL TABLE screen_state_span_with_suspend
USING span_join(screen_state_span, suspend_slice_);
DROP VIEW IF EXISTS android_batt_event;
CREATE VIEW android_batt_event AS
SELECT
ts,
dur,
'Suspended' AS slice_name,
'Suspend / resume' AS track_name,
'slice' AS track_type
FROM suspend_slice_
UNION ALL
SELECT ts,
dur,
CASE screen_state_val
WHEN 1 THEN 'Screen off'
WHEN 2 THEN 'Screen on'
WHEN 3 THEN 'Always-on display (doze)'
ELSE 'unknown'
END AS slice_name,
'Screen state' AS track_name,
'slice' AS track_type
FROM screen_state_span
UNION ALL
-- See DeviceIdleController.java for where these states come from and how
-- they transition.
SELECT ts,
dur,
CASE doze_light_state_val
WHEN 0 THEN 'active'
WHEN 1 THEN 'inactive'
WHEN 4 THEN 'idle'
WHEN 5 THEN 'waiting_for_network'
WHEN 6 THEN 'idle_maintenance'
WHEN 7 THEN 'override'
ELSE 'unknown'
END AS slice_name,
'Doze light state' AS track_name,
'slice' AS track_type
FROM doze_light_state_span
UNION ALL
SELECT ts,
dur,
CASE doze_deep_state_val
WHEN 0 THEN 'active'
WHEN 1 THEN 'inactive'
WHEN 2 THEN 'idle_pending'
WHEN 3 THEN 'sensing'
WHEN 4 THEN 'locating'
WHEN 5 THEN 'idle'
WHEN 6 THEN 'idle_maintenance'
WHEN 7 THEN 'quick_doze_delay'
ELSE 'unknown'
END AS slice_name,
'Doze deep state' AS track_name,
'slice' AS track_type
FROM doze_deep_state_span
UNION ALL
SELECT ts,
dur,
CASE battery_status_val
-- 0 and 1 are both unknown
WHEN 2 THEN 'Charging'
WHEN 3 THEN 'Discharging'
-- special case when charger is present but battery isn't charging
WHEN 4 THEN 'Not charging'
WHEN 5 THEN 'Full'
ELSE 'unknown'
END AS slice_name,
'Charging state' AS track_name,
'slice' AS track_type
FROM battery_status_span
UNION ALL
SELECT ts,
dur,
CASE plug_type_val
WHEN 0 THEN 'None'
WHEN 1 THEN 'AC'
WHEN 2 THEN 'USB'
WHEN 4 THEN 'Wireless'
WHEN 8 THEN 'Dock'
ELSE 'unknown'
END AS slice_name,
'Plug type' AS track_name,
'slice' AS track_type
FROM plug_type_span;
DROP VIEW IF EXISTS android_batt_output;
CREATE VIEW android_batt_output AS
SELECT AndroidBatteryMetric(
'battery_counters', (
SELECT RepeatedField(
AndroidBatteryMetric_BatteryCounters(
'timestamp_ns', ts,
'charge_counter_uah', charge_uah,
'capacity_percent', capacity_percent,
'current_ua', current_ua,
'current_avg_ua', current_avg_ua
)
)
FROM android_battery_charge
),
'battery_aggregates', (
SELECT NULL_IF_EMPTY(AndroidBatteryMetric_BatteryAggregates(
'total_screen_off_ns',
SUM(CASE WHEN state = 1.0 AND tbl = 'total' THEN dur ELSE 0 END),
'total_screen_on_ns',
SUM(CASE WHEN state = 2.0 AND tbl = 'total' THEN dur ELSE 0 END),
'total_screen_doze_ns',
SUM(CASE WHEN state = 3.0 AND tbl = 'total' THEN dur ELSE 0 END),
'sleep_ns',
(SELECT SUM(dur) FROM suspend_slice_),
'sleep_screen_off_ns',
SUM(CASE WHEN state = 1.0 AND tbl = 'sleep' THEN dur ELSE 0 END),
'sleep_screen_on_ns',
SUM(CASE WHEN state = 2.0 AND tbl = 'sleep' THEN dur ELSE 0 END),
'sleep_screen_doze_ns',
SUM(CASE WHEN state = 3.0 AND tbl = 'sleep' THEN dur ELSE 0 END),
'total_wakelock_ns',
(SELECT SUM(ts_end - ts) FROM android_batt_wakelocks_merged)
))
FROM (
SELECT dur, screen_state_val AS state, 'total' AS tbl
FROM screen_state_span
UNION ALL
SELECT dur, screen_state_val AS state, 'sleep' AS tbl
FROM screen_state_span_with_suspend
)
),
'suspend_period', (
SELECT RepeatedField(
AndroidBatteryMetric_SuspendPeriod(
'timestamp_ns', ts,
'duration_ns', dur
)
)
FROM suspend_slice_
)
);
|
