Profiling Odoo code


This tutorial requires having installed Odoo and writing Odoo code

Graph a method

Odoo embeds a profiler of code. This embedded profiler output can be used to generate a graph of calls triggered by the method, number of queries, percentage of time taken in the method itself as well as the time that the method took and its sub-called methods.

from import profile
def mymethod(...)

This produces a file called /temp/prof.profile

A tool called gprof2dot will produce a graph with this result:

gprof2dot -f pstats -o /temp/prof.xdot /temp/prof.profile

A tool called xdot will display the resulting graph:

xdot /temp/prof.xdot

Log a method

Another profiler can be used to log statistics on a method:

from import profile
def mymethod(...):

The statistics will be displayed into the logs once the method to be analysed is completely reviewed.

2018-03-28 06:18:23,196 22878 INFO openerp
calls     queries   ms
project.task ------------------------ /home/odoo/src/odoo/addons/project/models/, 638

1         0         0.02          @profile
                                  def create(self, vals):
                                      # context: no_log, because subtype already handle this
1         0         0.01              context = dict(self.env.context, mail_create_nolog=True)

                                      # for default stage
1         0         0.01              if vals.get('project_id') and not context.get('default_project_id'):
                                          context['default_project_id'] = vals.get('project_id')
                                      # user_id change: update date_assign
1         0         0.01              if vals.get('user_id'):
                                          vals['date_assign'] =
                                      # Stage change: Update date_end if folded stage
1         0         0.0               if vals.get('stage_id'):
1         108       631.8             task = super(Task, self.with_context(context)).create(vals)
1         0         0.01              return task

1         108       631.85

Dump stack

Sending the SIGQUIT signal to an Odoo process (only available on POSIX) makes this process output the current stack trace to log, with info level. When an odoo process seems stuck, sending this signal to the process permit to know what the process is doing, and letting the process continue his job.

Tracing code execution

Instead of sending the SIGQUIT signal to an Odoo process often enough, to check where the processes are performing worse than expected, we can use the py-spy tool to do it for us.

Install py-spy

python3 -m pip install py-spy

Recordxecuted code

As py-spy is installed, we now record the executed code lines. This tool will record, multiple times a second, the stacktrace of the process.

# record to raw file
py-spy record -o profile.json -f speedscope --pid <PID>

# OR record directly to svg
py-spy record -o profile.svg --pid <PID>

where <PID> is the process ID of the odoo process you want to graph.

To open profile.json you can use online tool

To open profile.svg you should use browser, because other viewer may not support interactive part.

1 总浏览
1 成员的观点
0 公众浏览
0 喜爱
0 不喜欢
0 注释

登录 分享这个 webpage 通过电子邮件。