Jobs waiting for an agent now, per pool

Custom SQL query (hide)

SELECT queue, os, arch, count(*) AS waiting,
  round(max(julianday('now') - julianday(runnable_at)) * 24, 1) AS longest_wait_h
FROM pool_jobs WHERE state = 'scheduled' AND started_at IS NULL
GROUP BY queue, os, arch ORDER BY waiting DESC

Edit SQL