<a class="reference external image-reference" 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.svg"> </a> <a name="profiler"></a> <h2>Profiler</h2> <p>Integration of cProfile and PgBadger.</p> <a name="installation"></a> <h3>Installation</h3> <p>To install this module, you need the following requirements:</p> <ul class="simple"> <li>Install <a class="reference external" href="http://dalibo.github.io/pgbadger/">pgbadger</a> binary package.</li> <li>Install <a class="reference external" href="https://pypi.python.org/pypi/pstats_print2list">pstats_print2list</a> python package.</li> <li>Set <cite>PG_LOG_PATH</cite> environment variable to know location of the <cite>postgresql.log</cite> file by default is <cite>/var/lib/postgresql/9.X/main/pg_log/postgresql.log</cite></li> <li>Enable postgresql logs from postgresql's configuration file (Default location for Linux Debian is <cite>/etc/postgresql/*/main/postgresql.conf</cite>) - Add the following lines at final (A postgresql restart is required <cite>/etc/init.d/postgresql restart</cite>)</li> </ul> <pre> <code lang="text">logging_collector=on log_destination='stderr' log_directory='pg_log' log_filename='postgresql.log' log_rotation_age=0 log_checkpoints=on log_hostname=on log_line_prefix='%t [%p]: [%l-1] db=%d,user=%u '</code> </pre> <a name="configuration"></a> <h3>Configuration</h3> <dl class="docutils"> <dt>By default profiler module adds two system parameters</dt> <dd><ul class="first last simple"> <li>exclude_fnames &gt; '/.repo_requirements,~/odoo-8.0,/usr/,&gt;'</li> <li>exclude_query &gt; 'ir_translation'.</li> </ul> </dd> </dl> <p>These parameters can be configurated in order to exclude some outputs from profiling stats or pgbadger output.</p> <a name="usage"></a> <h3>Usage</h3> <p>After installation, a player is add on the header bar, with following buttons:</p> <blockquote> <ul> <li><div class="first figure"> <img alt="Player to manage profiler" src="static/description/player.png" /> </div> </li> </ul> </blockquote> <ul> <li><dl class="first docutils"> <dt>Start profiling</dt> <dd><ul class="first last"> <li><div class="first figure"> <img alt="Start profiling" src="static/description/start_profiling.png" style="height: 35px;" /> </div> </li> </ul> </dd> </dl> </li> <li><dl class="first docutils"> <dt>Stop profiling</dt> <dd><ul class="first last"> <li><div class="first figure"> <img alt="Stop profiling" src="static/description/stop_profiling.png" style="height: 35px;" /> </div> </li> </ul> </dd> </dl> </li> <li><dl class="first docutils"> <dt>Download stats: download stats file</dt> <dd><ul class="first last"> <li><div class="first figure"> <img alt="Download cprofile stats file" src="static/description/dump_stats.png" style="height: 35px;" /> </div> </li> </ul> </dd> </dl> </li> <li><dl class="first docutils"> <dt>Clear stats</dt> <dd><ul class="first last"> <li><div class="first figure"> <img alt="Clear and remove stats file" src="static/description/clear_stats.png" style="height: 35px;" /> </div> </li> </ul> </dd> </dl> </li> </ul> <a name="credits"></a> <h3>Credits</h3> <a name="contributors"></a> <h4>Contributors</h4> <ul class="simple"> <li><dl class="first docutils"> <dt>Georges Racinet &lt;<a class="reference external" href="mailto:gracinet&#64;anybox.fr">gracinet&#64;anybox.fr</a>&gt;</dt> <dd><ul class="first last"> <li>Remotely inspired from ZopeProfiler, although there is no online visualisation and there may never be one.</li> </ul> </dd> </dl> </li> <li>Moisés López &lt;<a class="reference external" href="mailto:moylop260&#64;vauxoo.com">moylop260&#64;vauxoo.com</a>&gt;</li> <li>Hugo Adan &lt;<a class="reference external" href="mailto:hugo&#64;vauxoo.com">hugo&#64;vauxoo.com</a>&gt;</li> </ul> <a name="maintainer"></a> <h4>Maintainer</h4> <a class="reference external image-reference" href="https://odoo-community.org"><img alt="Odoo Community Association" src="https://odoo-community.org/logo.png" /></a> <p>This module is maintained by the OCA.</p> <p>OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.</p> <p>To contribute to this module, please visit <a class="reference external" href="https://odoo-community.org">https://odoo-community.org</a>.</p>