Level 10 - MasterOptimization Questionsm4 platform performance capacity strategy
Optimization: Better Queue Backlog Query
Choose the better query for near-real-time backlog monitoring and provide final SQL. Query A: SELECT queue_name, COUNT(*) FROM job_queue WHERE status IN ('queued','running') GROUP BY queue_name; Query B: SELECT queue_name, COUNT(*) FROM job_queue WHERE status IN ('queued','running') AND enqueued_at >= CURRENT_TIMESTAMP - INTERVAL '2 hour' GROUP BY queue_name;
Schema Context
job_queue(job_id, queue_name, status, enqueued_at)