Postgres

List Postgres server logs

This endpoint is in beta. API contract is stable, and no breaking changes are expected in the future. <br /><br /> 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.

get/v1/organizations/{organizationId}/postgres/{postgresId}/logs

Request

  • Base URL: https://api.clickhouse.cloud
  • URL: https://api.clickhouse.cloud/v1/organizations/{organizationId}/postgres/{postgresId}/logs
  • Auth: HTTP basic

Path parameters

organizationIdstring uuid required

ID of the organization that owns the Postgres service.

postgresIdstring uuid required

ID of the requested Postgres service.

Query parameters

from_datestring date-time required

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

to_datestring date-time required

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

body_containsstring

Case-sensitive substring the log body must contain.

severitystring

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

sort_order'asc' | 'desc'

Sort order. One of asc or desc.

limitinteger

Maximum number of results to return.

offsetinteger

Number of results to skip before returning.

Response

Successful response

statusnumber

HTTP status code.

requestIdstring uuid

Unique id assigned to every request. UUIDv4

Example response

{
  "status": 200
}

Changes

No recorded changes to this operation across all 1 revision of this API.