Search 1.9 billion lines of Odoo code on GitHub
smile_perf_analyzer
<h1 class="title">Performance Analyzer</h1>
<p><a class="reference external" href="http://www.gnu.org/licenses/agpl-3.0-standalone.html"><img alt="License: AGPL-3" src="https://img.shields.io/badge/licence-AGPL--3-blue.png" /></a> <a class="reference external" href="https://github.com/Smile-SA/odoo_addons/tree/14.0/smile_perf_analyzer"><img alt="Smile-SA/odoo_addons" src="https://img.shields.io/badge/github-Smile_SA%2Fodoo_addons-lightgray.png?logo=github" /></a></p>
<p>Features :</p>
<p>This module log in function of logging rules:</p>
<ul class="simple">
<li>each JSON-RPC / XML-RPC call linked to a model:
db, datetime, model, method, user, total time, db time, args, result</li>
<li>Python method profiling</li>
<li>SQL queries stats</li>
</ul>
<p>A logging rule is defined directly via the user interface
(menu: Settings > Technical > Performance > Rules)
and it's applied without restarting Odoo server.</p>
<p>To hide the database _perf created during the installation :</p>
<ul class="simple">
<li>add "dbfilter = (?!.*_perf$)" in your config file.</li>
</ul>
<p><strong>Table of contents</strong></p>
<div class="contents local topic" id="contents">
<ul class="simple">
<li><a class="reference internal" href="#usage" id="id1">Usage</a></li>
<li><a class="reference internal" href="#bug-tracker" id="id2">Bug Tracker</a></li>
<li><a class="reference internal" href="#gdpr-eu-privacy" id="id3">GDPR / EU Privacy</a></li>
<li><a class="reference internal" href="#credits" id="id4">Credits</a><ul>
<li><a class="reference internal" href="#authors" id="id5">Authors</a></li>
<li><a class="reference internal" href="#contributors" id="id6">Contributors</a></li>
<li><a class="reference internal" href="#maintainer" id="id7">Maintainer</a></li>
</ul>
</li>
</ul>
</div>
<a name="usage"></a>
<h2><a class="toc-backref" href="#id1">Usage</a></h2>
<p>To create a rule :</p>
<ol class="arabic simple">
<li>Go to <code>Settings > Technical > Performance> Rules</code> menu :</li>
</ol>
<ul class="simple">
<li>In this example we will create a rule for Administrator account in sale.order module :</li>
</ul>
<blockquote>
<p>We specify :</p>
<blockquote>
<ol class="loweralpha simple">
<li>Methods,</li>
<li>Slow RPC calls - Min. duration,</li>
<li>Slow SQL requests - Min. duration,</li>
<li>Slow field's recomputation - Min. duration</li>
<li>Profile Python methods,</li>
<li>Log SQL requests</li>
</ol>
</blockquote>
</blockquote>
<div class="figure">
<img alt="rule form" src="static/description/rule_form.png" style="width: 900px;" />
</div>
<ol class="arabic simple" start="2">
<li>The rule will be added to the rules :</li>
</ol>
<div class="figure">
<img alt="rules" src="static/description/rules.png" style="width: 900px;" />
</div>
<ol class="arabic simple" start="3">
<li>Then, when the Administrator executes one of the methods declared in the created rule, Performance Analyzer will record automatically :</li>
</ol>
<ul class="simple">
<li>Date</li>
<li>Method</li>
<li>SQL requests time</li>
<li>SQL requests count</li>
<li>Total Time, etc</li>
</ul>
<p>To show the Logs :</p>
<ol class="arabic simple" start="4">
<li>Go to <code>Settings > Technical > Performance</code>> Logs menu :</li>
</ol>
<div class="figure">
<img alt="logs" src="static/description/logs.png" style="width: 900px;" />
</div>
<a name="bug-tracker"></a>
<h2><a class="toc-backref" href="#id2">Bug Tracker</a></h2>
<p>Bugs are tracked on <a class="reference external" href="https://github.com/Smile-SA/odoo_addons/issues">GitHub Issues</a>.
In case of trouble, please check there if your issue has already been reported.
If you spotted it first, help us smashing it by providing a detailed and welcomed feedback
<a class="reference external" href="https://github.com/Smile-SA/odoo_addons/issues/new?body=module:%20smile_perf_analyzer%0Aversion:%2014.0%0A%0A**Steps%20to%20reproduce**%0A-%20...%0A%0A**Current%20behavior**%0A%0A**Expected%20behavior**">here</a>.</p>
<p>Do not contact contributors directly about support or help with technical issues.</p>
<a name="gdpr-eu-privacy"></a>
<h2><a class="toc-backref" href="#id3">GDPR / EU Privacy</a></h2>
<p>This addons does not collect any data and does not set any browser cookies.</p>
<a name="credits"></a>
<h2><a class="toc-backref" href="#id4">Credits</a></h2>
<a name="authors"></a>
<h3><a class="toc-backref" href="#id5">Authors</a></h3>
<p>Smile SA</p>
<a name="contributors"></a>
<h3><a class="toc-backref" href="#id6">Contributors</a></h3>
<ul class="simple">
<li>Corentin POUHET-BRUNERIE</li>
<li>Wafaa JAOUAHAR</li>
</ul>
<a name="maintainer"></a>
<h3><a class="toc-backref" href="#id7">Maintainer</a></h3>
<p>This module is maintained by the Smile SA.</p>
<p>Since 1991 Smile has been a pioneer of technology and also the European expert in open source solutions.</p>
<a class="reference external image-reference" href="https://www.smile.eu"><img alt="Smile SA" src="https://avatars0.githubusercontent.com/u/572339?s=200&v=4" /></a>
<p>This module is part of the <a class="reference external" href="https://github.com/Smile-SA/odoo_addons">odoo-addons</a> project on GitHub.</p>
<p>You are welcome to contribute.</p>