Postgres problem with printing data

Grafana PostgreSQL
1

Hello.

Im having problems when using some data from my postgres database.

image

image
image1823×682 32.1 KB

Im unable to print that column in grafana even if i cast conver to varchar de data, i only see “No points available”. Any suggestions?

Thanks in advance

2

in query editor you can view genereated SQL can you look at that and test that manually ?

3

If i test it manually it works flawlessly, also, im getting this error:

image
image1467×481 32.5 KB

If i execute the query manually at postgres i get no problem:

image
image792×426 16.2 KB

Also, i cast converted the “VALUE”::VARCHAR(5) which removes the error, but shows me no data.

4

You need to select 3 columns for Grafana: time, metric (=metric name), value (=metric value).
At the moment you are selecting only 2 + metric name is a metric value in your case.

http://docs.grafana.org/features/datasources/postgres/

5

I ended up working it around like this:

SELECT
$__time(“DATETIME”),

“VALUE” as in
FROM “STORAGE”
WHERE(
$__timeFilter(“DATETIME”)
AND “RELATIVE_ID” = 47) AND “VALUE” != ‘NaN’
ORDER BY 1

Turns out, there were a few NaN values inside the database…

Thanks everyone for your support!