07 Nov 2022 04:56 PM - last edited on 14 Nov 2022 12:34 AM by MaciejNeumann
Hello, I'm trying to hit an API that will return the response time of my top X database statements by response time. Im using the accept:text/csv header, and would like to see the response time and request count returned in separate columns for each X database statement for a given a period of time.
Solved! Go to Solution.
Hi, you can combine boths calls in a single API call but it won't output a single array with two dimensions. You have to process them afterwards.
Thank you for your reply, this is very helpful. How do I add the database statements do the call so I can map them to the values?
Database statements metrics are not available out of the box for each statement. It's the same as for webservice request/operation at webservice level.
Statements must be marked as key requests before (see below)
Then the related metrics that you can use are
builtin:service.keyRequest.count.total for request count
builtin:service.keyRequest.response.time for response time
you can filter by key request identifier which is "SERVICE_METHOD-XXXXXXX" you can find in the url of the screenshot above.