LogViewPlus Support » LogViewPlus Support » Help & Support » Line report of elapsed over time

Line report of elapsed over time

BradJJ — Fri, 08 Nov 2024 20:31:49 GMT

I have a log where I have filtered out pairs of log lines.
Firstly the log line where an API request is sent and secondly the log line where the API response is received.
I want to see a timeline bar graph that shows the API responsiveness over a period so I can compare today versus 3 days ago (or another reference) to monitor for performance issues.

I just can't find examples that do this.
Can you please help?

Sample log line pair is below
I have a parser so I have columns for date and time as well as turning on the elapsed column, I just need the query to report on the elapsed values

2024-11-07 06:43:03.956 I/app(722): [activity] [api ] - } to https://url.com/endpoint.svc/endpoint
2024-11-07 06:43:04.345 I/app(722): [activity] [api ] - } from https://url.com/endpoint.svc/endpoint

RE: Line report of elapsed over time

LogViewPlus Support — Fri, 08 Nov 2024 20:31:49 GMT

Awesome Brad - glad to hear you were able to find a solution. Thanks for letting me know!

Toby

RE: Line report of elapsed over time

BradJJ — Fri, 08 Nov 2024 04:00:40 GMT

Thanks for the response.
Fun fact, I recently discovered the power of AI.
I copied the filtered log lines out of LVP and pasted them into Microsoft CoPilot and asked it to generate a report for me.
It give me python and it worked like a charm. I even got it to tweak the report format.
I was amazed.

RE: Line report of elapsed over time

LogViewPlus Support — Thu, 07 Nov 2024 09:52:36 GMT

Hi Brad,

LogViewPlus SQL currently does not support WITH or LAG statements. I don't think this scenario will be possible without at least one of these constructs.

It's a good use case and I think it is something that LogViewPlus should be able to do. I will have a think and see if we can come up with a solution in a future release.

In the meantime, the best I can suggest is to export the rows to a CSV file and then using Excel to perform the necessary calculations.

Thanks,

Toby