Enabling django SQL query logging

[candlerb]

I'm completely failing to enable django SQL query logging, and I wonder if someone can tell me what I'm doing wrong.

In configuration.py I have:

DEBUG = True
...
LOGGING = {
    'version': 1,
    'disable_existing_loggers': False,
    'handlers': {
        'file': {
            'level': 'DEBUG',
            'class': 'logging.handlers.WatchedFileHandler',
            'filename': '/opt/netbox/log/netbox.log',
        },
    },
    'loggers': {
        'django.db.backends': {
            'level': 'DEBUG',
            'handlers': ['file'],
            'propagate': True,
        },
        'netbox': {
            'level': 'DEBUG',
            'handlers': ['file'],
        },
    },
}

I note from here:

For performance reasons, SQL logging is only enabled when settings.DEBUG is set to True, regardless of the logging level or handlers that are installed.

I know that DEBUG=True is applied, because the web interface is showing me the warning banner about debug mode.

I know that logging is working and permissions are correct, because tail -f /opt/netbox/log/netbox.log shows some logs being appended on each page refresh:

Loaded configuration data from cache
Initialized configuration
Cleared configuration

Furthermore, if I change the logger from django.db.backends to django, then I get a whole load of Django debugging crap on each page request (tons of caught exceptions like AttributeError, TypeError, ValueError, KeyError). But no SQL queries!

I've found a whole bunch of third-party pages about Django SQL logging, all of them suggest that what I'm doing above is correct.

Can somebody tell me what I'm missing? Thanks!

[candlerb]

Having found this, I wonder if Netbox's use of django-debug-toolbar is intercepting the SQL logs? That link suggests that you need to mess about with middleware to get around it.