あなたのAIネイティブ主権データプラン

-- One query, four workloads, one engine
SELECT id, name,
  v.embedding <=> $query_vec AS similarity,
  ST_Distance(geo, $origin) AS distance_m,
  ts.value AS last_reading
FROM events e
JOIN vectors    v  ON v.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