• Sign up

Query data with NRQL

10 min

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.

Learn more about NRQL syntax

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.

Learn what events open source agents provide out of the box

-- Fetch a list of Browser PageView events
SELECT * 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.

Learn more about NRQL funnels

-- See how many users visit, signup, browse and purchase from your site as a funnel
SELECT 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 PageView
SINCE 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.

Dashboard created with NRQL



Learn more and start building

Documentation

For an overview of NRQL syntax, see Introduction to NRQL. For a detailed description of all available functions, see NRQL syntax, components, and functions.

Community forum

Connect with other developers in the our Explorers Hub.

GitHub

For examples of integrations and other technologies, check us out on GitHub.