data_warehouse

Get managed warehouse Trino monitoring time series

Changed on

Get one allow-listed Trino monitoring metric for the current organization and trailing time window.

get/api/projects/{project_id}/data_warehouse/managed-warehouse-trino-monitoring-timeseries/

Request

  • Base URL: https://us.posthog.com
  • URL: https://us.posthog.com/api/projects/{project_id}/data_warehouse/managed-warehouse-trino-monitoring-timeseries/
  • Auth: HTTP bearer

Path parameters

project_idstring required

Project ID of the project you're trying to access. To find the ID of the project, make a call to /api/projects/.

Query parameters

metric'queries_in_flight' | 'query_rate' | 'error_ratio' | 'duration_p50' | 'duration_p95' | 'queue_time_p95' | 'scanned_bytes_rate' | 'cpu_seconds_rate' | 'storage_bytes' required

Allow-listed Trino metric to retrieve.

  • queries_in_flight - queries_in_flight
  • query_rate - query_rate
  • error_ratio - error_ratio
  • duration_p50 - duration_p50
  • duration_p95 - duration_p95
  • queue_time_p95 - queue_time_p95
  • scanned_bytes_rate - scanned_bytes_rate
  • cpu_seconds_rate - cpu_seconds_rate
  • storage_bytes - storage_bytes
window'1h' | '6h' | '24h' | '7d' | '30d'

Trailing time window to retrieve. Defaults to 24h.

  • 1h - 1h
  • 6h - 6h
  • 24h - 24h
  • 7d - 7d
  • 30d - 30d

Response

One organization-scoped Trino monitoring metric over time.

schema_versioninteger required

Version of the managed warehouse monitoring response schema.

org_idstring required

Organization whose managed warehouse is represented.

metricstring required

Allow-listed metric returned by this response.

unitstring required

Unit for every value in the response.

startstring date-time required

Inclusive UTC start of the returned time window.

endstring date-time required

Inclusive UTC end of the returned time window.

step_secondsinteger required

Number of seconds between requested samples.

Changes