Logql query inspect

Grafana Loki
1

we have logs something like below,

{ sid=0000 cid=a1b2c3-65ab-0000 pid=1525-abcs-1454 tsn=null ip=123.12.123.456 } operation: <some_operation>, executionTime: 3

{ sid=0000 cid=a1b2c3-65ab-0011e ip=172.22.228.7 } operation: <some_operation>, executionTime: 8

{ sid=0000 cid=a1b2c3-65ab-7795-b7f5 pid=1525-abcs-1454 tsn=null ip=123.12.123.456 } operation: <some_operation>, executionTime: 3

{ sid=0000 cid=a1b2c3-65ab-2036-9c44 pid=1525-abcs-1454 tsn=null ip=123.12.123.456 } operation: <some_operation>, executionTime: 223

{ sid=0000 cid=a1b2c3-65ab-5436-9eff6 pid=1525-abcs-1454 tsn=1 ip=1123.12.123.456 } operation: <some_operation>, executionTime: 3

I’m trying to build Grafana dashboard with Guage panel, to have average execution time, over a period,

I tried with,

avg_over_time(

{application=“abc”, service_name=“xyz”} |= “executionTime”

| regexp “executionTime: (?P<execution_time>[0-9]+)”

| unwrap execution_time [$__auto]

)

Would this work (or) do we need to logfmt this?

Please let me know if logql needs correction,

thanks in advance, :slight_smile:

2

Query looks good, did you run into errors?