blob: 7a91ed1e0843d3742ebb0af8331287a7e55b3f49 [file] [log] [blame]
--
-- 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.
--
-- Expose all clock snapshots as instant events.
DROP VIEW IF EXISTS trace_metadata_event;
CREATE VIEW trace_metadata_event AS
SELECT
'slice' as track_type,
'Clock Snapshots' as track_name,
ts,
0 as dur,
'Snapshot' as slice_name
FROM clock_snapshot
GROUP BY ts;
DROP VIEW IF EXISTS trace_metadata_output;
CREATE VIEW trace_metadata_output AS
SELECT TraceMetadata(
'trace_duration_ns', CAST((SELECT end_ts - start_ts FROM trace_bounds) AS INT),
'trace_uuid', (SELECT str_value FROM metadata WHERE name = 'trace_uuid'),
'android_build_fingerprint', (
SELECT str_value FROM metadata WHERE name = 'android_build_fingerprint'
),
'statsd_triggering_subscription_id', (
SELECT int_value FROM metadata
WHERE name = 'statsd_triggering_subscription_id'
),
'unique_session_name', (
SELECT str_value FROM metadata
WHERE name = 'unique_session_name'
),
'trace_size_bytes', (
SELECT int_value FROM metadata
WHERE name = 'trace_size_bytes'
),
'trace_trigger', (
SELECT RepeatedField(slice.name)
FROM track JOIN slice ON track.id = slice.track_id
WHERE track.name = 'Trace Triggers'
),
'trace_config_pbtxt', (
SELECT str_value FROM metadata
WHERE name = 'trace_config_pbtxt'
),
'sched_duration_ns', (
SELECT MAX(ts) - MIN(ts) from sched
)
);