---
title: "Get managed warehouse Trino monitoring time series"
method: GET
path: "/api/projects/{project_id}/data_warehouse/managed-warehouse-trino-monitoring-timeseries/"
tags: ["data_warehouse"]
---

# Get managed warehouse Trino monitoring time series

`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

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

## Path parameters

- `project_id` string, required

## 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
- `window` '1h' | '6h' | '24h' | '7d' | '30d'

## Response `200`

One organization-scoped Trino monitoring metric over time.

- ManagedWarehouseMonitoringSeriesResponse
  - `schema_version` integer, required: Version of the managed warehouse monitoring response schema.
  - `org_id` string, required: Organization whose managed warehouse is represented.
  - `metric` string, required: Allow-listed metric returned by this response.
  - `unit` string, required: Unit for every value in the response.
  - `start` string, date-time, required: Inclusive UTC start of the returned time window.
  - `end` string, date-time, required: Inclusive UTC end of the returned time window.
  - `step_seconds` integer, required: Number of seconds between requested samples.
  - `series` ManagedWarehouseMonitoringSeries[], required: Metric series grouped by their allow-listed labels.
    - `labels` object, required: Allow-listed labels distinguishing this series, such as query outcome or acquisition source.
    - `points` ManagedWarehouseMonitoringPoint[], required: Chronologically ordered metric samples.
      - `timestamp` string, date-time, required: UTC timestamp of the sample.
      - `value` number, double, required: Metric value at the sample timestamp.

## Other responses

- `400`: The monitoring query parameters are invalid.
- `403`: Managed warehouse monitoring is not available to the caller.
- `404`: The organization does not have a managed warehouse, or this endpoint does not match its query engine.
- `501`: Managed warehouse monitoring is not configured.
- `502`: The managed warehouse monitoring service returned an invalid response or was unreachable.
- `504`: The managed warehouse monitoring service timed out.

## Changes

> 52 revisions in range; 1 not diffed.

- **2026-10-14** `43c0d2b00ce0`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/posthog/apis/posthog-api/changes/api/projects/:project_id/data_warehouse/managed-warehouse-trino-monitoring-timeseries/get.md)

---

[API](https://skmtc.dev/posthog/apis/posthog-api.md) · [All operations](https://skmtc.dev/posthog/apis/posthog-api/llms.txt) · [OpenAPI document](https://skmtc.dev/posthog/apis/posthog-api/revisions/71e64193672d?raw)
