odoo-performance-tuner

Featured

Expert guide for diagnosing and fixing Odoo performance issues: slow queries, worker configuration, memory limits, PostgreSQL tuning, and profiling tools.

API & Backend 49,938 stars 7238 forks Updated today MIT

Install

View on GitHub

Quality Score: 96/100

Stars 20%
100
Recency 20%
100
Frontmatter 20%
70
Documentation 15%
100
Issue Health 10%
50
License 10%
100
Description 5%
100

Skill Content

# 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 ```ini # 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) ``` ### Exa...

Details

Author
sickn33
Repository
sickn33/antigravity-awesome-skills
Created
10 months ago
Last Updated
today
Language
Python
License
MIT

Integrates with

Bundled in these plugins

Similar Skills

Semantically similar based on skill content — not just same category

AI & Automation Listed

odoo-perf

Making Odoo fast — recordset hygiene (no query-in-loop, search-once-with-in, mapped/filtered/sorted), the ORM cache & prefetching, stored vs non-stored computed fields (write amplification, exhaustive @api.depends), database indexes (index=True and typed indexes), _read_group aggregation, batch create/write, and justified raw SQL with correct cache invalidation. Use whenever an Odoo page/list/report/cron is slow, an N+1 query pattern appears, you're about to add store=True or an index, or you're writing a loop that search()es or browses one record at a time. Measure real SQL counts from the running instance — don't guess. Targets Odoo 17/18/19.

5 Updated 4 months ago
tuanle96
AI & Automation Listed

odoo

Odoo engineering workflows for addon development, codebase exploration, debugging, architecture/refactor review, manifest/docs sync, and routing to migration work. Use when the user mentions Odoo, addons, modules, manifests, models, XML views, security CSVs, record rules, Odoo shell, OWL/QWeb/assets, or when an Odoo codebase is detected.

3 Updated 1 months ago
Immoderate-humulin783
API & Backend Listed

database-optimizer

Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Use when investigating slow queries, analyzing execution plans, or optimizing database performance. Invoke for index design, query rewrites, configuration tuning, partitioning strategies, lock contention resolution.

4 Updated 1 months ago
jahidulislamseo