# Quickly setup SQL query logging on console in Django

DevFeed: [Quickly setup SQL query logging on console in Django](<https://devfeed.tech/articles/quickly-setup-sql-query-logging-on-console-in-django-27622.md>)

Original publisher: [Read original article](<https://gagor.pro/2014/05/quickly-setup-sql-query-logging-on-console-in-django/>)

Author: Tom

Published: 2014-05-28T00:00:00Z

Content type: tutorial

Language: en

Sources: [Tomasz Gągor](<https://devfeed.tech/sources/tomasz-gagor.md>)

Topics: [Django](<https://devfeed.tech/topics/django.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Logging](<https://devfeed.tech/topics/logging.md>), [debug](<https://devfeed.tech/topics/debug.md>), [Development](<https://devfeed.tech/topics/development.md>)

Tags: [console](<https://devfeed.tech/tags/console.md>), [debug](<https://devfeed.tech/tags/debug.md>), [development](<https://devfeed.tech/tags/development.md>), [django](<https://devfeed.tech/tags/django.md>), [logging](<https://devfeed.tech/tags/logging.md>), [python](<https://devfeed.tech/tags/python.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

A concise Django configuration enables SQL query logging in the console by setting the logging configuration for django.db.backends to DEBUG. DEBUG must also be enabled, and the application should be run in development mode.

## Source excerpt

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: