Views.py tweaked to use friendlier "EXPLAIN QUERY PLAN" with sqlite3

Signed-off-by: Rob Hudson <rob@cogit8.org>

1 files changed, 9 insertions, 1 deletions

diff --git a/debug_toolbar/views.py b/debug_toolbar/views.py
index 5a412af..42d3f91 100644
--- a/debug_toolbar/views.py
+++ b/debug_toolbar/views.py
@@ -77,7 +77,15 @@ def sql_explain(request):
     if sql.lower().strip().startswith('select'):
         params = simplejson.loads(params)
         cursor = connection.cursor()
-        cursor.execute("EXPLAIN %s" % (sql,), params)
+
+        if settings.DATABASE_ENGINE == "sqlite3":
+            # SQLite's EXPLAIN dumps the low-level opcodes generated for a query;
+            # EXPLAIN QUERY PLAN dumps a more human-readable summary
+            # See http://www.sqlite.org/lang_explain.html for details
+            cursor.execute("EXPLAIN QUERY PLAN %s" % (sql,), params)
+        else:
+            cursor.execute("EXPLAIN %s" % (sql,), params)
+
         headers = [d[0] for d in cursor.description]
         result = cursor.fetchall()
         cursor.close()