List Postgres blocking queries
This endpoint is in beta. API contract is stable, and no breaking changes are expected in the future.
Returns which queries waited on locks held by other queries on a Postgres service during the given time window. Each item groups one waiting query with one direct blocker, most-sampled first. Groups come only from periods when blocking query collection was on for the service; turn it on in the console. Results are paginated with limit/offset and include totalCount. The time range must not exceed 31 days, and to_date must be after from_date.
Returns which queries waited on locks held by other queries on a Postgres service during the given time window. Each item groups one waiting query with one direct blocker, most-sampled first. Groups come only from periods when blocking query collection was on for the service; turn it on in the console. Results are paginated with
limit/offset and include totalCount. The time range must not exceed 31 days, and to_date must be after from_date.
Authorizations
Use key ID and key secret obtained in ClickHouse Cloud console: https://clickhouse.com/docs/cloud/manage/openapi