Timing Django DB Queries

Question

I'm attempting to benchmark the speed of several different queries which return the same thing on Django 1.4 with Postgres. Unfortunately, if I use:

 import logging
 l = logging.getLogger('django.db.backends')
 l.setLevel(logging.DEBUG)
 l.addHandler(logging.StreamHandler())

Two equivalent or similar queries, end up getting deferred to the Query cache. Any way I can clear this cache or have a better way of comparing the speed of two queries?

Already have django-debug-toolbar installed, but it does not work in many instances (ie. AJAX requests), and is not really efficient in benchmarking queries since I need to load them into a view and manually test. Also, if you run two of the same queries, since its cached, the time for the second query will be significantly shorter. — zhuyxn
– zhuyxn, Commented Jul 19, 2013 at 6:08
You should take a look at stackoverflow.com/questions/3346124/… — Gabriel Pichot
– Gabriel Pichot, Commented Jul 19, 2013 at 6:14
You should never time ajax requests since they are async by nature. using the timeit module in python would help you time a view's execution time though. — Henrik Andersson
– Henrik Andersson, Commented Jul 19, 2013 at 6:28

steffens21 · Accepted Answer · 2013-07-19 16:03:29Z

5

For my analysis I used something like this:

from django import db
for query in db.connections['default'].queries:
    print query, query['time']

answered Jul 19, 2013 at 16:03

steffens21

7596 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

steffens21 Over a year ago

Also, check out stackoverflow.com/questions/2133627/…

zhuyxn Over a year ago

This solution has the same issue as mine and the above suggestion, which is that since Django caches querysets, if you run the same or similar operation twice within a fixed period of time, the retrieval times will significantly differ ):

Collectives™ on Stack Overflow

Timing Django DB Queries

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related