I've an application log that has this format
timestamp, url, responsetime
Using AWS CloudWatch Logs Insights, how could i calculate and graphview (Line graph on Visualisation TAb) the average response time by url, to find out what url is causing response time increase during the day on what moment?
I know how to parse and use the stat avg, but i could not find a way on group by url and avg over time.
edit01
An important restriction, i don't know the url's before processing and they could change, so a bonus to a solution where the url's are dynamically asigned.
Thanks,