Assorted queries for AWS CloudWatch Insights

00-CloudWatch Insights Queries.md

CloudWatch Insights Queries

Assorted queries for AWS CloudWatch Insights

01-Profile Lambda Memory.txt

# profile lambda memory usage

filter @type = "REPORT"
| fields
    @requestId,
    @timestamp,
    @billedDuration,
    @memorySize / 1024 / 1024 as provisonedMemoryMB,
    @maxMemoryUsed / 1024 / 1024 as memoryUsedMB,
    memoryUsedMB / provisonedMemoryMB * 100 as memoryUtilizationPercent,
    provisonedMemoryMB - memoryUsedMB as overProvisionedMB
| sort by memoryUtilizationPercent desc

02-Compare Lambda Cost & Duration.txt

# groups invocation cost by lambda name & provisioned memory
# makes it easy to compare costs after tweaking a lambda's provisioned memory

filter @type = "REPORT"
| fields
    substr(@log, 25) as name,
    @billedDuration,
    @memorySize / 1024 / 1024 as provisonedMemoryMB,
    @billedDuration * provisonedMemoryMB / 1000 as cost
| stats
    avg(@billedDuration) as avgDuration,
    avg(cost) as avgCost
  by
    name,
    provisonedMemoryMB
| sort by avgCost desc
#| sort by avgDuration desc
#| sort by provisonedMemoryMB, avgDuration desc