Is there a NRQL to find all DNS lookup or filesystem stat in our APM transactions?

We’d like to investigate how much time we spend on those actions in all of our services.

Hi, @Larry.Collicott: I do not think this information is captured by default for APM transactions. You may use the New Relic data dictionary to see which information is captured by default for various event types.

I was afraid of that, Phil. Neither Transaction nor TransactionTrace seem to have it unless I’m just too caffeine deficient to see it.

Hey Phil,
Here’s an example of what we see in the transaction traces, but unable to find this when looking for it using QueryBuilder/Insights:


Do you know of any way to query this data?

Sorry, I do not know of any way to query this data. Perhaps another community member will have a suggestion.

You could check in Span event type so something like

SELECT average(duration) FROM Span WHERE name = ‘dns.lookup’ FACET appName

1 Like

Perfect! I knew it had to be here somewhere!