trino-observability-platform

Export Trino JMX metrics to Prometheus with Grafana dashboards and alert rules.

14|1|Updated May 5, 2026
One-click install
npx skills add https://github.com/ivanshamaev/de-agent-skills --skill trino-observability-platform
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: trino-observability-platform
Source: https://github.com/ivanshamaev/de-agent-skills/tree/main/group_skills/trino_group_skills/trino_observability_platform
Command: npx skills add https://github.com/ivanshamaev/de-agent-skills --skill trino-observability-platform

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Trino clusters can silently degrade due to queuing, latency spikes, memory pressure, or OOM events, making it hard to detect issues early and diagnose root causes fast.

Core Features & Use Cases

  • Prometheus metrics from Trino JMX: Export running/queued/failed queries, execution latency percentiles, memory pool usage, worker heartbeat health, and JVM metrics for alerting and trend analysis.
  • Grafana dashboard panels for fast triage: Visualize query activity, latency (P50/P90/P99), free vs total memory, active workers, OOM kill rate, and input throughput to support SLA dashboards and incident investigations.
  • OpenTelemetry trace context propagation: Link orchestration spans to Trino queries via session headers for end-to-end tracing across your data platform.
  • Structured query logging via a Trino Event Listener: Emit JSON records for slow or failed queries with query text, timings, memory, and failure details to enable high-signal investigations.
  • Prometheus alert rules and REST-based query history analysis: Detect worker loss, queue depth, high P99 latency, failure rate anomalies, and memory pressure while supporting slow-query discovery via Trino’s API.

Quick Start

Configure the Trino JMX Prometheus exporter, wire it into Prometheus with scrape targets for coordinator and workers, and import the provided Grafana panels to get immediate visibility into query latency, queue depth, and memory pressure.

Frequently Asked Questions about trino-observability-platform

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I monitor Trino query latency and memory pressure in Prometheus?

Monitor Trino query latency and memory pressure by configuring a JMX exporter to scrape coordinator and worker JVM metrics into Prometheus, exposing execution latency percentiles and memory pool usage for alerting.

How do I set up alerts for Trino worker loss, queue depth, and OOM events?

Set up alerts for Trino worker loss, queue depth, and OOM events by importing Prometheus alert rules that trigger on worker heartbeat failures, high queue depth, memory pressure anomalies, and OOM kill rate spikes.

Can I propagate OpenTelemetry trace context to Trino queries?

You can propagate OpenTelemetry trace context to Trino queries by passing trace headers via Trino session properties, linking orchestration spans to Trino queries for end-to-end pipeline visibility.

What is the best way to log slow Trino queries with memory and failure details?

Log slow Trino queries by implementing a Trino Event Listener that emits JSON records containing query text, execution timings, memory usage, and failure details for high-signal incident investigations.

How do I build a Grafana dashboard for Trino SLA monitoring and incident triage?

Build a Trino SLA dashboard by importing Grafana panel templates that visualize query activity, P50/P90/P99 latency, active workers, free vs total memory, and input throughput to support incident triage.

How do I find slow Trino queries using the REST API?

Find slow Trino queries using the REST API by executing query history analysis logic that filters recent query records by execution duration and resource consumption thresholds.