How to View Raw SQL Queries in Django

Disclaimer/Disclosure: Some of the content was synthetically produced using various Generative AI (artificial intelligence) tools; so, there may be inaccuracies or misleading information present in the video. Please consider this before relying on the content to make any decisions or take any actions etc. If you still have any concerns, please feel free to write them in a comment. Thank you.
---

Summary: Learn how to view the raw SQL queries executed by Django in your application. This guide covers various methods to log and inspect SQL queries for debugging and optimization purposes.
---

Understanding the SQL queries that Django executes can be crucial for debugging and optimizing your application. There are several methods to view these raw SQL queries, each useful in different scenarios. This post will explore the most common and effective ways to see the raw SQL queries Django is running.

Using Django's Query Logging

[[See Video to Reveal this Text or Code Snippet]]

Run Your Application:
When you run your application with the above logging configuration, Django will output the SQL queries to the console.

Using Django Debug Toolbar

The Django Debug Toolbar is a popular tool for inspecting various aspects of your application, including SQL queries.

Install Django Debug Toolbar:

[[See Video to Reveal this Text or Code Snippet]]

[[See Video to Reveal this Text or Code Snippet]]

Include Debug Toolbar URLs:

[[See Video to Reveal this Text or Code Snippet]]

Run Your Application:
Accessing your application in the browser will now show the debug toolbar, which includes a panel displaying all SQL queries executed during the request.

Access Queries:

[[See Video to Reveal this Text or Code Snippet]]

Using SQL Query Logging in Django Shell

To see SQL queries while working in the Django shell, you can enable SQL logging interactively.

Start Django Shell:

[[See Video to Reveal this Text or Code Snippet]]

Enable SQL Logging:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion