API Reference
  1. Database Optimizer
  2. DatabaseInstancesAPI

List query templates failing with a given upstream error code

get
https://api.cast.ai/database-optimizer/database-instances/v1alpha/organizations//database-instances//query-errors//templates

List query templates that failed with a given upstream error code

Returns the normalized SQL fingerprints (query templates) that failed with
a specific upstream error code for a database instance over the requested
period, ordered by occurrence count descending.

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

Organization identifier

string
required

Database instance identifier

string
required

Upstream error code (e.g. "42P01", "1146", "UNKNOWN")

Query Params
date-time

Start of the reporting period. When omitted along with end_time,
defaults to the last 24 hours.

date-time

End of the reporting period. When omitted along with start_time,
defaults to now.

string

Filter by logical database identifier. When omitted, all databases behind
the proxy are included.

Responses

Updated 1 hour 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 1 hour ago

Did this page help you?