Features
Support
Purchase
Documentation
Download
Login
Register
Login
Register
Home
»
LogViewPlus Support
»
Help & Support
»
Line report of elapsed over time
Line report of elapsed over time
Post Reply
Like
1
Line report of elapsed over time
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
BradJJ
BradJJ
posted 8 Months Ago
ANSWER
Topic Details
Share Topic
Group: Forum Members
Posts: 8,
Visits: 25
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
Edited
8 Months Ago by
BradJJ
Reply
Like
1
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Line report of elapsed over time
BradJJ
-
8 Months Ago
Hi Brad, LogViewPlus SQL currently does not support WITH or LAG...
LogViewPlus Support
-
8 Months Ago
Thanks for the response. Fun fact, I recently discovered the power of...
BradJJ
-
8 Months Ago
Awesome Brad - glad to hear you were able to find a solution. Thanks...
LogViewPlus Support
-
8 Months Ago
Post Reply
Like
1
Similar Topics
Post Quoted Reply
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search