Skip to main content
GET
List Postgres server logs
Beta This endpoint is in beta. API contract is stable, and no breaking changes are expected in the future.

Returns PostgreSQL server log entries for a Postgres service within the given time window, most recent first by default (override with sort_order). Results are paginated with limit/offset; advance offset until a page returns fewer than limit entries to read the full window. The time range must not exceed 30 days, and to_date must be after from_date.

Authorizations

Authorization
string
header
required

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

Path Parameters

organizationId
string<uuid>
required

ID of the organization that owns the Postgres service.

postgresId
string<uuid>
required

ID of the requested Postgres service.

Query Parameters

from_date
string<date-time>
required

Inclusive start of the time window (RFC 3339 date-time).

to_date
string<date-time>
required

Inclusive end of the time window (RFC 3339 date-time).

body_contains
string

Case-sensitive substring the log body must contain.

severity
string

Filter to log entries with this PostgreSQL severity (for example, ERROR, WARNING, LOG).

sort_order
enum<string>
default:desc

Sort order. One of asc or desc.

Available options:
asc,
desc
limit
integer
default:50

Maximum number of results to return.

Required range: 1 <= x <= 2000
offset
integer
default:0

Number of results to skip before returning.

Required range: x >= 0

Response

Successful response

status
number

HTTP status code.

Example:

200

requestId
string<uuid>

Unique id assigned to every request. UUIDv4

result
object[]
Last modified on August 12, 2026