Detect Repeating AI Agent Tool Loops

SELECT
  run_id,
  agent_name,
  COUNT(*) AS tool_calls,
  COUNT(DISTINCT tool_name) AS distinct_tools,
  SUM(CASE WHEN status = 'failed' THEN 1 ELSE 0 END) AS failed_calls,
  SUM(estimated_cost_usd) AS tool_loop_cost_usd,
  MIN(timestamp_utc) AS first_call_at,
  MAX(timestamp_utc) AS last_call_at
FROM agent_tool_calls
WHERE timestamp_utc >= now() - INTERVAL '24 hours'
GROUP BY run_id, agent_name
HAVING COUNT(*) >= 8
  AND COUNT(DISTINCT tool_name) <= 2
ORDER BY tool_calls DESC, tool_loop_cost_usd DESC
LIMIT 100;