Version history

{
  "query_kind": "sql",
  "query_body": "WITH recent_summaries AS (\n  SELECT content\n  FROM artifacts\n  WHERE artifact_type = 'site_engagement_summary'\n    AND is_latest = 1\n    AND created_at > NOW() - INTERVAL '14 days'\n  ORDER BY created_at DESC\n  LIMIT 1\n),\ntop_paths AS (\n  SELECT\n    (s.content->'top_paths') path_obj,\n    (s.content->>'date')::date AS summary_date\n  FROM recent_summaries s\n),\npath_flat AS (\n  SELECT\n    p.path_obj->>'path' AS path,\n    (p.path_obj->>'pageviews')::int AS pageviews\n  FROM top_paths p\n)\nSELECT path AS ref, pageviews::text AS title\nFROM path_flat\nWHERE pageviews > 100\n  AND path NOT IN (\n    SELECT DISTINCT se.path\n    FROM site_events se\n    WHERE se.created_at > NOW() - INTERVAL '14 days'\n      AND se.dwell_ms > 5000\n  )\n",
  "query_params": {},
  "threshold": {
    "warning_at": 1,
    "critical_at": 10
  },
  "severity_default": "info",
  "recommended_action_template": "{n} path(s) have >100 pageviews but no session with dwell >5s in\nthe last 14d — likely broken links or missing content.\nInvestigate: {refs[:5]}.\n",
  "state": "active",
  "proposer_id": "system-senate"
}