On the Menu Bar choose Edit => Preferences. The Edit Preferences dialog appears.
On the General tab you can change the settings for:
Toolbar Button
The Toolbar button that runs the explain command can be set to run either an EXPLAIN or an EXPLAIN ANALYZE command. No matter which command you associate with the Toolbar button, both commands are available from the Statement menu.
ANALYZE is an EXPLAIN option. In addition to the usual EXPLAIN output, you will see:
The running time, including the total running time
The number of rows returned
The number of loops performed.
![]() | Note |
|---|---|
These extra attributes may not be shown for some nodes. This is normal behavior. |
Display Tool Tips
Tool Tips are the explanatory labels that appear when you rest the mouse cursor over a button.
Reload Query and Reconnect
This function re-establishes the most recent connection then reloads and runs the most recent SQL query when Visual Explain starts.
On the Display tab you can change the settings for:
Anti-Alias Trees
Anti-aliased graphics are more attractive, but take a little longer to display.
Use Large Icons
This setting controls the size of the icons used to display the results of the SQL query. The large icons are 48x48; the small icons are 32x32.
This setting is independent of the magnification that you can apply by using the magnification icons or drop-down magnification menu.