NRQL result limits increased from 2,000 to 5,000

January 9, 2024

The maximum result limit for NRQL queries is increasing from 2,000 to 5,000

On February 5, 2024, NRQL result limits increased from 2,000 to 5,000 results. This increase lets you pull even more data with the LIMIT clause when you create NRQL queries, dashboards, and more.

  • This change also affects the LIMIT MAX clause, increasing posted results from 2,000 to 5,000.
  • If you have an existing query that uses the LIMIT MAX clause, your results now reflect the 5,000 limit, assuming the underlying data is populous enough.
  • Some existing queries that successfully posted results with LIMIT MAX may fail. Larger limits can cause timeouts, or result in failure due to complexity.
  • You can use LIMIT 2000 instead of LIMIT MAX to only display 2,000 results.

This change won't affect existing queries if they lack a LIMIT clause, use default result limits, or specify an explicit result below 2,000.

What do you need to do?

Existing queries using LIMIT MAX may return more data than before. This could potentially slow down dashboards or reports that use those queries.

To avoid unintended changes, update any queries using LIMIT MAX to specify LIMIT 2000 by February 5th. This will ensure they continue to behave as expected after the limit increase.