Metrics Insights 範例查詢

本節包含有用的 CloudWatch 指標見解查詢範例，您可以直接複製和使用，或在查詢編輯器中複製和修改這些查詢。部分範例已在主控台中提供，您可以藉由在 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 API

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 記錄檔範例

依傳入事件排序的前 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