Skip to content

Instantly share code, notes, and snippets.

@sbrissenden

sbrissenden/firebase_performance_slow_screens.sql

Last active August 26, 2024 14:49
Show Gist options
  • Save sbrissenden/f211273cc941628a5a1dfb0252137f4d to your computer and use it in GitHub Desktop.
Save sbrissenden/f211273cc941628a5a1dfb0252137f4d to your computer and use it in GitHub Desktop.
Download ZIP
[BigQuery + Firebase Performance Monitoring] Find app screens with frozen frames impacting French users
Raw
firebase_performance_slow_screens.sql
SELECT
AVG(trace_info.duration_us / 1000000) AS seconds_on_screen,
AVG(trace_info.screen_info.slow_frame_ratio) AS slow_frame_ratio,
AVG(trace_info.screen_info.frozen_frame_ratio) AS frozen_frame_ratio,
event_name as screen,
country
FROM `friendly--pix.projectId.firebase_performance.YOUR_PACKAGE_NAME_ANDROID`
WHERE _PARTITIONTIME > TIMESTAMP("2019-05-09")
AND event_type = "SCREEN_TRACE"
AND country = "FR"
GROUP BY event_name, country
ORDER BY frozen_frame_ratio desc;
@RyuichiA
Copy link

what is kind of index could be measuring app perfromance except slow screens?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment