When using PostgreSQL as a datasource, I’m only able to use “half” of the graph space. The graph times (x-axis) extend 6 hours into the future. This is also my offset from UTC. I’ve attempted to change the timezone at the PostgreSQL server level (i.e., for clients via postgresql.conf) and to set the timezone for the Grafana user accessing the DB (via
alter user foo set timezone 'Etc/UTC' – and to other TZ’s). None of these have been effective.
Allegedly, PostgreSQL stores “timestamp” fields (auto-populates with current_timestamp upon insert) in UTC. Between Google and tinkering, I think that I’ve suffered enough to ask for help. I hope that someone else encountered this problem (er, and resolved it). Ah, I should mention that the dashboard is set to UTC (ah, which explains the “half-graph” bit). The underlying problem, then, is that I simply cannot seem to extract the correct timestamp data from the database.
I’m using PostgreSQL 9.2.18 and grafana-4.3.1-1.x86_64 on RHEL7.3.