Multiple series with one query in Grafana using PostgresQL as datasource

Question

I have data in a Postgres table with roughly this form:

CREATE TABLE jobs
(
    id              BIGINT PRIMARY KEY,
    started_at      TIMESTAMPTZ,
    duration        NUMERIC,
    project_id      BIGINT
)

I also came up with a query that is kinda what I want:

SELECT
  $__timeGroupAlias(started_at,$__interval),
  avg(duration) AS "durations"
FROM jobs
WHERE
  project_id = 720
GROUP BY 1
ORDER BY 1

This query filters for one exact project_id. What I actually want is one line in the chart for each project that has an entry in the table, not for just one.

I fail to find a way to do that. I tried all different flavors of group by clauses I could think of, and also tried the examples I found online but none of them worked.

Jan Garaj · Accepted Answer · 2021-12-10 23:49:08Z

1

Try this Grafana PostgreSQL query:

SELECT
  $__timeGroupAlias(started_at, $__interval),
  project_id::text AS "metric",
  AVG(duration) AS "durations"
FROM jobs
WHERE $__timeFilter(started_at)
GROUP BY 1,2
ORDER BY 1

answered Dec 10, 2021 at 23:49

Jan Garaj

29k3 gold badges49 silver badges73 bronze badges

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

1 Comment

seb2704 Dec 13, 2024 at 12:55

I'm trying to do the same but this doesn't work for me i still only get one legend to chose of

Collectives™ on Stack Overflow

Multiple series with one query in Grafana using PostgresQL as datasource

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related