List queries seen by the proxy for a database

get

https://api.cast.ai/database-optimizer/caching/v1alpha/organizations/{organizationId}/proxies/{proxyId}/databases/{databaseName}/queries

List queries seen by the proxy for a specific logical database.

Returns per-template aggregated query statistics (cache hits, misses, execution times, etc.)
derived from proxy query metrics over the requested period.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Path Params

organizationId

string

required

Organization identifier

proxyId

string

required

Proxy identifier

databaseName

string

required

Name of the logical database within the proxy

Query Params

page.limit

string

Defines the number of items that should be returned

page.cursor

string

Cursor that defines token indicating where to start the next page.
Empty value indicates to start from beginning of the dataset.

sort.field

string

The field name to order by. Nested fields can be specified by using a dot (e.g. user.name).

sort.order

string

enum

The order of returned items. Default is ASC.

Allowed:

startTime

date-time

Start of the reporting period. Defaults to last 7 days if both start and end are unset.

endTime

date-time

End of the reporting period

queryContains

string

Optional substring filter on the normalized SQL template

Responses

Language

Credentials

URL

Loading…

Response

Click Try It! to start a request and see the response here! Or choose an example:

application/json

200OK

defaultDefault error response