Skip to main content

Write Django's SQL statements to a JSONL log file

Project description

Django SQL Log Middleware

A middleware to write Django SQL queries and stats to a jsonl file. Makes analysis easier when you have log files that are hundreds of megabytes.

Inspired by the django-sqlprint-middleware project


pip install django-sql-log-middleware

Add it to the middleware section of



Output will be written to the path specified in SQLLOG_LOG in the below format. Each line is a JSON object covering a single request. Time is the current unix time. Query time is measured in seconds.

        "path": "/path/to/api?abc=1234",
        "time": 1649301150,
        "queries": [
            {"sql": "select * from users", "time": 1.1234},
            {"sql": "select * from things", "time": 4.1234},


Specify the following settings in your file:

  • DEBUG This middleware will only run when DEBUG is set.
  • SQLLOG_MIDDLEWARE set this variable to False disable the middleware without removal. Defaults to True
  • SQLLOG_PATH_RE a regex pattern to only log SQL queries in hte matched path(s). Defaults to .*
  • SQLLOG_LOG the file to write out the logs to. Defaults to django_queries.jsonl
  • SQLLOG_LOG_POST log request.POST data. Defaults to False
  • SQLLOG_LOG_META log request.META data. Defaults to False

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page