How to time Django queries

chiurox picture chiurox · Dec 9, 2010 · Viewed 13.8k times · Source

I've always used Python's timeit library to time my little Python programs. Now I'm developing a Django app and I was wondering how to time my Django functions, especially queries.

For example, I have a def index(request) in my views.py which does a bunch of stuff when I load the index page. How can I use timeit to time this particular function without altering too much my existing functions?

Answer

Brosto picture Brosto · Dec 9, 2010

if your django project is in debug, you can see your database queries (and times) using:

>>> from django.db import connection
>>> connection.queries

I know this won't satisfy your need to profile functions, but hope it helps for the queries part!