Enhanced string parsing for better, more efficient NRQL queries
Blog post from New Relic
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.