Analyze HNSW recall
analyze_hnsw_recallSweeps ef_search values to measure latency and recall trade-off for a pgvector query against exact brute-force ground truth.
Instructions
Sweeps ef_search values to measure the latency and recall trade-off curve for a given pgvector query vector against exact brute-force ground truth. Requires the vector extension. Returns a list of objects with ef_search, recall_at_k, mean_latency_ms, and p95_latency_ms — one row per ef_search value tested.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| k | No | ||
| table | Yes | ||
| column | Yes | ||
| metric | No | l2 | |
| schema | Yes | ||
| database | No | Optional: target a configured secondary (read-only) database by name; omit for the primary. Call list_databases to see the configured ids. | |
| query_vector | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |