Geek Answers Handbook

Finding NaN Values ​​for Average Statistical Function in Graylog2

I have a simple query log, where each record has a runtime in seconds, in exec_time . It should always be a number (lower is better). Based on this property, I have a toolbar widget that shows its average value, and it worked very well until recently. Now it shows NaN .

I assume that there is one or more entries with exec_time that are not numeric. How to find these entries?

+5
source share
1 answer

Take your query logs and iterate over them with a simple script to check each value individually. Print out those that are wrong. Without any other information, I assume that you have an incorrectly labeled field with no number supplied in "exec_time", an empty (zero, nothing) value, a record that is too large, too small, or corrupted somewhere.

+2
source

More articles:


All Articles