Pular para o conteúdo principal
GET
Get a Postgres slow query pattern with recent executions
Returns aggregate metrics for a single slow query pattern together with its most recent individual executions.

Permission

The API key must have the control-plane:postgres-service:view permission.

Autorizações

Authorization
string
header
obrigatório

Use key ID and key secret obtained in ClickHouse Cloud console: https://clickhouse.com/docs/cloud/manage/openapi

Parâmetros de caminho

organizationId
string<uuid>
obrigatório

ID of the organization that owns the Postgres service.

postgresId
string<uuid>
obrigatório

ID of the requested Postgres service.

queryId
string
obrigatório

Stable identifier for the query pattern.

Parâmetros de consulta

db_name
string
obrigatório

Database name filter.

db_user
string
obrigatório

Database user filter.

db_operation
string
obrigatório

Database operation filter (for example, SELECT, INSERT, UPDATE, DELETE, UTILITY).

app
string

Application name filter.

timestamp
string<date-time>

Timestamp of a specific execution (RFC 3339).

Resposta

Successful response

status
number

HTTP status code.

Exemplo:

200

requestId
string<uuid>

Unique id assigned to every request. UUIDv4

result
object