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

django django-models django-orm
DjangoNewbe picture DjangoNewbe · Jun 9, 2009 · Viewed 93.9k times · Source

Is there a way I can print the query the Django ORM is generating?

Say I execute the following statement: Model.objects.filter(name='test')

How do I get to see the generated SQL query?

Answer

Joe Holloway picture Joe Holloway · Jun 9, 2009

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

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.

Related questions

Django values_list vs values

In Django, what's the difference between the following two: Article.objects.values_list('comment_id', flat=True).distinct() vs Article.objects.values('comment_id').distinct() My goal is to get a list of unique comment ids under each Article. I've …

Read More
What's the difference between select_related and prefetch_related in Django ORM?

In Django doc, select_related() "follows" foreign-key relationships, selecting additional related-object data when it executes its query. prefetch_related() does a separate lookup for each relationship, and does the "joining" in Python. What does it mean by "doing the joining …

Read More
Django database query: How to get object by id?

Django automatically creates an id field as primary key. Now I need to get the object by this id. object = Class.objects.filter() How to write this filter?

Read More