Getting the execution time of a query

[bernard yip]

Hi,

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 (127.0.0.1)

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.