Postgresql Annotation Metadata

masterbond · February 7, 2018, 10:23am

Hi,

this is my first post on Grafana Community plattform.
I have a question regarding the annotation feature for a postgresql datasource.
The table has 4 colums: ID (bigserial, pk), ASSIGNMENT (text), START (timestamp), END (timestamp)
How can I display the assignment data as annotation on a graph (START to END) ?

Thanks for your help!

torkel · February 7, 2018, 3:18pm

postgres annotations do not support range annotations, only single point events

masterbond · February 8, 2018, 7:23am

That’s bad news. Could you develop this as a feature for the next release?

svenklemm · February 8, 2018, 6:39pm

@torkel Is there any datasource that supports range annotations? Was trying to check but couldnt find anything.

masterbond · February 9, 2018, 10:25am

Region annotations are possible through manual cmd holddown and dragging.
I don’t know if it is possible through any datasource.
Please develop this feature!

torkel · February 13, 2018, 9:38am

Not possible with other data sourcs right now.

holgerbrandl · October 29, 2019, 8:34pm

Hi there,

is there a github ticket that tracks this issue (range annotations for datasources such as postgres)? Or some third-party tool that works around this limitation?

Thanks.