API Reference
  1. Database Optimizer
  2. CachingAPI

Get cache query insights for a proxy database

get
https://api.cast.ai/database-optimizer/caching/v1alpha/organizations//proxies//databases//queries//insights

Get per-template query insights for a specific logical database behind a proxy.

Returns timeseries of query insights (cache miss latency percentiles, TTL bounds, unique query/result counts)
plus an aggregate summary over the requested period.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…
Path Params
string
required

Organization identifier

string
required

Proxy identifier

string
required

Name of the logical database within the proxy

string
required

Hash of the normalized SQL template

Query Params
date-time

Start of the reporting period

date-time

End of the reporting period

uint32

Aggregate items in specified interval steps

Responses

Updated 3 hours ago

Did this page help you?
Language
Credentials
URL
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json

Updated 3 hours ago

Did this page help you?