Grafana
Grafana is widely used to visualize data via an extensive ecosystem of widgets and plugins. QuestDB connects to Grafana using its Postgres endpoint.
#
PrerequisitesInstall Grafana for your platform. You will need QuestDB to be running and accessible, you can do so from Docker, the binaries or Homebrew for macOS users.
#
Add a data source- Open Grafana's UI (by default available at
http://localhost:3000
) - Go to the
Configuration
section and click onData sources
- Click
Add data source
- Choose the
PostgreSQL
plugin and configure it with the following settings:
- When adding a panel, use the “text edit mode” by clicking on the pencil icon and add your query
#
MacrosTo simplify syntax and to allow for dynamic parts, like date range filters, the query can contain macros.
$__timeFilter(timestamp)
#
This macro tells Grafana to send the start-time and end-time defined in the dashboard to the QuestDB server. It translates to:
$__interval
#
This macro calculates a dynamic interval based on the time range applied to the dashboard. By using this function, the sampling interval changes automatically as the user zooms in and out of the panel.