How to print mysql statements executed / to be executed on a statement in django?

Question

I want want to examine what django does with databse when I execute some statement with a django model
For instance

Group.members.all()

with manage.py shell.

Is there any way of doing this?

possible duplicate of [django orm, how to view (or log) the executed query?](http://stackoverflow.com/questions/971667/django-orm-how-to-view-or-log-the-executed-query) — Ignacio Vazquez-Abrams, Jun 28 '10 at 18:26

score 2 · Answer 1 · answered Jun 28 '10 at 18:28

2

You can use the Django Debug Toolbar.

answered Jun 28 '10 at 18:28

AbeEstrada

+1. And for the shell, the debug toolbar adds an extra manage.py command - `debugsqlshell` that prints the SQL for every ORM command you type. – Daniel Roseman Jun 28 '10 at 18:59

score 1 · Accepted Answer · answered Jun 29 '10 at 07:24

1

print Group.members.all().query

answered Jun 29 '10 at 07:24

Jason

2 Answers2