See Resolved Queries

v 8.0 v 9.0 v 10.0 v 11.0 v 12.0 Third Party 35
Download for 9.0 series
You bought this module and need support ? Click here !
Technical name resolved_queries
Also available in version v 12.0 v 11.0 v 10.0 v 8.0
Technical name resolved_queries
Also available in version v 12.0 v 11.0 v 10.0 v 8.0

Know the queries resolved in the object database

With this module you can see the queries that are made in postgres for one or several objects, according to a regular expression. The objective is to evaluate the consumption of the data layer of your modules, including odoo base modules. It will also serve to verify the effectiveness of the modules: Go Ui View Cache, website cache and web cache.

The JPV team recommends the following modules to improve the performance of your server:

Main view

In the main view, you will find the models that you can create and query individually or in groups. It will also allow you to choose the different graphs and statistics offered by the module to visually assess the highest resource consumption on your server.

Personalized consultations

Custom queries allow you to select the model you want to evaluate, the type of query and a pre-established regular expression. The system offers you a regular automatic expression according to your selected prefixes but you can modify these prefixes.

Three types of graphics

Examine and make decisions with the data thrown by your queries using the three types of graphs that represent the results in a graphical and intuitive way.

View the data in a pivot view

The data can be analyzed in the form of a statistical table.

Export the data collected in an xls file

This module provides the facility to save the results of the queries in the form of the models in an xls file.

Improve the performance of your server

In this wizard view modules are indicated which are recommended to improve performance by alleviating the consumption of odoo to postgres.

To test the modules of ir ui view cache, web base cache or website base cache, you must change the log_leve parameter in the configuration file to debug_sql

Juventud Productiva Venezolana

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author, please use the developer contact information. They can usually be found in the description.
Please choose a rating from 1 to 5 for this module.