Metrics Insights 範例查詢 - Amazon CloudWatch
Application Load Balancer 範例AWS API 用量範例DynamoDB 範例Amazon Elastic Block Store 範例Amazon EC2 範例Amazon Elastic Container Service 範例Amazon Elastic Kubernetes Service Container Insights 範例EventBridge 範例Kinesis 範例Lambda 範例CloudWatch Logs 範例Amazon RDS 範例Amazon Simple Storage Service 範例Amazon Simple Notification Service 範例Amazon SQS 範例

本文為英文版的機器翻譯版本，如內容有任何歧義或不一致之處，概以英文版為準。

Metrics Insights 範例查詢

本節包含實用的 CloudWatch Metrics Insights 查詢範例，您可以直接複製和使用，或在查詢編輯器中複製和修改。部分範例已在主控台中提供，您可以藉由在 Metrics (指標) 檢視中選擇 Add query (新增查詢)，來存取這些範例。

Application Load Balancer 範例

所有負載平衡器的請求總計

SELECT SUM(RequestCount) 
FROM SCHEMA("AWS/ApplicationELB", LoadBalancer)

前 10 名最活躍的負載平衡器

SELECT MAX(ActiveConnectionCount) 
FROM SCHEMA("AWS/ApplicationELB", LoadBalancer) 
GROUP BY LoadBalancer 
ORDER BY SUM() DESC 
LIMIT 10

AWS API 用量範例

依您帳戶中的呼叫數量排名前 20 AWS APIs 

SELECT COUNT(CallCount) 
FROM SCHEMA("AWS/Usage", Class, Resource, Service, Type) 
WHERE Type = 'API' 
GROUP BY Service, Resource 
ORDER BY COUNT() DESC 
LIMIT 20

依呼叫排序的 CloudWatch API

SELECT COUNT(CallCount) 
FROM SCHEMA("AWS/Usage", Class, Resource, Service, Type) 
WHERE Type = 'API' AND Service = 'CloudWatch' 
GROUP BY Resource 
ORDER BY COUNT() DESC

DynamoDB 範例

取用讀取的前 10 個資料表

SELECT SUM(ProvisionedWriteCapacityUnits)
FROM SCHEMA("AWS/DynamoDB", TableName) 
GROUP BY TableName
ORDER BY MAX() DESC LIMIT 10

依傳回位元組排序的前 10 個資料表

SELECT SUM(ReturnedBytes)
FROM SCHEMA("AWS/DynamoDB", TableName) 
GROUP BY TableName
ORDER BY MAX() DESC LIMIT 10

依使用者錯誤排序的前 10 個資料表

SELECT SUM(UserErrors)
FROM SCHEMA("AWS/DynamoDB", TableName) 
GROUP BY TableName
ORDER BY MAX() DESC LIMIT 10

Amazon Elastic Block Store 範例

依寫入位元組排序的前 10 個 Amazon EBS 磁碟區

SELECT SUM(VolumeWriteBytes) 
FROM SCHEMA("AWS/EBS", VolumeId) 
GROUP BY VolumeId 
ORDER BY SUM() DESC 
LIMIT 10

Amazon EBS 磁碟區的平均寫入時間

SELECT AVG(VolumeTotalWriteTime) 
FROM SCHEMA("AWS/EBS", VolumeId)

Amazon EC2 範例

依最高排序的 EC2 執行個體 CPU 使用率

SELECT AVG(CPUUtilization) 
  FROM SCHEMA("AWS/EC2", InstanceId) 
  GROUP BY InstanceId 
  ORDER BY AVG() DESC

整個機群的平均 CPU 使用率

SELECT AVG(CPUUtilization) 
FROM SCHEMA("AWS/EC2", InstanceId)

依最高 CPU 使用率排序的前 10 個執行個體

SELECT MAX(CPUUtilization) 
FROM SCHEMA("AWS/EC2", InstanceId) 
GROUP BY InstanceId 
ORDER BY MAX() DESC 
LIMIT 10

在這種情況下，CloudWatch 代理程式正在收集每個應用程式的 CPUUtilization 指標。此查詢會針對特定應用程式名稱篩選此指標的平均值。

SELECT AVG(CPUUtilization)
FROM "AWS/CWAgent"
WHERE ApplicationName = 'eCommerce'

Amazon Elastic Container Service 範例

所有 ECS 叢集的平均 CPU 使用率

SELECT AVG(CPUUtilization) 
FROM SCHEMA("AWS/ECS", ClusterName)

依記憶體使用率排序的前 10 個叢集

SELECT AVG(MemoryUtilization) 
FROM SCHEMA("AWS/ECS", ClusterName) 
GROUP BY ClusterName 
ORDER BY AVG() DESC
LIMIT 10

依 CPU 使用率排序的前 10 項服務

SELECT AVG(CPUUtilization) 
FROM SCHEMA("AWS/ECS", ClusterName, ServiceName) 
GROUP BY ClusterName, ServiceName 
ORDER BY AVG() DESC 
LIMIT 10

依執行任務排序的前 10 項服務 (Container Insights)

SELECT AVG(RunningTaskCount) 
FROM SCHEMA("ECS/ContainerInsights", ClusterName, ServiceName) 
GROUP BY ClusterName, ServiceName 
ORDER BY AVG() DESC 
LIMIT 10

Amazon Elastic Kubernetes Service Container Insights 範例

所有 EKS 叢集的平均 CPU 使用率

SELECT AVG(pod_cpu_utilization) 
FROM SCHEMA("ContainerInsights", ClusterName)

依節點 CPU 使用率排序的前 10 個叢集

SELECT AVG(node_cpu_utilization) 
FROM SCHEMA("ContainerInsights", ClusterName) 
GROUP BY ClusterName
ORDER BY AVG() DESC LIMIT 10

依 Pod 記憶體使用率排序的前 10 個叢集

SELECT AVG(pop_memory_utilization) 
FROM SCHEMA("ContainerInsights", ClusterName) 
GROUP BY ClusterName
ORDER BY AVG() DESC LIMIT 10

依 CPU 使用率排序的前 10 個節點

SELECT AVG(node_cpu_utilization) 
FROM SCHEMA("ContainerInsights", ClusterName, NodeName) 
GROUP BY ClusterName, NodeName 
ORDER BY AVG() DESC LIMIT 10

依記憶體使用率排序的前 10 個 Pod

SELECT AVG(pod_memory_utilization) 
FROM SCHEMA("ContainerInsights", ClusterName, PodName) 
GROUP BY ClusterName, PodName 
ORDER BY AVG() DESC LIMIT 10

EventBridge 範例

依調用排序的前 10 個規則

SELECT SUM(Invocations)
FROM SCHEMA("AWS/Events", RuleName) 
GROUP BY RuleName
ORDER BY MAX() DESC LIMIT 10

依失敗調用排序的前 10 個規則

SELECT SUM(FailedInvocations)
FROM SCHEMA("AWS/Events", RuleName) 
GROUP BY RuleName
ORDER BY MAX() DESC LIMIT 10

依相符規則排序的前 10 個規則

SELECT SUM(MatchedEvents)
FROM SCHEMA("AWS/Events", RuleName) 
GROUP BY RuleName
ORDER BY MAX() DESC LIMIT 10

Kinesis 範例

依寫入位元組排序的前 10 個串流

SELECT SUM("PutRecords.Bytes") 
FROM SCHEMA("AWS/Kinesis", StreamName) 
GROUP BY StreamName
ORDER BY SUM() DESC LIMIT 10

依串流中最早項目排序的前 10 個串流

SELECT MAX("GetRecords.IteratorAgeMilliseconds") 
FROM SCHEMA("AWS/Kinesis", StreamName) 
GROUP BY StreamName
ORDER BY MAX() DESC LIMIT 10

Lambda 範例

依調用次數排序的 Lambda 函數

SELECT SUM(Invocations) 
FROM SCHEMA("AWS/Lambda", FunctionName) 
GROUP BY FunctionName 
ORDER BY SUM() DESC

依最長執行時間排序的前 10 個 Lambda 函數

SELECT AVG(Duration) 
FROM SCHEMA("AWS/Lambda", FunctionName) 
GROUP BY FunctionName 
ORDER BY MAX() DESC 
LIMIT 10

依錯誤計數排序的前 10 個 Lambda 函數

SELECT SUM(Errors) 
FROM SCHEMA("AWS/Lambda", FunctionName) 
GROUP BY FunctionName 
ORDER BY SUM() DESC 
LIMIT 10

CloudWatch Logs 範例

依傳入事件排序的前 10 個日誌群組

SELECT SUM(IncomingLogEvents)
FROM SCHEMA("AWS/Logs", LogGroupName) 
GROUP BY LogGroupName
ORDER BY SUM() DESC LIMIT 10

依寫入位元組排序的前 10 個日誌群組

SELECT SUM(IncomingBytes)
FROM SCHEMA("AWS/Logs", LogGroupName) 
GROUP BY LogGroupName
ORDER BY SUM() DESC LIMIT 10

Amazon RDS 範例

依最高 CPU 使用率排序的前 10 個 Amazon RDS 執行個體

SELECT MAX(CPUUtilization)
FROM SCHEMA("AWS/RDS", DBInstanceIdentifier) 
GROUP BY DBInstanceIdentifier
ORDER BY MAX() DESC 
LIMIT 10

按寫入排序的前 10 個 Amazon RDS 叢集

SELECT SUM(WriteIOPS)
FROM SCHEMA("AWS/RDS", DBClusterIdentifier) 
GROUP BY DBClusterIdentifier
ORDER BY MAX() DESC 
LIMIT 10

Amazon Simple Storage Service 範例

儲存貯體的平均延遲

SELECT AVG(TotalRequestLatency) 
FROM SCHEMA("AWS/S3", BucketName, FilterId) 
WHERE FilterId = 'EntireBucket' 
GROUP BY BucketName 
ORDER BY AVG() DESC

依位元組下載的前 10 個儲存貯體

SELECT SUM(BytesDownloaded) 
FROM SCHEMA("AWS/S3", BucketName, FilterId) 
WHERE FilterId = 'EntireBucket'
GROUP BY BucketName 
ORDER BY SUM() DESC 
LIMIT 10

Amazon Simple Notification Service 範例

SNS 主題發佈的訊息總數

SELECT SUM(NumberOfMessagesPublished) 
FROM SCHEMA("AWS/SNS", TopicName)

依已發佈訊息排序的前 10 大主題

SELECT SUM(NumberOfMessagesPublished) 
FROM SCHEMA("AWS/SNS", TopicName) 
GROUP BY TopicName 
ORDER BY SUM() DESC 
LIMIT 10

依訊息傳遞失敗排序的前 10 大主題

SELECT SUM(NumberOfNotificationsFailed) 
FROM SCHEMA("AWS/SNS", TopicName)
GROUP BY TopicName 
ORDER BY SUM() DESC 
LIMIT 10

Amazon SQS 範例

依可見訊息數量排名前 10 個佇列

SELECT AVG(ApproximateNumberOfMessagesVisible)
FROM SCHEMA("AWS/SQS", QueueName) 
GROUP BY QueueName
ORDER BY AVG() DESC 
LIMIT 10

前 10 個最活躍的佇列

SELECT SUM(NumberOfMessagesSent)
FROM SCHEMA("AWS/SQS", QueueName) 
GROUP BY QueueName
ORDER BY SUM() DESC 
LIMIT 10

依最早訊息存留天數排序的前 10 個佇列

SELECT AVG(ApproximateAgeOfOldestMessage)
FROM SCHEMA("AWS/SQS", QueueName) 
GROUP BY QueueName
ORDER BY AVG() DESC 
LIMIT 10