MySQL Forums
Forum List  »  MySQL Workbench

Getting the execution time of a query
Posted by: bernard yip
Date: July 08, 2012 08:20PM


I've been searching on Google how to get the execution time but to no avail.

Is there a way or formula to get the calculation time? E.G Fetch + Duration, SHOW PROFILES and manually add them up or something like that or the only way to get the execution time is by using the MySQL Command Line Client?

P.S I'm using a Windows 7 OS, apparently I can't "pager cat > /dev/null" to prevent the output from being displayed and hiding the execution time.

I would like some advice on this as I want to benchmark different kinds of queries

P.S. Didn't read the rules, Shall answer the following questions
1) Which MySQL Workbench version do you use/did you try?
MySQL Workbench CE 5.2

2) On which operating system do you use WB?
Windows 7 Ultimate

3) If relevant: which MySQL Server version do you use and is it a local or remote machine?
MySQL Server 5.6 m8, Connected locally to it (

4) Specify the part of MySQL Workbench you have the problem with. Some features exist in several variants (like the table editor, once in modelling and once the SQL IDE).
The Output part? It shows fetch/duration but there's no report on execution time

Thank You!

Edited 1 time(s). Last edit at 07/08/2012 08:24PM by bernard yip.

Options: ReplyQuote

Written By
Getting the execution time of a query
July 08, 2012 08:20PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.