How to print requests executed by dsango.save () method?

Question

I want to see what requests are executed for the dsango.save () method. Since I'm in production, I can't use the Django toolbar for this.

Answer 1

There are two ways:

• https://docs.djangoproject.com/en/dev/faq/models/#how-can-i-see-the-raw-sql-queries-django-is-running

• In Django 1.3 and above, you can use logging, which I believe uploads your sql queries to the log. https://docs.djangoproject.com/en/dev/topics/logging/

There seems to be no simple direct path without DEBUG = True. This is the closest I could find: Running Django SQL queries with DEBUG set to False

Answer 2

Based on Sid's answer and this snippet (http://djangosnippets.org/snippets/1973/), I replace the postgres dg wrapper with the following:

# base.py from django.db.backends.postgresql_psycopg2.base import * #http://djangosnippets.org/snippets/1973/ class DatabaseWrapper(DatabaseWrapper): def __init__(self, *args, **kwargs): super(DatabaseWrapper, self).__init__(*args, **kwargs) self.use_debug_cursor = True 

Then in settings.py use 'ENGINE': 'my_project.db_backend' instead of the default backend (in my case, 'ENGINE': 'django.db.backends.postgresql_psycopg2' ,)

Now connection.queries will contain all your queries!