What is the N+1 query problem in Odoo?

It occurs when code executes a separate database query for every record in a recordset; this skill helps identify these patterns so they can be replaced by Odoo's batched prefetching.

How do I calculate the ideal number of Odoo workers?

The recommended formula is (CPU_cores × 2) + 1. You should never set workers to 0 in a production environment as it serializes all requests and leads to user timeouts.

How do I find slow SQL queries in Odoo?

The skill provides SQL snippets to enable pg_stat_statements and use Odoo's built-in profiler (?debug=1) to pinpoint which specific methods are triggering slow database operations.

Can this skill help with Odoo.sh environments?

Yes. While Odoo.sh manages some low-level infrastructure, this skill provides code-level optimizations, ORM caching techniques, and profiler usage applicable to all Odoo hosting types.

Odoo Performance Tuner

Name: Odoo Performance Tuner
Author: sickn33

bysickn33

•

31,431

•

データベース管理

Diagnoses and resolves Odoo performance bottlenecks including slow queries, worker configurations, and memory limits.

The Odoo Performance Tuner is a comprehensive diagnostic skill designed to optimize Odoo ERP systems for high-traffic environments. It provides expert guidance on identifying database bottlenecks via PostgreSQL profiling, fine-tuning odoo.conf parameters for specific hardware specifications, and utilizing Odoo's built-in profiling tools to resolve Python-level inefficiencies. Whether you are facing worker timeouts, memory bloat, or slow page loads, this skill offers actionable configuration changes and best practices to ensure a stable and responsive production instance.

主な機能

01Integrated Odoo profiler usage and interpretation

02Production-ready configuration baselines for varied server specs

03PostgreSQL query analysis and indexing recommendations

04Automated odoo.conf worker and memory limit tuning

0531,431 GitHub stars

06Identification of N+1 query patterns and ORM inefficiencies

ユースケース

01Optimizing Odoo for production deployment on multi-core servers

02Troubleshooting MemoryError and worker timeouts in server logs

03Improving response times for slow modules or custom business logic

主な機能

01Integrated Odoo profiler usage and interpretation

02Production-ready configuration baselines for varied server specs

03PostgreSQL query analysis and indexing recommendations

04Automated odoo.conf worker and memory limit tuning

0531,431 GitHub stars

06Identification of N+1 query patterns and ORM inefficiencies

ユースケース

01Optimizing Odoo for production deployment on multi-core servers

02Troubleshooting MemoryError and worker timeouts in server logs

03Improving response times for slow modules or custom business logic