TTFX of one task per master build over the last :days days

task is Package/Snippet as in ttfx_results.task, e.g. BaseDirs/Project-Path

Custom SQL query (hide) 

SELECT j.build, substr(j.commit_sha, 1, 10) AS commit_sha, j.build_created_at, r.precompile, r.load, r.run, r.warm, r.load_gcoff, r.run_gcoff, r.warm_gcoff
FROM ttfx_results r JOIN ttfx_jobs j ON j.job_uuid = r.job_uuid
WHERE r.task = :task AND j.kind = 'master' AND j.build_created_at >= date('now', '-' || :days || ' days')
ORDER BY j.build_created_at

Query parameters

Edit SQL

0 results