Number of records per hour

Grafana Time Series Panel
1

What Grafana version are you using?
6.1.4
What datasource are you using?
postgresql 9.6

What OS are you running grafana on?
ubuntu 18

I am trying a graph using a postgre database. I have many records with its timestamp and I would like to make a bar graph with a count with the number of records grouped by hours.
I have got a nice graph but it does not give the expected results. I have something like this:

SELECT
__timeGroupAlias(timestamp,__interval),
count(id) AS “nids”
FROM table
WHERE
$__timeFilter(timestamp) AND
column= ‘Column’
GROUP BY 1
ORDER BY 1

format as Time series

2

Hi,

Your query looks good, what do you have? And what do you expect?

To achieve what you want, you also need to set the Min time interval option (just under the query) to 1h and set the Draw Modes to Bars (in the Visualization tab)

3

Thanks for answering Agnestoulet1, I am going to show the result and the records that I have in my database:

image
image1154×144 8.2 KB

and these are my consulted records
image

I do not understand well why the bars do not occupy the entire space of an hour but the strangest thing is that the results are not good, it should start showing bars at 08:00 → 09:00 but I don’t see anything and the rest do not agree with the data. I have made sure and it is these records that I consult

4

this work for me

SELECT
$__timeGroupAlias("timestamp",1h),
count(id) AS “nids”
FROM table
WHERE
$__timeFilter(timestamp) AND
column= ‘Assistance Diag 24 France’
GROUP BY 1
ORDER BY 1
1 Like
5

109/5000

it’s true the query works! I just saw that the timezone is wrong, but in my other charts it’s ok

1 Like
6

Thank you very much. This worked for me