ClickHouse Cloud: Clickhouse Slow Query Patterns Get List

List the slowest query patterns on a ClickHouse Cloud Postgres service over a time window.

Tool ID: clickhouse_slow_query_patterns_get_list

Run this action

Use the TypeScript SDK for one call. Use ctx.tools.execute(...) inside a Play for durable calls, scheduled calls, or CSV processing.

import { Deepline } from 'deepline';

const deepline = await Deepline.connect();
const result = await deepline.tools.execute(
  'clickhouse_slow_query_patterns_get_list',
  {
    "organizationId": "123e4567-e89b-42d3-a456-426614174000",
    "postgresId": "123e4567-e89b-42d3-a456-426614174000",
    "from_date": "2026-01-15T12:00:00Z",
    "to_date": "2026-01-15T12:00:00Z"
  },
);

console.log(result.toolResponse.raw);

CLI

deepline tools execute clickhouse_slow_query_patterns_get_list --input '{
  "organizationId": "123e4567-e89b-42d3-a456-426614174000",
  "postgresId": "123e4567-e89b-42d3-a456-426614174000",
  "from_date": "2026-01-15T12:00:00Z",
  "to_date": "2026-01-15T12:00:00Z"
}' --json

Example response

The SDK returns this shape at result.toolResponse.raw. The example values illustrate the response.

{
  "data": {
    "status": 123,
    "requestId": "123e4567-e89b-42d3-a456-426614174000",
    "result": [
      {
        "queryId": "query_123",
        "queryText": "software companies hiring engineers",
        "dbName": "Example",
        "dbUser": "example",
        "dbOperation": "example",
        "app": "example",
        "callCount": 123,
        "errorCount": 123,
        "totalDurationUs": 123,
        "avgDurationUs": 123,
        "maxDurationUs": 123,
        "p50DurationUs": 123,
        "p95DurationUs": 123,
        "p99DurationUs": 123,
        "totalRows": 123,
        "totalSharedBlksRead": 123,
        "totalSharedBlksHit": 123,
        "totalCpuTimeUs": 123,
        "totalWalBytes": 123
      }
    ]
  }
}

Use deepline describe clickhouse_slow_query_patterns_get_list --json for the latest machine-readable contract.

Input reference

This endpoint is in beta. API contract is stable, and no breaking changes are expected in the future. Returns aggregate metrics for the slowest query patterns observed on a Postgres service during the given time window. Use this to discover which queries dominate total execution time, CPU, I/O, or WAL generation.

Name	Type	Required	Default	Details
`payload.organizationId`	`string`	Yes	—	ID of the organization that owns the Postgres service. Format: `uuid`.
`payload.postgresId`	`string`	Yes	—	ID of the requested Postgres service. Format: `uuid`.
`payload.from_date`	`string`	Yes	—	Inclusive start of the time window (RFC 3339 date-time). Format: `date-time`.
`payload.to_date`	`string`	Yes	—	Exclusive end of the time window (RFC 3339 date-time). Format: `date-time`.
`payload.db_name`	`string`	No	—	Database name filter.
`payload.db_user`	`string`	No	—	Database user filter.
`payload.db_operation`	`string`	No	—	Database operation filter (for example, SELECT, INSERT, UPDATE, DELETE, UTILITY).
`payload.app`	`string`	No	—	Application name filter.
`payload.sort_by`	`"total_duration" \| "avg_duration" \| "call_count" \| "total_blks_read" \| "total_cpu_time" \| "error_count" \| "max_duration" \| "p50_duration" \| "p95_duration" \| "p99_duration" \| "total_rows" \| "total_shared_blks_hit" \| "total_wal_bytes"`	No	`"total_duration"`	Field to sort results by. Allowed: `total_duration`, `avg_duration`, `call_count`, `total_blks_read`, `total_cpu_time`, `error_count`, `max_duration`, `p50_duration`, `p95_duration`, `p99_duration`, `total_rows`, `total_shared_blks_hit`, `total_wal_bytes`.
`payload.sort_order`	`"asc" \| "desc"`	No	`"desc"`	Sort order. One of `asc` or `desc`. Allowed: `asc`, `desc`.
`payload.limit`	`integer`	No	`20`	Maximum number of results to return. Minimum: 1. Maximum: 500.
`payload.offset`	`integer`	No	`0`	Number of results to skip before returning. Minimum: 0.

Output reference

Standard tool result payload.

Name	Type	Required	Default	Details
`result.data`	`object`	Yes	—	Provider response payload.
`result.data.status`	`number`	No	—	HTTP status code.
`result.data.requestId`	`string`	No	—	Unique id assigned to every request. UUIDv4 Format: `uuid`.
`result.data.result`	`array`	No	—	—
`result.data.result[].queryId`	`string`	Yes	—	Stable identifier for the query pattern (normalized SQL).
`result.data.result[].queryText`	`string`	Yes	—	Normalized query text with literals replaced by placeholders.
`result.data.result[].dbName`	`string`	Yes	—	Database the query ran in.
`result.data.result[].dbUser`	`string`	Yes	—	Database user that executed the query.
`result.data.result[].dbOperation`	`string`	Yes	—	Top-level SQL operation type (for example, SELECT, INSERT, UPDATE, DELETE, UTILITY).
`result.data.result[].app`	`string`	Yes	—	Value of the Postgres `application_name` for executions matching this pattern.
`result.data.result[].callCount`	`integer`	Yes	—	Number of times the pattern executed in the window.
`result.data.result[].errorCount`	`integer`	Yes	—	Number of executions of the pattern that raised an error.
`result.data.result[].totalDurationUs`	`integer`	Yes	—	Total execution time across all calls, in microseconds.
`result.data.result[].avgDurationUs`	`integer`	Yes	—	Average execution time per call, in microseconds.
`result.data.result[].maxDurationUs`	`integer`	Yes	—	Maximum execution time of any call, in microseconds.
`result.data.result[].p50DurationUs`	`integer`	Yes	—	50th percentile execution time, in microseconds.
`result.data.result[].p95DurationUs`	`integer`	Yes	—	95th percentile execution time, in microseconds.
`result.data.result[].p99DurationUs`	`integer`	Yes	—	99th percentile execution time, in microseconds.
`result.data.result[].totalRows`	`integer`	Yes	—	Total number of rows returned or affected across all calls.
`result.data.result[].totalSharedBlksRead`	`integer`	Yes	—	Total shared buffer blocks read from disk (cache misses) across all calls.
`result.data.result[].totalSharedBlksHit`	`integer`	Yes	—	Total shared buffer blocks hit (cache hits) across all calls.
`result.data.result[].totalCpuTimeUs`	`integer`	Yes	—	Total CPU time across all calls, in microseconds.
`result.data.result[].totalWalBytes`	`integer`	Yes	—	Total WAL (write-ahead log) bytes generated across all calls.
`result.meta`	`object`	No	—	Additional response metadata (status, paging).

Deepline cost

Pricing model: fixed (per call).
Estimated Deepline credits: 0 per pricing unit.
Provider-native pricing may still exist outside Deepline credit billing.

​Run this action

​CLI

​Example response

​Input reference

​Output reference

​Deepline cost

​Related documentation

Run this action

CLI

Example response

Input reference

Output reference

Deepline cost

Related documentation