1

I have some log messages in my Loki:

2023-02-13 12:20:08.675  INFO 30937 --- [lettuce-epollEventLoop-5-1] c.g.poc.Filter.AuthenticationFilter      : [ requestId : 904c1292-66, AuthFilterTime : 15 ms ]
2023-02-13 12:16:32.100  INFO 30937 --- [lettuce-epollEventLoop-5-1] c.g.poc.Filter.AuthenticationFilter      : [ requestId : f84a572f-65, AuthFilterTime : 4 ms ]
2023-02-13 12:16:31.427  INFO 30937 --- [lettuce-epollEventLoop-5-1] c.g.poc.Filter.AuthenticationFilter      : [ requestId : 904c1292-64, AuthFilterTime : 10 ms ]

I want to get the average value of AuthFilterTime.

I'm getting the error:

"parse error at line 5, col 6: syntax error: unexpected NUMBER"

when i run the query,

sum by (filename)(
  avg_over_time(
    {filename="/path/to/the/log/file"} |= "AuthFilterTime.*ms" |
    regexp `AuthFilterTime\s*:\s*(\d+) ms` |
    $1
  )[24h]
)

Can somebody help what is it that i've been doing wrong??

I'm actually new to grafana.

Jan Garaj
  • 25,598
  • 3
  • 38
  • 59

0 Answers0