First of all, I am new to grafana. Its very impressive and unbelievable feature rich.
So far I was using seq just for viewing logs. Now we got the requirement to
- Have a time chart about response time in parts of our application
- Setup alerts when response time gets bad
- What Grafana version and what operating system are you using?
grafana/promtail:2.6.1
grafana/loki:2.6.1
Google Cloud console
awaragi/prometheus-mssql-exporter
grafana/grafana
prom/node-exporter
prom/prometheus
- What are you trying to achieve?
I am running an asp.net webapplication using serilog for logging. Through filtering in serilog I send following log entries to loki
2022-07-27 11:22:24
{
"Message": "Req: \"DzaSettingsDetailQuery\", Resp: \"DzaSettingsDetailRsp\", Duration: 00:00:00.0192448",
"MessageTemplate": "Req: {Name}, Resp: {RespName}, Duration: {@Elapsed}",
"Name": "DzaSettingsDetailQuery",
"RespName": "DzaSettingsDetailRsp",
"Elapsed": "00:00:00.0192448",
"EventId": {
"Id": 35,
"Name": "RequestDuration"
},
"SourceContext": "avsweb.Application.Module.SettingsModul.Queries.DzaSettingsDetail.DzaSettingsDetailQuery",
"TransportConnectionId": "pnnnoNCud9UNj9BmxqhFqA",
"RequestId": "0HMJFLH39CL76:00000002",
"RequestPath": "/_blazor",
"ConnectionId": "0HMJFLH39CL76",
"Application": "avsweb",
"level": "info"
Now I want create a grafana dash board showing the field ‘Elapsed’ over time for each value in ‘Name’. As I am new to grafana I got lost somewhere or missed the point. Would be great if someone could point mit in the right direction.
- How are you trying to achieve it?
Created a new dashboard an started play around. I could mange view the log entries in Explorer, but was not able to create a chart.
I am playing with this query:
avg by(Elapsed) (rate({app=“avsweb_app”} [$__interval]))
- What happened?
All I get are a few vertical lines like this.
-
What did you expect to happen?
Get a chart like this like in grafana doc, -
Can you copy/paste the configuration(s) that you are having problems with?
-
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
-
Did you follow any online instructions? If so, what is the URL?