While I was experimenting with TimescaleDB/PosgreSQL during AEROGEAR-2003, I needed to first see how data looks like on TimescaleDB and I used Grafana for that.

The data I used is NYC taxi data in TimeScaleDB tutorial: http://docs.timescale.com/v0.8/tutorials/tutorial-hello-nyc
Simply import that data as instructed there.

I created a sample dashboard that has a bunch of graphs that use TimescaleDB features. Export of the dashboard is attached.

Here is the screenshot of that dashboard.

Based on my experiments, I can clearly say that Grafana is able to integrate with TimescaleDB/PostgreSQL very nicely.

What's good:

• Support out of the box
• Straightforward integration

What's bad:

• One must write SQL queries (this is unlike ElasticSearch or Prometheus integration. however, this is not Grafana's problem. This is the nature of PostgreSQL)

What needs more investigation:

• Getting non-time series data (possibly show a pie chart)