#28574: Add a Queryset.explain() method
-------------------------------------+-------------------------------------
Reporter: Tom | Owner: nobody
Type: New | Status: new
feature |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
When diagnosing slow queries it would be handy to have an `explain` method
on the queryset. Currently if you have a queryset that is performing
slowly and you want to use your databases EXPLAIN query to see why, you
have to print the querysets query attribute, copy and paste the often
verbose string into a database shell, add the appropriate explain syntax,
fix any parameters that may be missing and execute it. This can be quite
annoying.
Every database that is supported in core supports this, usually by adding
`EXPLAIN` before the query. Simply returning whatever the database gives
you (which is vastly different per vendor and even version) could be a
good improvement.
--
Ticket URL: <https://code.djangoproject.com/ticket/28574>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/046.6f1e32b72ec9472ee2ebd6827c803d6d%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
