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

Feature Idea: How to increase the limit value in the nrql query


#1

Hi Folks,
how to increase the limit value 1000 to max value in the query.
FROM NrDailyUsage
SELECT min(timestamp)
AS ‘Earliest reporting day’,max(timestamp)
AS ‘Latest reporting day’
FACET apmAppName,hostId,agentHostname,consumingAccountName,consumingAccountId
WHERE usageType=‘Application’
AND productLine=‘APM’
SINCE 1 month ago
LIMIT 1000

Thanks
Siva


#2

Hey @tharun4ru -

It’s not possible to increase the limit beyond 1000 right now. A potential way around that right now is to query a shorter timeframe, maybe 2 weeks instead of a month to bring the number of rows below 1000, then collate that data with another query returning the previous 2 weeks.

I have moved your post over to the feature ideas space - where I have added your +1 internally for this feature update. You can also vote on this feature over here: