In Django How determine or log the num of db calls in one view?

Question

How i can determine the number of calls does by my app in one view call. I intent to make a decorator with this intention.

@trace_db_calls
def my_view(request):
     #code
     return HttpResponse('done')

At this moment I am investigating how to do it, regards

Possible duplicate of [How to show the SQL Django is running](http://stackoverflow.com/questions/1074212/how-to-show-the-sql-django-is-running) — e4c5, May 07 '17 at 03:50

score 0 · Answer 1 · answered May 06 '17 at 21:45

0

you should look at the django-debug-tool. You can open the django debug shell with command python manage.py debugsqlshell and in shell you can call your function. It'll show all the database queries made.

Also if you are looking for a way to log SQL queries in a file you can look at this middleware. Middleware runs on every request.

answered May 06 '17 at 21:45

badiya

2,247
13
23

The `debugsqlshell` does not appear to exist anymore – Blye Nov 28 '22 at 17:22

In Django How determine or log the num of db calls in one view?

1 Answers1