MySQL Bugs: #19812: EXPLAIN: add option that causes the statement to be actually executed

Bug #19812	EXPLAIN: add option that causes the statement to be actually executed
Submitted:	15 May 2006 9:23	Modified:	15 May 2006 20:07
Reporter:	Lukas Smith	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S4 (Feature request)
Version:	irrelevant	OS:	Any (irrelevant)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
it would be nice to have an option to execute the statement and get actual run time information from EXPLAIN.

How to repeat:
http://www.postgresql.org/docs/8.1/static/sql-explain.html

Thank you for a reasonable feature request. Some way to get real number of rows read from each table and time spent getting them will be useful. Not sure that PostgreSQL idea is a best one, though. Something like Oracle's extended SQL_TRACE/tkprof looks like a more reasonable (and more likely to be implemented) way for me.