One job's duration by week

Weekly mean and count of passing runs of a job on julia-ci over the last :days days; job is its exact name, e.g. :linux: test x86_64-linux-gnu

Custom SQL query (hide) 

SELECT strftime('%Y-%W', b.created_at) AS week, count(*) AS runs, round(avg(j.duration_s) / 60, 1) AS mean_minutes
FROM jobs j JOIN builds b ON b.id = j.build_id
WHERE j.name = :job AND b.pipeline = 'julia-ci' AND j.state = 'passed' AND b.created_at >= date('now', '-' || :days || ' days')
GROUP BY week ORDER BY week

Query parameters

Edit SQL

0 results