Posted By

jonhenshaw on 04/07/08


debug template query

Versions (?)

Who likes this?

1 person have marked this snippet as a favorite


Template Query Debug

 / Published in: Django


I often find something like this lurking at the end of my base templates - it'll show you which queries were run while generating the current page, but they'll start out hidden so as not to be a pain.

Of course, before this works, you'll need to satisfy all the criteria for getting debug information in your template context:

  1. Have 'django.core.contextprocessors.debug' in your TEMPLATECONTEXT_PROCESSORS setting (it was there in the default settings, last time I checked).
  2. Have your current IP in your INTERNAL_IPS setting.
  3. Use RequestContext when rendering the current template (if you're using a generic view, you're already using RequestContext).
  1. {% if debug %}
  2. Queries
  4. {{ sql_queries|length }} Quer{{ sql_queries|pluralize:"y,ies" }} {% ifnotequal sql_queries|length 0 %} (Show) {% endifnotequal %}
  5. {% for query in sql_queries %}{% endfor %}
  6. # SQL Time
  7. {{ forloop.counter }} {{ query.sql|escape }} {{ query.time }}
  8. {% endif %}

Report this snippet  


RSS Icon Subscribe to comments
Posted By: on September 16, 2018

15 best root apps for android without pc view website

Posted By: on October 30, 2018

the 8 best insignia portable bluetooth speaker instructions view website

You need to login to post a comment.