Skip to Content
This question has been flagged
postgresqllogsql
1 Reply
11711 Views
Avatar
Eric Lee

When I vi /var/log/postgresql/postgresql-9.5-main.log, There are only SQL queries that I typed in postgresql console.

How do I view all the SQL query that Odoo produces?

Avatar
Discard
Avatar
Dipak Shah
Best Answer

Hey Eric Lee,

One way you can see sql queries by adding parameter (In Shell / Terminal) while running a odoo server is,

--log-level debug_sql

This will start odoo server in sql debug mode and you can check every query and sql movements.

Hope this will server your purpose !

Thanks,

Dipak

Avatar
Discard
Eric Lee
Author

Thanks for the answer.

Related Posts Replies Views Activity
Getting Error while restoring Openerp database
postgresql sql
Avatar
Avatar
1
Mar 15
6561
Getting Error while restoring Openerp database
postgresql sql
Avatar
0
Mar 15
4626
Getting Error while restoring Openerp database
postgresql sql
Avatar
0
Mar 15
4268
How to Log SQL Queries Related to Odoo Accounting Transactions? Solved
accounting log sql queries
Avatar
Avatar
1
Mar 25
3109
Show two column instead of two rows in psql.
postgresql sql pgadmin odoo
Avatar
Avatar
1
Jul 21
4962