List Slowest Queries

GET

https://api.captain.dev/v2/queries/latency/slowest

GET

/v2/queries/latency/slowest

import requests
BASE_URL = "https://api.captain.dev"
API_KEY = "your_api_key"
response = requests.get(
    f"{BASE_URL}/v2/queries/latency/slowest",
    headers={"Authorization": f"Bearer {API_KEY}"},
    params={
        "from": "2026-09-01",
        "to": "2026-09-08",
        "limit": 2,
    },
    timeout=30.0
)
if response.status_code == 200:
    for q in response.json()["queries"]:
        print(f"{q['duration_ms']:6d} ms  {q['collection_name']:24s} {q['occurred_at']}")
        # Either id opens the stored query: GET /v2/queries/{query_id}
        # accepts the request_id as well.
        print(f"        {q['query_id'] or q['request_id']}")
else:
    print(f"Error: {response.status_code}")

{
  "generated_at": "2026-09-08T00:04:02.118Z",
  "window": {
    "from": "2026-09-01T00:00:00Z",
    "to": "2026-09-08T00:00:00Z"
  },
  "queries": [
    {
      "collection_name": "policy_library",
      "duration_ms": 4820,
      "occurred_at": "2026-09-07T18:22:41.845Z",
      "request_id": "req_1788804161_7b41c0a9",
      "query_id": null
    },
    {
      "collection_name": "customer_forms",
      "duration_ms": 3106,
      "occurred_at": "2026-09-07T11:14:14.272Z",
      "request_id": "req_1788801254_3e92da5f",
      "query_id": "c4b662cd-aba2-4918-8346-4b975484eded"
    }
  ]
}

The slowest queries in the window, with ids and durations only.

Sorted by duration in the analytics store, so it costs one bounded read rather than a walk through chronological history. Pass a request_id to GET /v2/queries/{query_id} to open the query itself.

Query parameters

fromstring or nullOptional

tostring or nullOptional

limitintegerOptional1-20Defaults to 5

collectionstring or nullOptional

api_versionstring or nullOptional

rerankstring or nullOptional

search_modestring or nullOptional

has_filterstring or nullOptional

Response

Successful Response

generated_atstring

windowobject

querieslist of objectsOptional

Errors

400

Bad Request Error

401

Unauthorized Error

403

Forbidden Error

422

Unprocessable Entity Error

503

Service Unavailable Error