Introduction to NRQL: the language of data

The New Relic Query Language (NRQL) is a powerful tool you can use to query and understand nearly any type of data, but it can seem overwhelming at first glance. Don't worry! Here is some information to give you a good foundational understanding of NRQL, including what it is, how to use it, and some tips and tricks that will help you get the most out of your queries. Once you've learned about NRQL, you can capture and interpret your data, letting you break down the big picture into easily understandable pieces and helping you identify problems as they occur.

Here's a quick video to help introduce you to using NRQL by showing you how to find a query from a dashboard and modify it in the query builder. For more detailed information on querying, including a listing of clauses, functions, and example queries, see our NRQL reference.

If you haven't already, create your free New Relic account below to start monitoring your data today!

What is NRQL?

NRQL is an acronym of New Relic query language. It's a query language similar to ANSI SQL (see the syntax), and is used to retrieve detailed New Relic data and get insight into your applications, hosts, and business-important activity. NRQL can help you:

• Create a new chart
• Answer a specific question for the purpose of troubleshooting or business analysis
• Set up NRQL-based alerts (our primary and most powerful type of alert)
• Make API queries of New Relic data (for example, using our NerdGraph API)

You can use NRQL to create simple queries, such as fetching rows of data in a raw tabular form to give insight on individual events. You can also use NRQL to run powerful calculations on the data before it's presented to you, such as crafting funnels based on how end users are using your site or application.

We use NRQL behind the scenes to generate many of the charts and dashboards in our curated UI experiences:

Where can you use NRQL?

NRQL is used in many places to access your data. Those places include:

The query builder

You can run a NRQL query in the query builder in the platform UI. This NRQL query shows a count of distributed tracing spans faceted by their entity names.

The NRQL console

You can run a NRQL query from anywhere within New Relic by enabling the NRQL console from your user menu. This allows you to quickly query your data without losing your place within the platform.

NRQL-based alerts

You can use NRQL to build NRQL-based alerts, our primary and most powerful alert type. This will help to notify you of issues and help you address them in a timely fashion.

NerdGraph API

You can also use NRQL with our NerdGraph API. This gives you more powerful features than querying in the UI (for example, cross-account querying, and asynchronous queries).

What data can you query with NRQL?

NRQL lets you query nearly every type of our telemetry data, including:

• Event data from all New Relic products. Examples include:
  • APM events, like Transaction
  • Browser monitoring events, like PageView
  • Mobile monitoring events, like Mobile
  • Infrastructure events, like ProcessSample
  • Synthetic events, like SyntheticCheck
  • Custom events, like those reported by the Event API
• Metric timeslice data (metrics reported by APM)
• The Metric data type (metrics reported by the Metric API and data sources that use that API)
• The Span data type (distributed tracing data)
• The Log data type (data from our log management capabilities)

Ready to learn more? We have information on how to use NRQL and how to use charts and dashboards with NRQL. If you want to start using NRQL instead, jump straight into our guided NRQL tutorial.