What PostgreSQL queries fire when a odoo external api functions runs?

Question

models . execute_kw ( db ,  uid ,  password ,
'res.partner' ,  'search' ,
[[[ 'is_company' ,  '=' ,  True ], [ 'customer' ,  '=' ,  True ]]])
when these type of external command runs, a postgres command also runs behind then scene which evaluate the result.
I want to know what command run in postgres when a odoo api function runs.

Sudhir Arya (ERP Harbor Consulting Services) · Accepted Answer

Hi Rohit,
Maybe _where_calc [1] method can help you. Try to trace the code, put the print statements which will print the query for the domain.

[1] https://github.com/odoo/odoo/blob/11.0/odoo/models.py#L3546

Ray Carnes (ray) · Answer

Run Odoo with the startup parameter:
--log-sql  enables DEBUG logging of SQL querying You can do this either on the command-line or via a Configuration File.
See:
https://www.odoo.com/documentation/11.0/reference/cmdline.html [1]
https://www.odoo.com/documentation/11.0/reference/cmdline.html#configuration-file [2]

[1] https://www.odoo.com/documentation/11.0/reference/cmdline.html
[2] https://www.odoo.com/documentation/11.0/reference/cmdline.html#configuration-file

This question has been flagged

Enjoying the discussion? Don't just read, join in!