AWS CloudWatch Insight Queries

lambda-duration

filter @type = "REPORT"
| stats
    avg(@billedDuration) as Average,
    percentile(@billedDuration, 99) as NinetyNinth,
    percentile(@billedDuration, 95) as NinetyFifth,
    percentile(@billedDuration, 90) as Ninetieth
    by bin(30m)

lambda-general-performance

filter @type = "REPORT"
| stats
    max(@maxMemoryUsed / 1024 / 1024) as maxMemoryMB,
    avg(@maxMemoryUsed / 1024 / 1024) as avgMemoryMB,
    min(@maxMemoryUsed / 1024 / 1024) as minMemoryMB,
    (avg(@maxMemoryUsed / 1024 / 1024) / max(@memorySize / 1024 / 1024)) * 100 as avgMemoryUsedPERC,
    avg(@billedDuration) as avgDurationMS
    by bin(30m)

lambda-max-memory-usage-count

filter @type = "REPORT" and @maxMemoryUsed=@memorySize
| stats
    count_distinct(@requestId)
    by bin(30m)

lambda-process-exit

filter @message like /Process exited/
| stats count() by bin(30m)

lambda-timeout-count

filter @message like /Task timed out/
| stats count() by bin(30m)