AWS Integration - Athena
Mackerel supports obtaining and monitoring Amazon Athena metrics in AWS Integration. When integrating with AWS Integration, billable targets are determined using the conversion 1 Workgroup = 1 Micro Host. In addition to this, depending on the number of metrics retrieved, you may be charged for exceeding the maximum number of metrics per micro host.
Please refer to the following page for AWS Integration configuration methods and a list of supported AWS services.
AWS Integration
Obtaining metrics
The metrics obtainable with AWS Integration's Athena support are as follows. For Metric explanations, refer to the AWS help page.
The maximum number of metrics obtainable is 63.
| Graph name | Metric | Metric name in Mackerel | Unit | Statistics |
|---|---|---|---|---|
| Processed Bytes | ProcessedBytes | athena.processed_bytes.#.average athena.processed_bytes.#.max athena.processed_bytes.#.min | bytes | Average Maximum Minimum |
| Time of DML [ms] | EngineExecutionTime QueryPlanningTime QueryQueueTime ServicePreProcessingTime ServiceProcessingTime TotalExecutionTime | athena.time.dml.#.engine_execution athena.time.dml.#.query_planning athena.time.dml.#.query_queue athena.time.dml.#.service_pre_processing athena.time.dml.#.service_processing athena.time.dml.#.total_execution | float | Average |
| Time of DDL [ms] | EngineExecutionTime QueryPlanningTime QueryQueueTime ServicePreProcessingTime ServiceProcessingTime TotalExecutionTime | athena.time.ddl.#.engine_execution athena.time.ddl.#.query_planning athena.time.ddl.#.query_queue athena.time.ddl.#.service_pre_processing athena.time.ddl.#.service_processing athena.time.ddl.#.total_execution | float | Average |
| Time of UTILITY [ms] | EngineExecutionTime QueryPlanningTime QueryQueueTime ServicePreProcessingTime ServiceProcessingTime TotalExecutionTime | athena.time.utility.#.engine_execution athena.time.utility.#.query_planning athena.time.utility.#.query_queue athena.time.utility.#.service_pre_processing athena.time.utility.#.service_processing athena.time.utility.#.total_execution | float | Average |
- The
#in "Metric name in Mackerel" will be filled with eitherSUCCEEDED,FAILED, orCANCELEDwhich are the results of Athena queries.