Search queries returning zero results

Details

query_kind: sql
severity_default: info
recommended_action_template: {n} search query hash(es) appear ≥3 times on empty result pages (/search with no subsequent non-search pageview) in the last 7d. These may indicate missing content or crawl gaps. Hashes: {refs[:5]}.
state: active
proposer_id: system-senate

Raw fields (3)

query_body

SELECT se.search_query_hash AS ref, COUNT(*)::text AS title
FROM site_events se
WHERE se.content_type = 'search'
  AND se.created_at > NOW() - INTERVAL '7 days'
  AND se.search_query_hash IS NOT NULL
  AND se.path = '/search'
  AND NOT EXISTS (
    SELECT 1 FROM site_events se2
    WHERE se2.search_query_hash = se.search_query_hash
      AND se2.path != '/search'
      AND se2.created_at > NOW() - INTERVAL '7 days'
  )
GROUP BY se.search_query_hash
HAVING COUNT(*) >= 3

query_params

{}

threshold

{
  "warning_at": 1,
  "critical_at": 20
}

Search queries returning zero results

Details

Replication

Discussion