With this talk, you will discover a module to detect performance issues related to python and/or postgresql using profiling and logging, and fixing it.  
Many issues are related to performance issues, and this presentation is important to detect the piece of code:

• Slowest executed python method or sql query

• Most time executed python method or sql query

This talk is a live demo where you will discover how to:

• Force a common sql and python performance issue

• Use the (1) Odoo-profiler module to detect it

• Different ways to fix them (LIMIT, WHERE, INDEX, COMPLEX INDEX, STORE=TRUE, and others)

• Fix and run again the Odoo profiler  

This talk is based on this module: https://github.com/vauxoo/odoo-profiler developed by Vauxoo