Quickly setup SQL query logging on console in Django

There is need plugin for Django, named django-debug-toolbar but it needs some time to configure. So when I need simple way to debug SQL queries I use small hack. Add to your settings.py:

LOGGING = {
    'version': 1,
    'disable_existing_loggers': False,
    'handlers': {
        'console': {
            'level': 'DEBUG',
            'class': 'logging.StreamHandler',
        }
    },
    'loggers': {
        'django.db.backends': {
            'handlers': ['console'],
            'level': 'DEBUG',
        },
    }
}

To get this working DEBUG option have to be set to True:

DEBUG = True

After this setup, when you run you app in development mode:

./manage.py runserver

you will see SQL queries in console output.

Source:
https://docs.djangoproject.com/en/1.6/topics/logging/#examples

Leave a Reply

Your email address will not be published. Required fields are marked *