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

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: - - [23/May/2019:12:50:48 +0530] "POST /userAPI/getUser HTTP/1.1" 200 17633 "" "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.

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.

This is how my Discover look like.

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

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.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.