646
You print the queryset’s query attribute.
>>> queryset = MyModel.objects.all()
>>> print(queryset.query)
SELECT "myapp_mymodel"."id", ... FROM "myapp_mymodel"
73
Easy:
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
The django debug toolbar project uses this to present the queries on a page in a neat manner.
- [Django]-How do you Serialize the User model in Django Rest Framework
- [Django]-Django-reversion and related model
- [Django]-Django – getting Error "Reverse for 'detail' with no arguments not found. 1 pattern(s) tried:" when using {% url "music:fav" %}
68
The accepted answer did not work for me when using Django 1.4.4. Instead of the raw query, a reference to the Query object was returned: <django.db.models.sql.query.Query object at 0x10a4acd90>.
The following returned the query:
>>> queryset = MyModel.objects.all()
>>> queryset.query.__str__()
- [Django]-OneToOneField() vs ForeignKey() in Django
- [Django]-Django: How to get related objects of a queryset?
- [Django]-How to resize the new uploaded images using PIL before saving?
12
This middleware will output every SQL query to your console, with color highlighting and execution time, it’s been invaluable for me in optimizing some tricky requests
- [Django]-Django url tag multiple parameters
- [Django]-Django logging of custom management commands
- [Django]-How does the get_or_create function in Django return two values?
12
As an alternative to the other answers, django-devserver outputs SQL to the console.
- [Django]-No URL to redirect to. Either provide a url or define a get_absolute_url method on the Model
- [Django]-Disabled field is not passed through – workaround needed
- [Django]-Many-To-Many Fields View on Django Admin