AWS Athena metrics

Once you’ve integrated with AWS CloudWatch, you have access to metrics from AWS Athena, which is utilizing conventional SQL, data may be easily analyzed directly in Amazon Simple Storage Service (Amazon S3) using an interactive query service. You can aim Athena at your data stored in Amazon S3 and start using conventional SQL to conduct ad-hoc queries and obtain results in seconds with a few clicks in the AWS Management Console.

See all AWS integrations.

To verify metrics are reporting, search for the metrics in the Metric details section of the Settings page.

The following table shows the Athena metrics ingested by Cloud Observability.

Metric Name Unit Description
aws.athena.engine_execution_time milliseconds The time it took the query to execute.
aws.athena.processed_bytes bytes The volume of data that each DML query required Athena to scan. This comprises the quantity of data scanned prior to the cancellation period for queries that were canceled (either by the users or automatically, if they exceed the limit). For DDL queries, this metric is not reported.
aws.athena.query_planning_time milliseconds The length of time it took Athena to organize the query processing flow. This takes into account the time required to retrieve table partitions from the data source. Keep in mind that query planning time is a subset of engine execution time because the query engine handles query planning.
aws.athena.query_queue_time milliseconds The length of time that the query was in the query queue while waiting for resources. It should be noted that the query may be added back to the queue automatically if momentary faults happen.
aws.athena.service_processing_time milliseconds The number of milliseconds that Athena required to process the query's outcomes after the query engine had completed its work.
aws.athena.total_execution_time milliseconds The amount of time Athena needed to execute a DDL or DML query. The following execution times are included in total execution time: query queue time, query planning time, engine execution time, and service processing time.

See also

Ingest metrics from Amazon

Create and manage dashboards

Create alerts

Updated Dec 9, 2022