How to get the SQL from a Django QuerySet

Question

I'm trying to debug , but I'm not sure what queries are going to the database. How do I get the SQL that Django will use on the database from a QuerySet object?

Answer 1

Hello @kartik,

Try this in your queryset:

print my_queryset.query

For example:

from django.contrib.auth.models import User
print User.objects.filter(last_name__icontains = 'ax').query

It should also be mentioned that if you have DEBUG = True, then all of your queries are logged, and you can get them by accessing connection.queries:

from django.db import connections
connections['default'].queries

Hope it helps!

Thank You!!