SELECT task_name, status, duration_ms FROM etl_runs WHERE started_at >= CURRENT_DATE ORDER BY started_at DESC LIMIT 50; -- group success rate (last 7d) SELECT client_id, store_id, ROUND(100.0 * SUM(CASE WHEN status='success' THEN 1 ELSE 0 END)/COUNT(*), 1) AS success_rate_pct FROM etl_runs WHERE started_at >= NOW() - INTERVAL '7 days' GROUP BY client_id, store_id;
“If you can’t observe it, you can’t improve it.”