good_job queries to make latency/runtime graphs

README.md

Queries to show GoodJob queue latency, runtime, and counts in Blazer

count.sql

SELECT date_trunc('hour', created_at), queue_name, count(*)
FROM "good_job_executions"
GROUP BY 1, 2
ORDER BY 1 DESC

excessive_latency.sql

WITH jobs AS (
  SELECT
    *,
    ROUND(EXTRACT(epoch FROM (created_at - scheduled_at)) * 1000)::integer AS latency
  FROM "good_job_executions"
)
SELECT
    date_trunc('minute', created_at) as minute,
    queue_name,
    count(*) as jobs
FROM jobs
WHERE latency > 1000
AND created_at >= NOW() - INTERVAL '30 minutes'
GROUP BY 1, 2
ORDER BY 1

latency.sql

WITH jobs AS (
  SELECT
    created_at,
    ROUND(EXTRACT(epoch FROM (created_at - scheduled_at)) * 1000)::integer AS latency
  FROM "good_job_executions"
)
SELECT
    date_trunc('hour', created_at),
    MAX(latency) as "max",
    percentile_disc(0.99) within group (order by latency) AS "99th",
    percentile_disc(0.95) within group (order by latency) AS "95th",
    percentile_disc(0.5) within group (order by latency) AS "50th"
FROM jobs
GROUP BY 1
ORDER BY 1 DESC

runtime.sql

WITH jobs AS (
  SELECT created_at,
    ROUND(EXTRACT(epoch FROM (finished_at - created_at)) * 1000)::integer AS runtime
  FROM "good_job_executions"
)
SELECT
    date_trunc('hour', created_at),
    MAX(runtime) as "max",
    percentile_disc(0.99) within group (order by runtime) AS "99th",
    percentile_disc(0.95) within group (order by runtime) AS "95th",
    percentile_disc(0.5) within group (order by runtime) AS "50th"
FROM jobs
GROUP BY 1
ORDER BY 1 DESC