Home / Companies / New Relic / Blog / Post Details
Content Deep Dive

Enhanced string parsing for better, more efficient NRQL queries

Blog post from New Relic

Post Details
Company
Date Published
Author
Ashton Hunger, Senior Software Engineer
Word Count
1,675
Language
English
Hacker News Points
-
Summary

Parsing and understanding logs in New Relic has historically been challenging due to the complexity of semi-structured text fields, but recent advancements in NRQL, including variables, regex multi-capture, and anchor parse, have significantly streamlined this process. These new features enhance query efficiency and readability by simplifying the extraction and manipulation of data from logs, such as calculating the 99th percentile of response times with mixed units. NRQL variables allow for assigning computed values, regex multi-capture reduces the need for multiple regexes by capturing several values at once, and the If function introduces conditional logic directly into queries. The AnchorParse function further optimizes performance by providing a simplified syntax for capturing values. Collectively, these improvements reduce computational costs and increase the speed of data querying, offering a more effective way to gain insights into application performance.