Queue wait per julia-ci build over the last :days days

Custom SQL query (hide)

SELECT b.number, b.commit_prefix, count(*) AS jobs,
  round(avg((julianday(j.started_at) - julianday(j.runnable_at)) * 86400)) AS mean_wait_s,
  round(max((julianday(j.started_at) - julianday(j.runnable_at)) * 86400)) AS max_wait_s
FROM jobs j JOIN builds b ON b.id = j.build_id
WHERE b.pipeline = 'julia-ci' AND j.runnable_at IS NOT NULL AND b.created_at >= date('now', '-' || :days || ' days')
GROUP BY b.id ORDER BY b.number DESC

Query parameters

days

Edit SQL