I have a Postsgresql table that is has 3 bigint columns one of which is being used as the time field. I am encountering two issues:
The first issue is related to the display of the time value:
I have a table panel, and the query is as follows:
SELECT my_timestamp as time ,column2,column3 FROM my_table
WHERE $__unixEpochNanoFilter(my_timestamp)
ORDER by my_timestamp
limit 15
I have observed the following:
The time display is incorrect. It would appear that the timestamp is being interpreted as milliseconds.
If I query as follows:
SELECT my_timestamp/1000000 as time…
the time displayed is correct.
The filtering using __unixEpochNanoFilter appears to be ok.
How can I ensure that the timestamp is interpreted as nanoseconds?
If influxdb is used as datasource, it is assumed that the timestamps are nanosecond.
It seem not to be possible to configure the type of the timestamp,
either at the datasource or at the dashboard level.
The second issue is with the display of large values of column3.
The last digit here is always 0.
If I modify the query as follows :
SELECT …column2,column3%10
the correct value is displayed.
Any suggestions on how to configure my panel to display these values correctly would be gratefully received.
I am running Postgres 11.4 and Grafana 7.0.6
Thank you in advance.