Files/ComputerAssignments/CA2/code/pc/perfetto_queries.sql

-- Q1: Sensor read request to data obtainment
SELECT slice.name, slice.dur, slice.ts 
FROM slice 
WHERE slice.name LIKE '%sensor%' 
ORDER BY slice.dur DESC;

-- Q3: Actual sampling period vs configured period
SELECT 
    name,
    AVG(dur) as avg_duration,
    MIN(dur) as min_duration,
    MAX(dur) as max_duration
FROM slice 
WHERE name LIKE '%Sensor%' 
GROUP BY name;

-- Q4: Thread contention (waiting for rendering)
SELECT 
    name,
    SUM(dur) as total_time
FROM slice 
WHERE name LIKE '%render%' OR name LIKE '%surfaceflinger%'
GROUP BY name
ORDER BY total_time DESC;

-- Q6: Average CPU time in filter function
SELECT 
    name,
    AVG(dur) as avg_cpu_time,
    COUNT(*) as call_count
FROM slice 
WHERE name LIKE '%filter%' OR name LIKE '%Madgwick%'
GROUP BY name;

-- Q9: End-to-end latency (sensor ready → cursor movement)
SELECT 
    ts,
    dur,
    name
FROM slice 
WHERE name LIKE '%sensor%' OR name LIKE '%move%' OR name LIKE '%cursor%'
ORDER BY ts;