Terjemahan disediakan oleh mesin penerjemah. Jika konten terjemahan yang diberikan bertentangan dengan versi bahasa Inggris aslinya, utamakan versi bahasa Inggris.

# Kueri sampel Metrics Insights
<a name="cloudwatch-metrics-insights-queryexamples"></a>

Bagian ini berisi contoh kueri Wawasan CloudWatch Metrik yang berguna yang dapat Anda salin dan gunakan secara langsung atau salin dan modifikasi di editor kueri. Beberapa contoh ini sudah tersedia di konsol, dan Anda dapat mengaksesnya dengan memilih **Tambahkan kueri** di tampilan **Metrik**.

## Contoh Penyeimbang Beban Aplikasi
<a name="cloudwatch-metrics-insights-queryexamples-applicationloadbalancer"></a>

**Total permintaan di semua penyeimbang beban**

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

**10 teratas penyeimbang beban paling aktif**

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

## AWS Contoh penggunaan API
<a name="cloudwatch-metrics-insights-queryexamples-APIusage"></a>

**Top 20 AWS APIs dengan jumlah panggilan di akun Anda**

```
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 APIs diurutkan berdasarkan panggilan**

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

## Contoh DynamoDB
<a name="cloudwatch-metrics-insights-queryexamples-DynamoDB"></a>

**10 teratas tabel dengan bacaan yang dikonsumsi**

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

**10 teratas tabel dengan byte yang dikembalikan**

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

**10 teratas tabel berdasarkan kesalahan pengguna**

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

## Contoh Amazon Elastic Block Store
<a name="cloudwatch-metrics-insights-queryexamples-EBS"></a>

**10 teratas Volume Amazon EBS berdasarkan byte yang ditulis**

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

**Rata-rata waktu tulis volume Amazon EBS**

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

## Contoh-contoh Amazon EC2
<a name="cloudwatch-metrics-insights-queryexamples-EC2"></a>

**Penggunaan CPU instans EC2 yang diurutkan berdasarkan tertinggi**

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

**Penggunaan CPU rata-rata di seluruh armada**

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

**10 teratas instans berdasarkan penggunaan CPU tertinggi**

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

**Dalam hal ini, CloudWatch agen mengumpulkan `CPUUtilization` metrik per aplikasi. Kueri ini menyaring rata-rata metrik ini untuk nama aplikasi tertentu.**

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

## Contoh Layanan Amazon Elastic Container
<a name="cloudwatch-metrics-insights-queryexamples-ECS"></a>

**Rata-rata penggunaan CPU di seluruh klaster ECS **

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

**10 teratas klaster berdasarkan penggunaan memori**

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

**10 teratas layanan berdasarkan penggunaan CPU**

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

**10 teratas layanan dengan menjalankan tugas (Wawasan Kontainer)**

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

## Contoh Amazon Elastic Kubernetes Service Container Insights
<a name="cloudwatch-metrics-insights-queryexamples-EKSCI"></a>

**Rata-rata penggunaan CPU di seluruh klaster EKS **

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

**10 teratas klaster berdasarkan penggunaan CPU simpul**

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

**10 teratas klaster berdasarkan penggunaan memori pod**

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

**10 teratas simpul berdasarkan penggunaan CPU**

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

**10 teratas pod berdasarkan penggunaan memori**

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

## EventBridge contoh
<a name="cloudwatch-metrics-insights-queryexamples-EventBridge"></a>

**10 teratas aturan berdasarkan invokasi**

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

**10 teratas aturan berdasarkan invokasi yang gagal**

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

**10 teratas aturan berdasarkan aturan yang cocok**

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

## Contoh Kinesis
<a name="cloudwatch-metrics-insights-queryexamples-Kinesis"></a>

**10 teratas aliran berdasarkan byte yang ditulis**

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

**10 teratas aliran berdasarkan item paling awal dalam aliran**

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

## Contoh Lambda
<a name="cloudwatch-metrics-insights-queryexamples-Lambda"></a>

**Fungsi Lambda yang diurutkan berdasarkan jumlah invokasi**

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

**10 teratas Fungsi Lambda berdasarkan runtime terpanjang**

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

**10 teratas Fungsi Lambda berdasarkan jumlah kesalahan**

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

## CloudWatch Contoh log
<a name="cloudwatch-metrics-insights-queryexamples-CloudWatchLogs"></a>

**10 teratas grup log berdasarkan peristiwa yang masuk**

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

**10 teratas grup log berdasarkan byte tertulis**

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

## Contoh-contoh Amazon RDS
<a name="cloudwatch-metrics-insights-queryexamples-RDS"></a>

**10 teratas Instans Amazon RDS berdasarkan penggunaan CPU tertinggi**

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

**10 teratas klaster Amazon RDS berdasarkan tulisan**

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

## Contoh Amazon Simple Storage Service
<a name="cloudwatch-metrics-insights-queryexamples-S3"></a>

**Latensi rata-rata berdasarkan bucket**

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

**10 teratas bucket berdasarkan byte yang diunduh**

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

## Contoh Amazon Simple Notification Service
<a name="cloudwatch-metrics-insights-queryexamples-SNS"></a>

**Total pesan yang diterbitkan oleh topik SNS**

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

**10 teratas topik berdasarkan pesan yang diterbitkan**

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

**10 teratas topik berdasarkan kegagalan pengiriman pesan**

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

## Contoh Amazon SQS
<a name="cloudwatch-metrics-insights-queryexamples-SQS"></a>

**10 antrian teratas berdasarkan jumlah pesan yang terlihat**

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

**10 teratas kueri paling aktif**

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

**10 teratas antrian berdasarkan umur pesan paling awal**

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