Configuring Grafana

Configure Grafana to point to the data sources required for fetching metrics, and load the pre-configured dashboards to visualize the collected data.

Add data sources

Prometheus

1. Log in to Grafana with admin privileges.
2. Go to Connections > Data Sources > Add new data source.
3. Select Prometheus.
4. Enter the Prometheus server URL (e.g., http://<PROMETHEUS_HOST>:9090).
5. Select Save & Test.

Loki

1. Log in to Grafana with admin privileges.
2. Go to Connections > Data Sources > Add new data source.
3. Select Loki.
4. Enter the Loki server URL (e.g., http://<LOKI_HOST>:3100).
5. Select Save & Test.

Infinity data source for WHPG Exporter

1. Log in to Grafana with admin privileges.
2. Navigate to Connections > Add new connection, search for Infinity, and select Install.
3. Go to Connections > Data Sources > Add new data source.
4. Select Infinity.
5. Enter the Exporter details under Base URL (e.g., http://</WHPG_EXPORTER_HOST:<9187>/api/v1/query).
6. Select Save & Test.

Import the dashboards

EDB provides a set of JSON configuration files for Grafana. We understand that users have different needs for monitoring. The provided Grafana configurations provide a starting point for customization.

1. Download WarehousePG dashboard JSON files.

   • WHPG Cluster Dashboard
   • WHPG Cluster Details
   • WHPG Log Details
   • WHPG Query Details
   • WHPG Recommendations
   • WHPG Resource Details
   • WHPG Segment Details

2. In Grafana, go to Dashboards.

3. Select the New dropdown menu and select Import.

4. Upload the JSON file or paste its content.

5. Select Import.

6. Repeat the same steps for all the provided dashboards.

Verify the installation

You should now be able to view the metrics obtained from your WHPG cluster by using the Grafana dashboards.