Is there a way to show the SQL that Django is running while performing a query?
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:
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
from django.db import reset_queries reset_queries() print(connection.queries) >>> 
Answered By – geowa4