Saturday, August 26, 2017

Show raw SQL queries in PostgreSQL

Show raw SQL queries in PostgreSQL


If you want to inspest what queries exactly Django ORM sends to the PostgreSQL, you can do it with postgres logging. The first step is to enable logging. Add 
log_statement = 'all'
to the file: 
sudo vim /etc/postgresql/9.4/main/postgresql.conf
Then you are able to see raw SQL queries with command: 
sudo tail -f /var/log/postgresql/postgresql-9.4-main.log

download file now

Posted by at

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)