How to see the raw SQL queries Django is running?

by

See the docs FAQ: “How can I see the raw SQL queries Django is running?“

django.db.connection.queries contains a list of the SQL queries:

from django.db import connection
print(connection.queries)

Querysets also have a query attribute containing the query to be executed:

print(MyModel.objects.filter(name="my name").query)

Note that the output of the query is not valid SQL, because:

“Django never actually interpolates the parameters: it sends the query and the parameters separately to the database adapter, which performs the appropriate operations.”

From Django bug report #17741.

Because of that, you should not send query output directly to a database.

If you need to reset the queries to, for example, see how many queries are running in a given period, you can use reset_queries from django.db:

from django.db import reset_queries

reset_queries()
print(connection.queries)
>>> []

More Related Contents:

  1. How to log all sql queries in Django?
  2. Getting the SQL from a Django QuerySet [duplicate]
  3. OperationalError: database is locked
  4. Django: Adding “NULLS LAST” to query
  5. LEFT JOIN Django ORM
  6. multiple databases and multiple models in django
  7. Django persistent database connection
  8. How do you join two tables on a foreign key field using django ORM?
  9. How to make/use a custom database function in Django
  10. A QuerySet by aggregate field value
  11. How to move a model between two Django apps (Django 1.7)
  12. sqlite3.OperationalError: unable to open database file
  13. How to perform OR condition in django queryset?
  14. SQLAlchemy: how to filter date field?
  15. What is an efficient way of inserting thousands of records into an SQLite table using Django?
  16. Simple Subquery with OuterRef
  17. Race conditions in django
  18. What is the best way to access stored procedures in Django’s ORM
  19. What is your favorite solution for managing database migrations in django? [closed]
  20. django.core.exceptions.ImproperlyConfigured: Error loading MySQLdb module: No module named MySQLdb
  21. Getting random row through SQLAlchemy
  22. Select NULL Values in SQLAlchemy
  23. Django: Increment blog entry view count by one. Is this efficient?
  24. How to quote a string value explicitly (Python DB API/Psycopg2)
  25. django makemigrations and migrate on heroku server don’t create tables
  26. How to delete a record in Django models?
  27. Add Text on Image using PIL
  28. How to override template in django-allauth?
  29. Create a post activate script in Conda [duplicate]
  30. How do you configure Django for simple development and deployment?

Leave a Comment