Sync status

-- Most recent 200 publish attempts, cross-resource
SELECT
  created_at, resource, event_id, trigger, retry_attempt,
  response_status, seq, request_bytes, latency_ms,
  error_class, error_message
FROM publish_audit
ORDER BY created_at DESC
LIMIT 200;

-- 7-day per-resource success rate
SELECT
  resource,
  COUNT(*) AS attempts,
  SUM(CASE WHEN response_status BETWEEN 200 AND 299 THEN 1 ELSE 0 END) AS succeeded
FROM publish_audit
WHERE created_at >= datetime('now', '-7 days')
GROUP BY resource
ORDER BY succeeded * 100.0 / attempts ASC;

-- "Did proposal 7 ever successfully publish?"
SELECT created_at, response_status, error_class, error_message
FROM publish_audit
WHERE resource = 'proposals' AND event_id = 2
ORDER BY created_at DESC;