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

How to query for a Transaction Segment through NRQL in Insights

apm
transactions
configuration

#1

###Insights Question Template

  • There are many ways to achieve a goal in Insights, tell us a bit about your end goal. What insights are you hoping to gain?

I want to find the average duration for a Transaction Segment that occurs across transactions. Here is a sample from the APM Transaction page

SELECT average(duration) FROM Transaction WHERE appName = ‘SSM Core US South’ AND name = ‘WebTransaction/RequestAttribute/CustomerServiceImpl.getCustomerList.getAssociatedCustomersByUserId’ AND segment = ‘com.ibm.wdp.bsscfw.webapp.action.SecurityFilter.doFilter()’ SINCE thursday UNTIL wednesday

Helpful Resources:


#2

Hi, @rajanr: By default, New Relic APM does not record individual segment durations in NRDB, so they may not be queried with NRQL.