How to view corresponding SQL query of the Django ORM’s queryset?

by

Each QuerySet object has a query attribute that you can log or print to stdout for debugging purposes.

qs = Model.objects.filter(name="test")
print(qs.query)

Note that in pdb, using p qs.query will not work as desired, but print(qs.query) will.

If that doesn’t work, for old Django versions, try:

print str(qs.query)

Edit

I’ve also used custom template tags (as outlined in this snippet) to inject the queries in the scope of a single request as HTML comments.

More Related Contents:

  1. Why does django’s prefetch_related() only work with all() and not filter()?
  2. Select DISTINCT individual columns in django?
  3. Django: implementing JOIN using Django ORM?
  4. How to query Case-insensitive data in Django ORM?
  5. Creating Partial Indexes with Django 1.7
  6. Convert Django Model object to dict with all of the fields intact
  7. What does on_delete do on Django models?
  8. Django Aggregation: Summation of Multiplication of two fields
  9. Dynamic File Path in Django
  10. Issue with ManyToMany Relationships not updating immediately after save
  11. Django: Populate user ID when saving a model
  12. Get model’s fields in Django
  13. Can django’s auth_user.username be varchar(75)? How could that be done?
  14. How to ‘bulk update’ with Django?
  15. Using a UUID as a primary key in Django models (generic relations impact)
  16. Django ManyToMany filter()
  17. Django delete FileField
  18. ImageField overwrite image file with same name
  19. How to rename items in values() in Django?
  20. Django “xxxxxx Object” display customization in admin action sidebar
  21. Chaining multiple filter() in Django, is this a bug?
  22. How to register users in Django REST framework?
  23. List field in model?
  24. Django : Unable to import model from another App
  25. django.db.utils.IntegrityError: UNIQUE constraint failed: rango_category__new.slug
  26. Django: Does prefetch_related() follow reverse relationship lookup?
  27. How to add Check Constraints for Django Model fields?
  28. Django queryset get exact manytomany lookup [duplicate]
  29. Django Migrations Add Field with Default as Function of Model
  30. how to write a query to get find value in a json field in django

Leave a Comment