Lines Matching +full:device +full:- +full:select
7 // http://www.apache.org/licenses/LICENSE-2.0
38 select
45 select
51 select
53 ifnull(lead(ts) over (order by ts), (select end_ts from trace_bounds)) - ts as dur,
55 when conn like '-1:%' then 'Disconnected'
65 select ts, safe_dur AS dur, value_name as data_conn, value AS data_conn_val
70 select ts, safe_dur AS dur, value AS nr_state_val
79 select
82 -- On LTE with NR connected is 5G NSA.
84 -- On NR with NR state present, is 5G SA.
92 select
99 select ts_end - dur as ts, dur, 'Tethering' as name from base`;
104 select
118 select
125 select
133 select
141 select * from final where ts is not null`;
147 select
163 select
165 lead(timestamp_millis) over (order by ts) - timestamp_millis as dur_millis,
166 lead(sleep_time_millis) over (order by ts) - sleep_time_millis as sleep_time_millis,
167 …lead(controller_idle_time_millis) over (order by ts) - controller_idle_time_millis as controller_i…
168 …lead(controller_tx_time_pl0_millis) over (order by ts) - controller_tx_time_pl0_millis as controll…
169 …lead(controller_tx_time_pl1_millis) over (order by ts) - controller_tx_time_pl1_millis as controll…
170 …lead(controller_tx_time_pl2_millis) over (order by ts) - controller_tx_time_pl2_millis as controll…
171 …lead(controller_tx_time_pl3_millis) over (order by ts) - controller_tx_time_pl3_millis as controll…
172 …lead(controller_tx_time_pl4_millis) over (order by ts) - controller_tx_time_pl4_millis as controll…
173 …lead(controller_rx_time_millis) over (order by ts) - controller_rx_time_millis as controller_rx_ti…
177 select
189 select * from ratios where sleep_time_ratio is not null and sleep_time_ratio >= 0`;
194 SELECT ts, dur FROM (
195 SELECT
197 LEAD(ts, 1, TRACE_END()) OVER (ORDER BY ts)-ts AS dur
205 SELECT
207 LEAD(ts, 1, TRACE_END()) OVER (ORDER BY ts)-ts AS dur
222 SELECT ts, dur, band_name, value_name, (
223 SELECT CAST(SUBSTR(key_str, start_idx+1, end_idx-start_idx-1) AS INT64) AS value
225 SELECT key_str, INSTR(key_str, "=") AS start_idx, INSTR(key_str, " ") AS end_idx
227 SELECT SUBSTR(band_str, INSTR(band_str, value_ril)) AS key_str
228 FROM (SELECT SUBSTR(name, INSTR(name, band_ril)) AS band_str)
236 SELECT
249 SELECT SUBSTR(trimmed, INSTR(trimmed, "=")+1, INSTR(trimmed, ",") - INSTR(trimmed, "=") - 1)
250 FROM (SELECT SUBSTR($source, INSTR($source, $key_name)) AS trimmed);`;
254 SELECT ts, slice.name AS raw_config
272 SELECT *, IFNULL(EXTRACT_KEY_VALUE(STR_SPLIT(raw_config, "}, {", idx), attribute), "") AS name
278 SELECT *, LAG(name) OVER (PARTITION BY idx, attribute ORDER BY ts) AS last_name
282 SELECT *, LEAD(ts, 1, TRACE_END()) OVER (PARTITION BY idx, attribute ORDER BY ts) - ts AS dur
285 SELECT ts, dur, slot_name || "-" || attrib_name || "=" || name AS name
290 select
299 select
311 select ts, cell_id , lag(cell_id) over (order by ts) as lag_cell_id, raw_ril
314 select ts, 0 as dur, cell_id as name, raw_ril
320 SELECT
329 SELECT counter.id, ts, 0 AS track_id, value
334 SELECT
340 WHEN 3 THEN 'Always-on display (doze)'
349 SELECT counter.id, ts, 0 AS track_id, value
354 SELECT
370 SELECT counter.id, ts, 0 AS track_id, value
375 SELECT
393 SELECT counter.id, ts, 0 AS track_id, value
398 SELECT
402 -- 0 and 1 are both unknown
405 -- special case when charger is present but battery isn't charging
414 select
425 select
427 lead(ts) over (partition by sensor_type, sensor_name order by ts) - ts as dur,
435 select
439 when 'VIRTUAL-SKIN' then ''
448 select
462 select wakelock_name
464 select wakelock_name, max(time_micros)-min(time_micros) as delta_us
468 -- Only consider wakelocks with over 1 second of time during the whole trace
472 select ts, wakelock_name, count, time_micros
478 select
482 lead(count) over (partition by wakelock_name order by ts) - count as count,
483 …(lead(time_micros) over (partition by wakelock_name order by ts) - time_micros) * 1000 as wakelock…
487 select
490 ifnull((select sum(dur) from android_suspend_state s
501 select
503 ts_end - ts as dur,
505 min(100.0 * wakelock_dur / (ts_end - ts - suspended_dur), 100) as value
509 select wakelock_name, max(value) as max_value
519 select
533 select uid, cluster
535 select uid, cluster, max(time_millis)-min(time_millis) as delta_ms
539 -- Only consider tracks with over 1 second of cpu during the whole trace
543 select ts, uid, cluster, sum(time_millis) as time_millis
550 select
554 lead(ts) over (partition by uid, cluster order by ts) - ts as dur,
555 …(lead(time_millis) over (partition by uid, cluster order by ts) - time_millis) * 1000000.0 as cpu_…
559 select
567 select
570 …case cluster when 0 then 'little' when 1 then 'mid' when 2 then 'big' else 'cl-' || cluster end as…
581 select ts, sum(value) as value, cluster, pkg
589 select
597 select
604 select
612 select
621 select
629 select
642 select
656 select
661 lead(ts, 1, ts + 5e9) over (order by ts) - ts,
678 select
692 select
722 select
740 …select ts, dur, raw_wakeup, attribution, suspend_quality, backoff_state, backoff_reason, backoff_c…
742 …select ts, dur, raw_wakeup, attribution, suspend_quality, backoff_state, backoff_reason, backoff_c…
744 …select ts, dur, raw_wakeup, attribution, suspend_quality, backoff_state, backoff_reason, backoff_c…
746 …select ts, dur, raw_wakeup, attribution, suspend_quality, backoff_state, backoff_reason, backoff_c…
748 select
778 select
789 select
795 lead(ts) over (partition by name order by ts) - ts as dur
798 select ts, dur, name from step2 where state = 'ON' and ${condition} and dur is not null`;
803 select
811 select
819 select
829 select
831 lead(ts) over (partition by metric_id order by ts) - ts as dur,
837 select
846 select
856 select
858 lead(ts) over (partition by metric_id, transport order by ts) - ts as dur,
864 select
867 'Device ' || metric_id ||
874 select
884 select
886 lead(ts) over (partition by metric_id, codec order by ts) - ts as dur,
892 select
896 'Device ' || metric_id || ' (' ||
903 select
917 select
920 'Device '|| metric_id as name
936 select
959 select
987 select
997 select
1012 select
1020 select
1030 select
1039 select
1042 'Device ' || metric_id as name
1049 select
1059 select
1061 lead(ts) over (partition by uid order by ts) - ts as dur,
1063 lead(tx_bytes) over (partition by uid order by ts) - tx_bytes as tx_bytes,
1064 lead(rx_bytes) over (partition by uid order by ts) - rx_bytes as rx_bytes
1068 select
1080 select
1087 select
1097 // See go/bt_system_context_report for reference on the bit-twiddling.
1101 select
1112 select
1114 lead(ts) over (order by ts) - ts as dur,
1116 lead(controller_idle_dur) over (order by ts) - controller_idle_dur as controller_idle_dur,
1117 lead(controller_tx_dur) over (order by ts) - controller_tx_dur as controller_tx_dur,
1118 lead(controller_rx_dur) over (order by ts) - controller_rx_dur as controller_rx_dur
1121 select
1134 else -1
1210 `SELECT ts, safe_dur AS dur, value_name AS name
1231 `SELECT ts, safe_dur AS dur, str_value AS name
1254 this.addSliceTrack(ctx, 'Device State: Screen state', SCREEN_STATE);
1255 this.addSliceTrack(ctx, 'Device State: Charging', CHARGING);
1256 this.addSliceTrack(ctx, 'Device State: Suspend / resume', SUSPEND_RESUME);
1257 this.addSliceTrack(ctx, 'Device State: Doze light state', DOZE_LIGHT);
1258 this.addSliceTrack(ctx, 'Device State: Doze deep state', DOZE_DEEP);
1260 query('Device State: Top app', 'battery_stats.top');
1264 'Device State: Long wakelocks',
1265 `SELECT
1266 ts - 60000000000 as ts,
1270 (select package_name from package_list where uid = int_value % 100000),
1278 query('Device State: Foreground apps', 'battery_stats.fg');
1279 query('Device State: Jobs', 'battery_stats.job');
1284 'Device State: Thermal throttling',
1315 `select ts, sum(value) as value from network_summary where dev_type = 'wifi' group by 1`,
1320 …`select pkg, sum(value) from network_summary where dev_type='wifi' group by 1 order by 2 desc limi…
1327 `select ts, value from network_summary where dev_type = 'wifi' and pkg = '${it.pkg}'`,
1358 `select ts, sum(value) as value from network_summary where dev_type = 'modem' group by 1`,
1363 …`select pkg, sum(value) from network_summary where dev_type='modem' group by 1 order by 2 desc lim…
1370 `select ts, value from network_summary where dev_type = 'modem' and pkg = '${it.pkg}'`,
1386 `select ts, dur, name from radio_transport`,
1420 `select ts, ${col}_ratio as value from modem_activity_info`,
1441 … `SELECT ts, dur, name FROM RilScreenOn WHERE band_name = '${band}' AND value_name = '${value}'`,
1488 `select ts, dur, value from kernel_wakelocks where wakelock_name = "${it.wakelock_name}"`,
1507 const result = await e.query(`select
1514 const sqlPrefix = `select
1567 `select distinct pkg, cluster from high_cpu where value > 10 order by 1, 2`,
1574 `select ts, value from high_cpu where pkg = "${it.pkg}" and cluster="${it.cluster}"`,
1616 'Link-level Events',
1632 'select ts, dur, acl_active_count as value from bt_activity',
1638 'select ts, dur, acl_sniff_count as value from bt_activity',
1644 'select ts, dur, acl_ble_count as value from bt_activity',
1650 'select ts, dur, advertising_count as value from bt_activity',
1656 'select ts, dur, le_scan_duty_cycle as value from bt_activity',
1663 "select ts, dur, 'Active' as name from bt_activity where inquiry_active",
1669 "select ts, dur, 'Active' as name from bt_activity where sco_active",
1675 "select ts, dur, 'Active' as name from bt_activity where a2dp_active",
1681 "select ts, dur, 'Active' as name from bt_activity where le_audio_active",
1687 'select ts, dur, controller_idle_pct as value from bt_activity',
1694 'select ts, dur, controller_tx_pct as value from bt_activity',
1701 'select ts, dur, controller_rx_pct as value from bt_activity',
1753 (t) => `SELECT
1757 'http://go/trace-uuid/${t.uuid}' AS link
1779 select distinct 'atom.' || s.name as feature
1784 select distinct
1793 select distinct 'track.' || lower(name) as feature
1797 select distinct 'track.battery_stats.*' as feature