-- name: PipelineMetrics :one SELECT count(*)::bigint AS depth, COALESCE(EXTRACT(EPOCH FROM clock_timestamp()-min(j.created_at)),0)::float8 AS oldest FROM attachments a JOIN attachment_jobs j ON j.attachment_id=a.id AND j.pipeline_version=a.pipeline_version WHERE a.status IN ('queued','processing') AND NOT j.completed;