Output and Results

Show timestamp for query output

Show timestamps for query output in the Output tab of the Database Output tool window. By default, timestamps are hidden.

For more information about the tab and its controls, refer to Output tab and the tab reference info.

Enable DBMS_OUTPUT

Enables DBMS_OUTPUT by default for new sessions. Applicable to Oracle and IBM Db2 LUW only.

Show results in

Specifies where query output and results are displayed.

• Editor: In code editor under the query.

• Services tool window: In the Services tool window.

• Database Output tool window: In the Database Output tool window.

For more information about query consoles and tool windows, refer to Query consoles, Database Output tool window, and Services tool window.

Open tool window after query execution

Selects which types of output automatically open the Database Output tool window after query execution.

• All output: any output that is generated appear in the 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)

• 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.

• 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.

• Result sets: when the result set is received. For example, when you run SELECT * from table_name.

• Never: never display the Database Output tool window.

Move focus to the tool window in window mode

After running a statement, switch focus to the 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 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.

Activate the output pane only for the selected file

Keep the selected query console or file selected in the session client dropdown in the Database Output tool window.

If this checkbox is cleared, the query console or file that finished processing of a query will be automatically selected in the dropdown.

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 DataGrip finishes the INSERT statement from console_1, the IDE displays the output pane of console_1 in the Database Output 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 Database Output tool window, the focus stays on console though console_1 finished query execution earlier.

• Disabled

  In the Database Output 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.

Result title marker in comments

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.

For more information about custom titles for query result tabs, refer to Use custom titles for tabs with results.

Open new Services tab for sessions

Create a new tab for a data source sessions and output results.

• Enabled

  

• Disabled

  

Show internal session in Services tool window

Shows the introspection and other internal sessions on the session list.