Output and Results

Show timestamp for query output

Show timestamps for query output. By default, timestamps are hidden.

• Enabled

  

• Disabled

  

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.

The following screenshot shows the results when the checkbox is selected.

When the checkbox is cleared, the results are in the Services tool window.

Create title for results from comment before query

You can define 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.

To disable this feature, open settings Ctrl+Alt+S, navigate to Tools | Database | Query Execution | Output and Results, and clear the Create title for results from comment before query checkbox.

Open settings by pressing Ctrl+Alt+S, navigate to Tools | Database | Query Execution | Output and Results.

In the Treat text as title after field, define a combination for tab titles.

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

Switch focus to the Services tool window if the View Mode is set to Window.

If this setting is off with 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.

The following animation shows the IDE behavior when the setting is enabled.

To set window mode for the tool window, right-click the tool window tab and select View Mode | Window.

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 IntelliJ IDEA 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.