Version history

{
  "query_kind": "sql",
  "query_body": "SELECT se.search_query_hash AS ref, COUNT(*)::text AS title\nFROM site_events se\nWHERE se.content_type = 'search'\n  AND se.created_at > NOW() - INTERVAL '7 days'\n  AND se.search_query_hash IS NOT NULL\n  AND se.path = '/search'\n  AND NOT EXISTS (\n    SELECT 1 FROM site_events se2\n    WHERE se2.search_query_hash = se.search_query_hash\n      AND se2.path != '/search'\n      AND se2.created_at > NOW() - INTERVAL '7 days'\n  )\nGROUP BY se.search_query_hash\nHAVING COUNT(*) >= 3\n",
  "query_params": {},
  "threshold": {
    "warning_at": 1,
    "critical_at": 20
  },
  "severity_default": "info",
  "recommended_action_template": "{n} search query hash(es) appear ≥3 times on empty result pages\n(/search with no subsequent non-search pageview) in the last 7d.\nThese may indicate missing content or crawl gaps. Hashes: {refs[:5]}.\n",
  "state": "active",
  "proposer_id": "system-senate"
}