odoo-performance-tuner

name	odoo-performance-tuner
description	Expert guide for diagnosing and fixing Odoo performance issues: slow queries, worker configuration, memory limits, PostgreSQL tuning, and profiling tools.
type	skill
created	2026-02-27T00:00:00.000Z
domain	communication-content
category	documentation
risk	safe
source	self
tags	["skill","communication-content","documentation","odoo","performance","tuner"]

Odoo Performance Tuner

Overview

This skill helps diagnose and resolve Odoo performance problems — from slow page loads and database bottlenecks to worker misconfiguration and memory bloat. It covers PostgreSQL query tuning, Odoo worker settings, and built-in profiling tools.

When to Use This Skill

• Odoo is slow in production (slow page loads, timeouts).
• Getting MemoryError or Worker timeout errors in logs.
• Diagnosing a slow database query using Odoo's profiler.
• Tuning odoo.conf for a specific server spec.

How It Works

1. Activate: Mention @odoo-performance-tuner and describe your performance issue.
2. Diagnose: Share relevant log lines or config and receive a root cause analysis.
3. Fix: Get exact configuration changes with explanations.

Examples

Example 1: Recommended Worker Configuration

# odoo.conf — tuned for a 4-core, 8GB RAM server

workers = 9                   # (CPU_cores × 2) + 1 — never set to 0 in production
max_cron_threads = 2          # background cron jobs; keep ≤ 2 to preserve user-facing capacity
limit_memory_soft = 1610612736  # 1.5 GB — worker is recycled gracefully after this
limit_memory_hard = 2147483648  # 2.0 GB — worker is killed immediately; prevents OOM crashes
limit_time_cpu = 600          # max CPU seconds per request
limit_time_real = 1200        # max wall-clock seconds per request
limit_request = 8192          # max requests before worker recycles (prevents memory leaks)

Example 2: Find Slow Queries with PostgreSQL

-- Step 1: Enable pg_stat_statements extension (run once as postgres superuser)
 EXTENSION IF   pg_stat_statements;







    (query, )  query_snippet,
    round(mean_exec_time::, )  avg_ms,
    calls,
    round(total_exec_time::, )  total_ms
 pg_stat_statements
  mean_exec_time 
LIMIT ;


 schemaname, tablename, attname, n_distinct, correlation
 pg_stats
 tablename  
   correlation     
  n_distinct ;