Apache Access Logs - Response Time

I have to setup a Dashboard for apache webpage's response time.

I have configured in apache2.conf CustomLog as

LogFormat "%h %l %u %t "%r" %>s %b "%{Referer}i" "%{User-agent}i" %T/%D" combined

Below is the output from the access_log

192.168.1.38 - - [19/Dec/2019:12:31:28 +0530] "GET / HTTP/1.1" 200 3138 "-" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36" 1/1404137

I would like to Gork ...

%{IPORHOST:clientip} %{USER:ident} %{USER:auth} [%{HTTPDATE:timestamp}] "(?:%{WORD:verb} %{NOTSPACE:request}(?: HTTP/%{NUMBER:httpversion})?|%{DATA:rawrequest})" %{NUMBER:method} (?:%{NUMBER:bytes}|-) "%{GREEDYDATA:url_path}" "%{GREEDYDATA:user_agent}" (%{INT:response_s:int} %{INT:response_ms:int}**)*

I tested debugger website also - http://grokdebug.herokuapp.com/

I am unable to retrieve Response time, could you please guide me.

You can also try the Grok Debugger inside Kibana (It's in the Dev Tools section). It should show you what data it will get you.

Thanks Marius for the input. I tried with Grok Debugger inside Kibana. I got the below result...

{
"request": "/",
"method": "200",
"auth": "-",
"ident": "-",
"verb": "GET",
"bytes": "3138",
"clientip": "192.168.1.38",
"httpversion": "1.1",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.79 Safari/537.36",
"timestamp": "19/Dec/2019:12:31:28 +0530",
"url_path": "-"
}

I am still not able to retrieve the response time.

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