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:

    '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.


Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.