#CloudWatch

2025-12-06

Last but certainly not least, my roundup of all the #AWS #CloudOps news from #reinvent, including the new #multicloud Interconnect, #EKS Capabilities, #observability and #logmanagement updates for #cloudwatch, and more. techtarget.com/searchcloudcomp

2025-11-18

Filtering JSON Log Data in CloudWatch using the jsonParse Function

Today’s post is one of those “I’m writing this so I can copy & paste it later” ones. (And yes, that cover image is a log joke and was selected to intentionally scar anyone my generation)

I’ve spent a lot of time in AWS CloudWatch today monitoring a database query log while I do some performance testing. I was looking at a long list of log entries that included a query duration as part of a JSON response in the log’s @message content.

The jsonParse function in CloudWatch allows you to query data in the JSON content. In this case, I want to sort all the queries by a duration_ms attribute greater than 0. I also want to display the duration_ms as a field in the query’s output.

Use this query:

fields @timestamp, @message, @logStream, @log, jsonParse(@message) as js| display js.duration_ms, @timestamp, @message, @logStream, @log| filter js.duration_ms > 0| sort js.duration_ms desc| limit 1000

and you get:

This allowed me to quickly find the slow running queries from JSON data in the log.

#aws #cloudwatch

:rss: Qiita - 人気の記事qiita@rss-mstdn.studiofreesia.com
2025-11-03
:rss: Qiita - 人気の記事qiita@rss-mstdn.studiofreesia.com
2025-10-19

CloudWatchログをS3に転送、Athenaでクエリしたかっただけなのに、ちょっと複雑だった話
qiita.com/yutaka_kozuka/items/

#qiita #AWS #S3 #CloudWatch #Kinesis #Firehose

:rss: Qiita - 人気の記事qiita@rss-mstdn.studiofreesia.com
2025-07-13

AWSアカウントにログインできないユーザーともCloudWatchダッシュボードを共有できる
qiita.com/infra365/items/902d9

#qiita #AWS #初心者 #CloudWatch

:rss: Qiita - 人気の記事qiita@rss-mstdn.studiofreesia.com
2025-07-09

Client Info

Server: https://mastodon.social
Version: 2025.07
Repository: https://github.com/cyevgeniy/lmst