diff options
Diffstat (limited to 'debug_toolbar/management/commands')
| -rw-r--r-- | debug_toolbar/management/commands/debugsqlshell.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/debug_toolbar/management/commands/debugsqlshell.py b/debug_toolbar/management/commands/debugsqlshell.py index 71723fa..8878d25 100644 --- a/debug_toolbar/management/commands/debugsqlshell.py +++ b/debug_toolbar/management/commands/debugsqlshell.py @@ -1,5 +1,6 @@ import os from optparse import make_option +from datetime import datetime from django.db.backends import util from django.core.management.commands.shell import Command @@ -8,11 +9,15 @@ from debug_toolbar.utils import sqlparse class PrintQueryWrapper(util.CursorDebugWrapper): def execute(self, sql, params=()): + starttime = datetime.now() try: return self.cursor.execute(sql, params) finally: raw_sql = self.db.ops.last_executed_query(self.cursor, sql, params) + execution_time = datetime.now() - starttime print sqlparse.format(raw_sql, reindent=True) print + print 'Execution time: %fs' % execution_time.total_seconds() + print util.CursorDebugWrapper = PrintQueryWrapper |