Enable Query Debugging
A snippet showing how to debug and log Django ORM queries.
# settings.py
LOGGING = {
"version": 1,
"disable_existing_loggers": False,
"handlers": {
"console": {"class": "logging.StreamHandler"},
},
"loggers": {
"django.db.backends": {
"handlers": ["console"],
"level": "DEBUG",
}
},
}
Explanation:
- Enabling this logger will print all SQL queries along with their execution times to your console.
- This is especially useful in development for exposing performance bottlenecks such as N+1 query issues.
- Category Performance & Optimization
- Total Views 506
- Last Modified 11 April, 2026
- Tags #performance #debugging #queries #optimization
Previous snippet
Nginx Configuration for Django
Next snippet