让数据转化为行动

-- One query, six workloads, one engine
SELECT id, name,
  v.embedding <=> $query_vec AS similarity,
  match(d.body, $keywords) AS relevance,
  ST_Distance(geo, $origin) AS distance_m,
  d.metadata->>'tier' AS tier,
  ts.value AS last_reading
FROM events e
JOIN vectors    v  ON v.event_id  = e.id
JOIN documents  d  ON d.event_id  = e.id
JOIN timeseries ts ON ts.event_id = e.id
WHERE ts.ts > now() - INTERVAL '1 minute'
  AND v.embedding <=> $query_vec < 0.30
ORDER BY similarity ASC LIMIT 25;
→ 25 rows  in  0.8 ms p99