Mayank Pratap Singh
Reputation: 183
Filter Request Rows based on response time in nginx access log
172.31.0.19 - 106.208.175.228 - - [05/Jul/2020:17:40:44 +0000] "POST /api/v2/devices/ HTTP/1.1" 201 399 "-" "okhttp/3.12.1"rt=25.299 uct="0.000" uht="25.300" urt="25.300"
This is the sample log from the access log. How I can print or separate the data based on rt 'request time' is higher than 5 seconds?
Upvotes: 0
Views: 586
Answers (1)
Davidgs
Reputation: 419
Putting this data into a Time Series Database would be a first step I guess. You can try parsing the log files using the telegraf log parser and feeding the data into Questdb.io Then you can execute SQL queries against it based on time parameters, etc.
Upvotes: 1
Related Questions
- Nginx understanding access log column
- Writing the total request time in seconds to an nginx access log, possibly using a calculated variable
- How to limit the number of user 's requests made within a minute in nginx?
- Strip single GET query parameter from Nginx access log and keep all the others
- Get Requests count per IP per request in Nginx access.log
- Nginx access_log default flush time
- Monitoring website visit length with Nginx logs
- Is there any way to know the time of the request reaching Nginx?
- Logging Request/Response size in access_log of Nginx
- Logging Requests With Timing