Django Logging - How to remove SQL query in logging file

Question

I try to make Django Logging to log error from server. Now my code:

LOGGING = {
    'version': 1,
    'disable_existing_loggers': False,
    'handlers': {
        'file': {
            'level': 'DEBUG',
            'class': 'logging.FileHandler',
            'filename': os.path.join(PROJECT_LOCAL_URL, 'mylog.log'),
        },
    },
    'loggers': {
        'django': {
            'handlers': ['file'],
            'level': 'DEBUG',
            'propagate': True,
        },
    },
}

When I check mylog.log, it have too many sql queries string - SELECT FROM, which I want not to see. How can I config this?

How can I remove all sql queries in logging file?

score 7 · Accepted Answer · answered Oct 15 '18 at 04:35

7

Database queries are logged by a django.db.backends logger. Assuming you still want DEBUG level logging everywhere else then you need to specifically define a rule for this logger to ignore DEBUG logging:

'loggers': {
    'django': {
        'handlers': ['file'],
        'level': 'DEBUG',
        'propagate': True,
    },
    'django.db.backends': {
        'handlers': ['file'],
        'level': 'WARNING',   # DEBUG will log all queries, so change it to WARNING.
        'propagate': False,   # Don't propagate to other handlers
    },
},

answered Oct 15 '18 at 04:35

solarissmoke

30,039
14
71
73

Thank you. It works. But change level into WARNING to Database queries, it sounds like not reasonable? – KitKit Oct 15 '18 at 04:38
You could use level `INFO` instead, which is the next level up from `DEBUG`. It depends on how much you want to log. – solarissmoke Oct 15 '18 at 04:41
Thanks @solarissmoke. Pick you the best answer! – KitKit Oct 15 '18 at 04:44

Django Logging - How to remove SQL query in logging file

1 Answers1