Some useful AWS Log Insights queries

queries.md

-- Display Lambda Errors Frequency

fields @timestamp, @message
| PARSE @message "[*] *" as loggingType, loggingMessage
| FILTER loggingType = "ERROR"
| sort @timestamp desc
| limit 20

-- Count SQS Messages in Lambda every 5s

filter @message like /Records/
| stats sum(Records.0.attributes.ApproximateReceiveCount) by bin(5s)
| sort @timestamp desc