With NRQL, you can query any of the default data being reported by New Relic, plus any custom events and attributes you’ve added.
Step 1 of 4
NRQL syntax is comparable to ANSI SQL.
SELECT function(attribute) [AS 'label'][, ...]FROM event[WHERE attribute [comparison] [AND|OR ...]][AS 'label'][, ...][FACET attribute | function(attribute)][LIMIT number][SINCE time][UNTIL time][WITH TIMEZONE timezone][COMPARE WITH time][TIMESERIES time]
Step 2 of 4
NRQL queries can be as simple as fetching rows of data in a raw tabular form to inspect individual events.
-- Fetch a list of Browser PageView eventsSELECT * FROM PageView
Step 3 of 4
NRQL queries can also do extremely powerful calculations before the data is presented to you, such as crafting funnels based on the way people actually use your website.
-- See how many users visit, signup, browse and purchase from your site as a funnelSELECT funnel(session,WHERE pageUrl='http://www.demotron.com/' AS 'Visited Homepage',WHERE pageUrl='http://www.demotron.com/signup' AS 'Signed Up',WHERE pageUrl='http://www.demotron.com/browse' AS 'Browsed Items',WHERE pageUrl='http://www.demotron.com/checkout' AS 'Made Purchase')FROM PageViewSINCE 12 hours ago
Step 4 of 4
Using NRQL, you can customize your New Relic experience by crafting diverse dashboards that show your data from multiple angles. You can share these dashboards with technical and non-technical stakeholders alike.
Learn more and start building
Connect with other developers in the our Explorers Hub.
For examples of integrations and other technologies, check us out on GitHub.