How to sort by url's taking maximum response time from apache logs in Kibana

Elastic Stack Kibana
1

I have taken Apache logs from my clusters and able to view in Kibana. I want to know top 10 Url's or API's which is taking maximum response time which is there in Apache log.
Log Format:

106.51.65.169 - - [23/May/2019:12:50:48 +0530] "POST /userAPI/getUser HTTP/1.1" 200 17633 "http://drreddy.dev1.openings.co/manage/" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/73.0.3683.103 Safari/537.36" 0/65987

Response time here is : 0/65987.
I want to sort based on this .Please help me in that.

2

how does one data point look like in Discover for you? That response time field should be parsed on ingest and converted to a integer that is the number of miliseconds.

3

Screenshot%20from%202019-05-24%2011-03-3
Screenshot from 2019-05-24 11-03-3.png1366×768 229 KB

This is how my Discover look like.

4

Can you expand one document there and show how the fields look there?

6

Hi Marius_Dragomir,

Thanks for the reply,
Can you please help me with steps to parse response time on ingest and convert it to an Integer.