Your data. Anywhere you go.

New Relic for iOS or Android


Download on the App Store    Android App on Google play


New Relic Insights App for iOS


Download on the App Store


Learn more

Close icon

APM Database Query

apm

#1

Hi Explorer’s

Can you please let me know what is the 136 s specify here in the below screen print ?
Coz when I oculd see the min and max time took to execute the query.

Thanks


#2

136 seconds is the average time taken by that query per minute during the specified time window: 0.75 ms per call x 181,000 calls per minute = approx. 136 seconds.


#3

Hi @philweber thanks for clarification. I am able to see Min and Max time in the screen print I have pasted earlier.

Regards
Moses


#4

Ah, yes, I see them in the popup window, sorry for the misinformation.


#5

not a problem at all @philweber I wanted to check how many time a database query was calling during a particular transaction.

I am able to see in Transaction Trace. But need to see it as a report. Am not able to see in Database Report in APM.

Regards


#6

Hi Moses,

I could be a little late to the party, you can get a CSV exportable table, by appending your RPM link as such

https://rpm.newrelic.com/accounts/YourAccountID/applications/YourApplicationID/transactions/table#sort=8%2C1

You can do the same for databases

https://rpm.newrelic.com/accounts/YourAccountID/applications/YourApplicationID/datastores#/overview/MSSQL?value=total_call_time_per_minute

I hope this helps


#7

Thanks @Nemo I wanted to know the database details (like call count / min and maxn / avg txn calls with respect to the transaction.

Like this transaction took these many DB call ? to be specific.


#8

Do you have a permalink that I can investigate?


#9

Thanks @Nemo I have messaged you the permalink. Please check.


#10

Super got it there, checking now !