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



###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 = ‘’ SINCE thursday UNTIL wednesday

Helpful Resources:


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