How to Connect Grafana to Odoo: Monitoring Dashboard Integration

Why Use Grafana with Odoo?

Grafana is the industry standard for operational dashboards. While Odoo has built-in reporting, it does not provide real-time infrastructure monitoring — CPU usage, memory consumption, database query performance, worker utilization, and response times. Grafana fills this gap by visualizing metrics from Prometheus, PostgreSQL, and other data sources in customizable dashboards.

For Odoo administrators managing production deployments, Grafana dashboards answer critical questions: Is the server overloaded? Are database queries getting slower? How many concurrent users are active? Which endpoints are slowest?

Architecture Overview

The typical monitoring stack for Odoo:

1. Prometheus — collects and stores time-series metrics
2. Node Exporter — exposes server metrics (CPU, memory, disk, network)
3. PostgreSQL Exporter — exposes database metrics
4. Custom Odoo Exporter — exposes Odoo-specific metrics
5. Grafana — visualizes all metrics in dashboards

Step 1: Install Grafana

# Ubuntu/Debian
sudo apt-get install -y apt-transport-https software-properties-common
wget -q -O - https://packages.grafana.com/gpg.key | sudo apt-key add -
echo "deb https://packages.grafana.com/oss/deb stable main" | \
  sudo tee /etc/apt/sources.list.d/grafana.list
sudo apt-get update && sudo apt-get install -y grafana
sudo systemctl enable grafana-server && sudo systemctl start grafana-server

# Or with Docker
docker run -d --name grafana -p 3000:3000 grafana/grafana-oss

Step 2: Add Data Sources

Configure Grafana to pull data from your metrics sources:

Prometheus Data Source

1. Grafana → Configuration → Data Sources → Add
2. Select Prometheus
3. URL: http://prometheus:9090
4. Save & Test

PostgreSQL Data Source (Direct Queries)

1. Add PostgreSQL data source
2. Host: your PostgreSQL server
3. Database: your Odoo database
4. User: read-only user (create one for Grafana)
5. SSL mode as appropriate

Step 3: Build Odoo Server Dashboard

Create panels for key infrastructure metrics:

Step 4: Odoo Business KPI Dashboard

Use the PostgreSQL data source to query Odoo data directly for business metrics:

-- Daily new leads
SELECT date_trunc('day', create_date) as time,
       count(*) as leads
FROM crm_lead
WHERE create_date > now() - interval '30 days'
GROUP BY 1 ORDER BY 1;

-- Revenue by month
SELECT date_trunc('month', invoice_date) as time,
       sum(amount_total) as revenue
FROM account_move
WHERE move_type = 'out_invoice' AND state = 'posted'
  AND invoice_date > now() - interval '12 months'
GROUP BY 1 ORDER BY 1;

-- Active users (sessions in last 24h)
SELECT count(DISTINCT uid) as active_users
FROM ir_sessions
WHERE last_activity > now() - interval '24 hours';

Step 5: Set Up Alerts

Configure Grafana alerts for critical thresholds:

• CPU > 85% for 5 minutes — server needs scaling
• Disk usage > 90% — need to free space or expand
• DB connections > 80% of max — connection pool exhaustion risk
• Response time P95 > 5 seconds — performance degradation
• Error rate > 1% — application issues

Alerts can notify via email, Slack, PagerDuty, Microsoft Teams, or webhook.

Essential Grafana Dashboards for Odoo

• Infrastructure Overview: CPU, memory, disk, network across all servers
• PostgreSQL Performance: Queries/second, cache hit ratio, replication lag, table sizes
• Odoo Application: Request rate, response times, error rate, active workers
• Business KPIs: Revenue, orders, leads, customer growth, support tickets

Grafana Pricing

DeployMonkey + Grafana

DeployMonkey provides monitoring dashboards for your Odoo instances. Our AI agent can help you set up custom Grafana panels, configure alerting rules, and build business KPI dashboards from your Odoo data.