Changeset 218

Timestamp:

07/19/05 14:55:31 (3 years ago)

Author:

adrian

Message:

Added 'How can I see the raw SQL queries Django is running?' to the FAQ

Files:

• django/trunk/docs/faq.txt (modified) (1 diff)

django/trunk/docs/faq.txt

@@ -223 +223 @@
-if you're attached to ZPT, Cheetah, or whatever, feel free to use those.
-
+The database API
+================
+
+How can I see the raw SQL queries Django is running?
+----------------------------------------------------
+
+Make sure your Django ``DEBUG`` setting is set to ``True``. Then, just do
+this::
+
+    >>> from django.core.db import db
+    >>> db.queries
+    [{'sql': 'SELECT polls_polls.id,polls_polls.question,polls_polls.pub_date FROM polls_polls',
+    'time': '0.002'}]
+
+``db.queries`` is only available if ``DEBUG`` is ``True``. It's a list of
+dictionaries in order of query execution. Each dictionary has the following::
+
+    ``sql`` -- The raw SQL statement
+    ``time`` -- How long the statement took to execute, in seconds.
+
-The admin site
-==============