Skip to Content

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

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

./ runserver

you will see SQL queries in console output.


comments powered by Disqus