Hi there ,
I have Grafana and PosgreSQL working together in a Docker network.
I use Grafana to plot Bitcoin 15 minute data taken from an SQL table.
The time series are not perfectly extracted once in 15 minutes because I extract them with Python from a web page and the web page response varies a bit . I write them in SQL after extraction. But i don’t think that should pose an issue for Grafana. The data format in PgSQL is Timestamp.
My query in Grafana looks like this :
SELECT
“Datetime” AS “time”,
“Price”
FROM top500_crypto_minute_level
WHERE
$__timeFilter(“Datetime”) AND
“Coin_Acronim” = ‘BTC’
ORDER BY 1 ‘’’
The table values returned by Grafana show bigger values for the extracted time series compared to the values in PgSQL for the same timeseries.
I don’t understand why this is happening. Basically Grafana pumps up my numbers.