Trino

Supported OS Linux Mac OS Windows

Integration version1.0.0

Overview

This check collects Trino metrics, such as the following examples:

  • Overall activity metrics: completed/failed queries, data input/output size, execution time.
  • Performance metrics: cluster memory, input CPU, execution CPU time.

Setup

Installation

For Agent v7.33.0+, follow the instructions below to install the Trino check on your host. See Use Community Integrations to install with the Docker Agent or earlier versions of the Agent.

  1. Run the following command to install the Agent integration:

    datadog-agent integration install -t datadog-trino==<INTEGRATION_VERSION>

  2. Configure your integration similar to core integrations.

Configuration

  1. Edit the trino.d/conf.yaml file, in the conf.d/ folder at the root of your Agent’s configuration directory, to start collecting your Trino performance data. See the sample trino.d/conf.yaml for all available configuration options.

    This check has a limit of 350 metrics per instance. The number of returned metrics is indicated when running the Datadog Agent status command. You can specify the metrics you are interested in by editing the configuration. To learn how to customize the metrics to collect, read JMX Checks. If you need to monitor more metrics, contact Datadog support.

  2. Restart the Agent

Validation

Run the Agent’s status subcommand and look for Trino under the Checks section.

Data Collected

Metrics

trino.execution.abandoned_queries.one_minute.count
(gauge)		Abandoned queries - one minute count.
Shown as query
trino.execution.abandoned_queries.one_minute.rate
(gauge)		Abandoned queries - one minute rate.
Shown as query
trino.execution.abandoned_queries.total_count
(gauge)		Abandoned queries - total count.
Shown as query
trino.execution.canceled_queries.one_minute.count
(gauge)		Canceled queries - one minute count.
Shown as query
trino.execution.canceled_queries.one_minute.rate
(gauge)		Canceled queries - one minute queries per second.
Shown as query
trino.execution.canceled_queries.total_count
(gauge)		Canceled queries - total count.
Shown as query
trino.execution.completed_queries.one_minute.count
(gauge)		Completed queries - one minute count.
Shown as query
trino.execution.completed_queries.one_minute.rate
(gauge)		Completed queries - one minute queries per second.
Shown as query
trino.execution.completed_queries.total_count
(gauge)		Completed queries - total count.
Shown as query
trino.execution.consumed_cpu_time_secs.one_minute.count
(gauge)		CPU (processing) time consumed - one minute count (seconds).
Shown as second
trino.execution.consumed_cpu_time_secs.one_minute.rate
(gauge)		CPU (processing) time consumed - one minute rate.
Shown as second
trino.execution.consumed_cpu_time_secs.total_count
(gauge)		CPU (processing) time consumed - total count (seconds).
Shown as second
trino.execution.cpu_input_byte_rate.all_time.avg
(gauge)		Distribution of query input data rates (cpu) - all time average bytes per second.
Shown as byte
trino.execution.cpu_input_byte_rate.all_time.p75
(gauge)		Distribution of query input data rates (cpu) - all time bytes per second - p75.
Shown as byte
trino.execution.cpu_input_byte_rate.all_time.p95
(gauge)		Distribution of query input data rates (cpu) - all time bytes per second - p95.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.avg
(gauge)		Distribution of query input data rates (cpu) - one minute average bytes per second.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.count
(gauge)		Distribution of query input data rates (cpu) - one minute count.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.max
(gauge)		Distribution of query input data rates (cpu) - one minute max bytes per second.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.min
(gauge)		Distribution of query input data rates (cpu) - one minute min bytes per second.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.p75
(gauge)		Distribution of query input data rates (cpu) - one minute bytes per second - p75.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.p95
(gauge)		Distribution of query input data rates (cpu) - one minute bytes per second - p95.
Shown as byte
trino.execution.cpu_input_byte_rate.one_minute.total
(gauge)		Distribution of query input data rates (cpu) - one minute total bytes per second.
Shown as byte
trino.execution.execution_time.all_time.avg
(gauge)		Query execution time (millisecond) - all time average.
Shown as millisecond
trino.execution.execution_time.all_time.count
(gauge)		Query execution time (millisecond) - all time count.
Shown as millisecond
trino.execution.execution_time.all_time.max
(gauge)		Query execution time (millisecond) - all time max.
Shown as millisecond
trino.execution.execution_time.all_time.min
(gauge)		Query execution time (millisecond) - all time min.
Shown as millisecond
trino.execution.execution_time.all_time.p75
(gauge)		Query execution time (millisecond) - all time - p75.
Shown as millisecond
trino.execution.execution_time.all_time.p95
(gauge)		Query execution time (millisecond) - all time - p95.
Shown as millisecond
trino.execution.execution_time.one_minute.avg
(gauge)		Query execution time (millisecond) - one minute average.
Shown as millisecond
trino.execution.execution_time.one_minute.max
(gauge)		Query execution time (millisecond) - one minute max.
Shown as millisecond
trino.execution.execution_time.one_minute.min
(gauge)		Query execution time (millisecond) - one minute min.
Shown as millisecond
trino.execution.execution_time.one_minute.p75
(gauge)		Query execution time (millisecond) - one minute p75.
Shown as millisecond
trino.execution.execution_time.one_minute.p95
(gauge)		Query execution time (millisecond) - one minute p95.
Shown as millisecond
trino.execution.executor.blocked_splits
(gauge)		Blocked splits count.
Shown as split
trino.execution.executor.running_splits
(gauge)		Running splits count.
Shown as split
trino.execution.executor.total_splits
(gauge)		Total splits count.
Shown as split
trino.execution.executor.waiting_splits
(gauge)		Waiting splits count.
Shown as split
trino.execution.executor.processor_executor.queued_task_count
(gauge)		Queued task count.
Shown as task
trino.execution.external_failures.one_minute.count
(gauge)		Failed queries (external) - one minute count.
Shown as query
trino.execution.external_failures.one_minute.rate
(gauge)		Failed queries (external) - one minute failures per second.
Shown as query
trino.execution.external_failures.total_count
(gauge)		Failed queries (external) - total count.
Shown as query
trino.execution.failed_queries.one_minute.count
(gauge)		Failed queries - one minute count.
Shown as query
trino.execution.failed_queries.one_minute.rate
(gauge)		Failed queries - one minute queries per second.
Shown as query
trino.execution.failed_queries.total_count
(gauge)		Failed queries - total count.
Shown as query
trino.execution.internal_failures.one_minute.count
(gauge)		Failed queries (internal) - one minute count.
Shown as query
trino.execution.internal_failures.one_minute.rate
(gauge)		Failed queries (internal) - one minute queries per second.
Shown as query
trino.execution.internal_failures.total_count
(gauge)		Failed queries (internal) - total count.
Shown as query
trino.execution.insufficient_resources_failures.one_minute.count
(gauge)		Insufficient resources failures one minute count.
trino.execution.insufficient_resources_failures.one_minute.rate
(gauge)		Insufficient resources failures one minute failures per second.
trino.execution.insufficient_resources_failures.total_count
(gauge)		Insufficient resources failures total count.
trino.execution.running_queries
(gauge)		Active queries.
Shown as query
trino.execution.started_queries.one_minute.count
(gauge)		Queries started - one minute count.
Shown as query
trino.execution.started_queries.one_minute.rate
(gauge)		Queries started - one minute queries per second.
Shown as query
trino.execution.started_queries.total_count
(gauge)		Queries started - total count.
Shown as query
trino.execution.user_error_failures.one_minute.count
(gauge)		Failed queries (user error) - one minute count.
Shown as query
trino.execution.user_error_failures.one_minute.rate
(gauge)		Failed queries (user error) - one minute queries per second.
Shown as query
trino.execution.user_error_failures.total_count
(gauge)		Failed queries (user error) - total count.
Shown as query
trino.execution.wall_input_bytes_rate.one_minute.avg
(gauge)		Input data rate (bytes) - one minute average.
Shown as byte
trino.execution.wall_input_bytes_rate.one_minute.max
(gauge)		Input data rate (bytes) - one minute max.
Shown as byte
trino.execution.wall_input_bytes_rate.one_minute.min
(gauge)		Input data rate (bytes) - one minute min.
Shown as byte
trino.execution.wall_input_bytes_rate.one_minute.p75
(gauge)		Input data rate (bytes) - one minute p75.
Shown as byte
trino.execution.wall_input_bytes_rate.one_minute.p95
(gauge)		Input data rate (bytes) - one minute p95.
Shown as byte
trino.memory.assigned_queries
(gauge)		Memory (assigned queries).
Shown as byte
trino.memory.blocked_nodes
(gauge)		Memory (blocked nodes).
Shown as byte
trino.memory.free_distributed_bytes
(gauge)		Memory (free distributed bytes).
Shown as byte
trino.memory.nodes
(gauge)		Memory (nodes).
Shown as byte
trino.memory.reserved_distributed_bytes
(gauge)		Memory (reserved distributed bytes).
Shown as byte
trino.memory.reserved_revocable_distributed_bytes
(gauge)		Memory (reserved revocable distributed bytes).
Shown as byte
trino.memory.total_distributed_bytes
(gauge)		Memory (total distributed bytes).
Shown as byte

Events

The Trino integration does not include any events.

Service Checks

The Trino integration does not include any service checks.

Troubleshooting

Need help? Contact Datadog support.

PREVIEWING: esther/docs-8632-slo-blog-links