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

Insight avg cpu by facet not showing all hosts


#1

When doing an Insight avg cpu query by facet, some of the hosts are not showing up.
SELECT average(cpuPercent) as cpu_pct from SystemSample facet hostname since 1 week ago
If i filter by one of the missing hosts, the record shows
SELECT average(cpuPercent) as cpu_pct from SystemSample facet hostname since 1 week ago where hostname = 'foo'
Would be nice if all the host data retrieved


#2

Hi @andrew.t.simpson - You could be running into the Insights query defaults, try adding a LIMIT clause to expand the number of rows returned.


#3

Thanks! That appears to be the issue.
LIMIT to see more rows, yikes.
Over a 1000 and no go without convoluted filtering.