Hi, could anyone give me an idea how to extract the response time of my routes from the “REQUEST” column with reference to the “Request Time” column?
That is, I would like the response time, for example, in the ‘REQUEST’ column I have a route, with the path
/commerce/store02/ would like to get the Request Time for this route as well as others.
For example the following routes, in the column of (REQUEST), and I would like to create a query that I could return the response time of each route below.
SELECT average(request_time) FROM Log WHERE request = 'GET /commerce/store02' TIMESERIES
tried doing it that way, but it returns "no value"
SELECT rate(sum(request_time), 1 minute) from Log where request = 'commerce/store02'/' since 60 minutes ago
I did it that way too, and nothing returns me.