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 10 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
10 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
-
10 Months Ago
Hi Brad, LogViewPlus SQL currently does not support WITH or LAG...
LogViewPlus Support
-
10 Months Ago
Thanks for the response. Fun fact, I recently discovered the power of...
BradJJ
-
10 Months Ago
Awesome Brad - glad to hear you were able to find a solution. Thanks...
LogViewPlus Support
-
10 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