id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 28574,Add a QuerySet.explain() method,Tom Forbes,Tom Forbes,"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. ",New feature,closed,"Database layer (models, ORM)",dev,Normal,fixed,,Tom Forbes,Ready for checkin,1,0,0,0,0,0