# How to sort by url's taking maximum response time from apache logs in Kibana **URL:** \ **Category:** Kibana\ **Created:** [May 23, 2019, 7:23am UTC](https://discuss.elastic.co/t/how-to-sort-by-urls-taking-maximum-response-time-from-apache-logs-in-kibana/182363 "2019-05-23T07:23:27Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![arjun\_purushotham](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arjun_purushotham/32/46688_2.png) [@arjun\_purushotham](https://discuss.elastic.co/u/arjun_purushotham)\ **Post date:** [May 23, 2019, 7:23am UTC](https://discuss.elastic.co/t/how-to-sort-by-urls-taking-maximum-response-time-from-apache-logs-in-kibana/182363/1 "2019-05-23T07:23:27Z")
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/](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. ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [May 23, 2019, 1:23pm UTC](https://discuss.elastic.co/t/how-to-sort-by-urls-taking-maximum-response-time-from-apache-logs-in-kibana/182363/2 "2019-05-23T13:23:01Z")
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. ---
**Author:** ![arjun\_purushotham](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arjun_purushotham/32/46688_2.png) [@arjun\_purushotham](https://discuss.elastic.co/u/arjun_purushotham)\ **Post date:** [May 24, 2019, 5:37am UTC](https://discuss.elastic.co/t/how-to-sort-by-urls-taking-maximum-response-time-from-apache-logs-in-kibana/182363/3 "2019-05-24T05:37:09Z")
![Screenshot%20from%202019-05-24%2011-03-3](https://us1.discourse-cdn.com/elastic/original/3X/8/5/853d3a483bab9db41d6751a90dc1ca0bdacef4aa.png) This is how my Discover look like. ---
**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\ **Post date:** [May 24, 2019, 12:52pm UTC](https://discuss.elastic.co/t/how-to-sort-by-urls-taking-maximum-response-time-from-apache-logs-in-kibana/182363/4 "2019-05-24T12:52:51Z")
Can you expand one document there and show how the fields look there? ---
**Author:** ![arjun\_purushotham](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/arjun_purushotham/32/46688_2.png) [@arjun\_purushotham](https://discuss.elastic.co/u/arjun_purushotham)\ **Post date:** [May 27, 2019, 7:14am UTC](https://discuss.elastic.co/t/how-to-sort-by-urls-taking-maximum-response-time-from-apache-logs-in-kibana/182363/6 "2019-05-27T07:14:39Z")
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. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 24, 2019, 7:14am UTC](https://discuss.elastic.co/t/how-to-sort-by-urls-taking-maximum-response-time-from-apache-logs-in-kibana/182363/7 "2019-06-24T07:14:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.