Grafana multi-line chart from Postgres

Question

I want to display a multi-line chart where each line it's the value of a column. For example, "status" has several values: 200, 404, 500 etc.. and I want to see a line for each. On X-axis I have to see how many records had the status=200 and so on..

I've tried with this

SELECT
  created_at AS "time",
  status,
  count(*) 
FROM api_logs
group BY time, status

but it's showing

instead I would something like

UPDATED: I tried with this query

SELECT
  $__timeGroupAlias(created_at, '5m'),
  status AS "metric",
  count(*) AS "count"
FROM api_logs
WHERE $__timeFilter(created_at)
GROUP BY 1,2

ORDER BY 1

but I got this chart

and this is the table output

I would see a line for each status. Where Y is the count of event for that status. Basically If I see a spike for a line (errors 500) I have to worry.

Jan Garaj · Accepted Answer · 2021-11-22 10:12:20Z

3

SQL query with 5min time aggregation with PostgreSQL macros for Grafana 8.2:

SELECT
  $__timeGroupAlias(created_at, '5m'),
  status AS "metric",
  count(*) AS "count"
FROM api_logs
WHERE $__timeFilter(created_at)
GROUP BY 1,2
ORDER BY 1

created_at column is timestamptz type.

answered Nov 22, 2021 at 10:12

Jan Garaj

29k3 gold badges49 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

sparkle Over a year ago

I've tried but still not getting the desired output. I've updated the question with details.

Jan Garaj Over a year ago

@sparkle cast status as text in that query, becaue you have it as numeric type now, e.g. status::text AS "metric",. You should to also mention used Grafana version and panel type first in your question.

warreee Over a year ago

I'm still experiencing the same issue as well, using Grafana 10 though.

warreee · Accepted Answer · 2024-03-02 08:27:13Z

2

The above answer did not solve it for me. I'm using Grafana 10 and what solved is was using the multi-frame time series transformation:

Source

answered Mar 2, 2024 at 8:27

warreee

5575 silver badges15 bronze badges

Collectives™ on Stack Overflow

Grafana multi-line chart from Postgres

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related