Execution time of query in mysql workbench

Does anyone know how to display the execution time of a query in mysql workbench? I'm running version 5.2.45 and I don't see the time taken to execute the query anywhere! What mysteries!

+3


source to share


3 answers


When the request is run, the server response is displayed in the output area below the editor / result set grid. There is a switch to toggle between the different parts, so make sure you select Action Output. In this grid, you can see if the request succeeded or failed when it ran, the request body, the server response, and the request time (request execution time and time to retrieve data).



As it turns out, sometimes the bottom area can be "lost", meaning it is no longer displayed despite the fact that the toggle on the toolbar shows "Action Output". In this case, it is very likely that the splitter that hosts the action output, as well as the editor and the right sidebar, got into a state where it dumped the bottom. Try moving your mouse pointer slowly below the bottom tab ("Output 2") until it changes to a split cursor. Then drag the splitter to make the bottom part visible. I've also seen (mostly on Mac) that the cursor doesn't change, but can pull the splitter.

+3


source


When you run a query in the workbench. The Ouput panel will be displayed.



There are columns in the output area (time, action, message, etc.). The rightmost column is "Duration / Fetch", which displays the duration of the execution.

0


source


Shown as Requested in time (sec.) Bottom

0


source







All Articles