Login

Output sql_queries in Firebug console when in debug mode

Author:
wojas
Posted:
March 18, 2010
Language:
HTML/template
Version:
Not specified
Tags:
sql debug console firebug sql_queries
Score:
5 (after 5 ratings)

Add this code to the end of the <body> of your main template and it will print out all your SQL queries with timings in the Firebug console.

This uses the "django.core.context_processors.debug" template context processor, which requires that DEBUG=True and that your IP address is listed in INTERNAL_IPS.

1
2
3
4
5
6
7
{% if debug %}
<script type="text/javascript">
  {% for q in sql_queries %}
    console.debug("({{ q.time }}s)", "{{ q.sql|escapejs }}");
  {% endfor %}
</script> 
{% endif %}

More like this

  1. SQL Log To Console Middleware by davepeck 5 years, 11 months ago
  2. Middleware for printing of exception to console by dballanc 7 years, 10 months ago
  3. Debug SQL Query in Template by dario.agliottone 3 years, 2 months ago
  4. SQL Printing Middleware by ericflo 8 years, 1 month ago
  5. DebugFooter middleware by simon 7 years, 2 months ago

Comments

Please login first before commenting.