How to Log All SQL Queries in Django?

How to Log SQL Queries in Django

Logging all SQL queries executed by a Django application can be beneficial for debugging and performance analysis. This article provides a step-by-step guide on how to achieve this effectively.

Configuration

To log all SQL queries, including those generated by the admin site, integrate the following snippet into the LOGGING field within your settings.py file:

<code class="python">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'],
        }
    }
}</code>

Results

Upon implementation, all SQL queries performed by your Django application will be recorded in the specified log file, providing a comprehensive record of database interactions for troubleshooting and analysis.

The above is the detailed content of How to Log All SQL Queries in Django?. For more information, please follow other related articles on the PHP Chinese website!