How to log all sql queries in Django?

by

Merge the following snippet with the LOGGING field in your settings.py:

LOGGING = {
    'version': 1,
    'filters': {
        'require_debug_true': {
            '()': 'django.utils.log.RequireDebugTrue',
        }
    },
    'handlers': {
        'console': {
            'level': 'DEBUG',
            'filters': ['require_debug_true'],
            'class': 'logging.StreamHandler',
        }
    },
    'loggers': {
        'django.db.backends': {
            'level': 'DEBUG',
            'handlers': ['console'],
        }
    }
}

Tweaked from @acardenas89 answer

More Related Contents:

  1. How to see the raw SQL queries Django is running?
  2. Getting the SQL from a Django QuerySet [duplicate]
  3. Django: Adding “NULLS LAST” to query
  4. LEFT JOIN Django ORM
  5. Elegant setup of Python logging in Django
  6. How can I disable logging while running unit tests in Python Django?
  7. How to perform OR condition in django queryset?
  8. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  9. Simple Subquery with OuterRef
  10. Naming Python loggers
  11. What is the best way to access stored procedures in Django’s ORM
  12. Django Setup Default Logging
  13. How to quote a string value explicitly (Python DB API/Psycopg2)
  14. How to delete a record in Django models?
  15. Django: add image in an ImageField from image url
  16. how to iterate through dictionary in a dictionary in django template?
  17. Django multi tenancy
  18. Django – How to make a variable available to all templates?
  19. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  20. manage.py runserver
  21. filter foreignkey field in django admin
  22. Is this Python code vulnerable to SQL injection? (SQLite3)
  23. How can my Model primary key start with a specific number?
  24. How do I log from my Python Spark script
  25. Django Passing data between views
  26. Serving large files ( with high loads ) in Django
  27. can’t pip install mysql-python
  28. Rendering JSON objects using a Django template after an Ajax call
  29. Django — Conditional Login Redirect
  30. How to properly use the “choices” field option in Django

Leave a Comment