PostgreSQL data source
Grafana includes a built-in PostgreSQL data source plugin, enabling you to query and visualize data from any PostgreSQL-compatible database. You don’t need to install a plugin to add the PostgreSQL data source to your Grafana instance.
Grafana offers several configuration options for this data source as well as a visual and code-based query editor.
Supported databases
This data source supports the following PostgreSQL-compatible databases:
- PostgreSQL 9.0 and newer
- Amazon RDS for PostgreSQL
- Amazon Aurora PostgreSQL
- Azure Database for PostgreSQL
- Google Cloud SQL for PostgreSQL
Grafana recommends using the latest available version for your database for optimal compatibility.
Key capabilities
The PostgreSQL data source supports:
- Time series queries: Visualize metrics over time using built-in time grouping macros.
- Table queries: Display query results in table format for any valid SQL query.
- Template variables: Create dynamic dashboards with variable-driven queries.
- Annotations: Overlay events from PostgreSQL on your dashboard panels.
- Alerting: Create alerts based on PostgreSQL query results (time series format only).
- Macros: Simplify queries with built-in macros for time filtering and grouping.
Get started with the PostgreSQL data source
The following documents will help you get started with the PostgreSQL data source in Grafana:
- Configure the PostgreSQL data source
- PostgreSQL query editor
- PostgreSQL template variables
- PostgreSQL annotations
- PostgreSQL alerting
- Troubleshooting
After you configure the data source, you can:
- Create a variety of visualizations
- Add annotations to overlay events on your panels
- Use template variables for dynamic dashboards
- Set up alerting with time series queries (time series format only)
- Add transformations
View a PostgreSQL overview on Grafana Play:
With Grafana Play, you can explore and see how it works, learning from practical examples to accelerate your development. This feature can be seen on PostgreSQL Overview.
