Skip to content

Instantly share code, notes, and snippets.

@dhsathiya
Created June 26, 2019 07:43
Show Gist options
  • Save dhsathiya/fa34f7381695b0aa2efe031b10ca6fa5 to your computer and use it in GitHub Desktop.
Save dhsathiya/fa34f7381695b0aa2efe031b10ca6fa5 to your computer and use it in GitHub Desktop.
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