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

Map db query to a transaction

apm
queries

#1

Hello there,

I can see this query provided the list of slow DB Queries.

SELECT average(duration)*1000 AS ‘DB Queries in ms’ from Span facet db.statement since 1 day ago

is it possible to map the respective DB query to a transaction ?

Thanks


#2

Hey @moses.raja, Span events have the transactionId attribute, which associates that Span to the specific GUID of that Transaction. Is that similar to what you are looking for?

More general Transaction identification like a Transaction’s name attribute is not currently available in the Span event.

Let me know if I’m missing the mark here. I would be interested in understanding the use-case of the query above to make sure there isn’t another way to find this information.