Skip to content

Instantly share code, notes, and snippets.

@berga

berga/RDS get slowest query cloudwatch

Forked from dhsathiya/RDS get slowest query cloudwatch
Created March 11, 2020 15:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save berga/2c3797a1f8e979faf6daeefb7843d434 to your computer and use it in GitHub Desktop.
Save berga/2c3797a1f8e979faf6daeefb7843d434 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
RDS get slowest query cloudwatch
fields @timestamp, @message
| parse @message '*Query_time: * Lock_time: * Rows_sent: * Rows_examined: *\n*' as host, query_time, lock_time, rows_sent, rows_examined, query
| sort query_time desc
| limit 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment