Open settings by pressing CtrlAlt0S and navigate to Tools | Database | Query Execution | Output and Results. .
The settings on this page define how the query results are displayed in the Output and Results tab of Services tool window, and in the Query consoles. For more information about viewing query results, refer to Query results.
Output
Item
Description
Show timestamp for query output
Show timestamps for query output in the Output tab of the Services tool window. By default, timestamps are hidden.
Enables DBMS_OUTPUT by default for new sessions. Applicable to Oracle and IBM Db2 LUW only.
Results
Item
Description
Show results in editor
Display results of the query that you run under the query in the editor, not in the results pane of the Services tool window.
For more information about viewing results in the editor, refer to In-Editor Results.
Create title for results from comment before query
Enables the feature of defining a tab title in the comment section before the query.
In the Treat text as title after field, you can reserve a combination of symbols or characters, and any text after this combination will be treated as a tab title. By default, no combination is used, so any text after -- or /* is treated as a tab title.
Show Services tool window for query console output
Define in what situations to display the Services tool window.
For all output: any output that is generated appear in the Services tool window. That is result sets, errors in the log, query output (for example, DBMS_OUTPUT), and other log texts generated by the IDE. The IDE log texts might look as follows:
ex: [2021-06-03 14:55:34] 1 row retrieved starting from 1 in 131 ms (execution: 8 ms, fetching: 123 ms)
For query output, errors, and result sets: when the result set is received, when there are errors in the log, and for the output that users generate by issuing queries. For example, this query output may be Errors and Messages in PostgreSQL or DBMS_OUTPUT in Oracle.
For errors and result sets: when the result set is received or when there are errors in the log. Errors are usually displayed as red notifications at the bottom of the IDE.
For result sets: when the result set is received. For example, when you run SELECT * from table_name.
Never: never display the Services tool window.
Focus on Services tool window in window mode
After running a statement, switch focus to the Services tool window if its View Mode is set to Window.
If this setting is off with the View Mode set to Window, the focus will stay in the query console, and you will need to click the Services tool window to interact with it.
To set window mode for the tool window, right-click the tool window tab and select View Mode | Window.
For more information about the tool window Window view mode, refer to the Tool window view modes topic.
Open new Services tab for sessions
Create a new tab for a data source sessions and output results.
Enabled
Disabled
Activate Services output pane for selected query console only
Stay on the output pane of the selected query console in the Services tool window.
If this checkbox is cleared, the focus will switch to the node of the query console in the Services tool window that finished processing of a query.
For example, you have two query consoles: console_1 and console_2. In console_1, you have a large list of INSERT statements that is running. But you also issue some queries in the console_2. If the checkbox is cleared, each time GoLand finishes the INSERT statement from console_1, the IDE displays the output pane of console_1 in the Services tool window. If the checkbox is selected, the output pane of console_2 is shown.
Consider the following videos with pg_sleep.
Enabled
In the Services tool window, the focus stays on console though console_1 finished query execution earlier.
Disabled
In the Services tool window, the focus shifts from console to console_1 as console_1 finished query execution earlier. And then again to console because now the query is finished in this query console.
