# Output and Results

> **TL;DR**
> Open settings by pressing `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) 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](query-consoles.html). For more information about viewing query results, refer to [Query results](viewing-query-results.html).

## 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.        For more information about the tab and its controls, refer to  [Output tab](viewing-query-results.html#output_tab) and [the tab reference info](services-tool-window.html#db_output_tab).     |
| Enable DBMS_OUTPUT |  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 in query consoles](viewing-query-results.html#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.       For more information about custom titles for query result tabs, refer to  [Use custom titles for tabs with results](viewing-query-results.html#use-custom-titles-for-tabs-with-results).     |

## Services Tool Window

| Item | Description |
| --- | --- |
| 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](https://www.postgresql.org/docs/9.1/plpgsql-errors-and-messages.html) or [DBMS_OUTPUT in Oracle](https://docs.oracle.com/database/121/ARPLS/d_output.htm#ARPLS036).    * 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](viewing-modes.html#window) topic.     |
| Open new Services tab for sessions | Create a new tab for a data source sessions and output results.       * Enabled ![Open new services tab for sessions is on](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_open_new_services_tab_for_sessions_on.png)    * Disabled ![Open new services tab for sessions is off](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_open_new_services_tab_for_sessions_off.png)    |
|  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. [Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_settings_activate_services_output_pane_enabled.mp4)    * 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. [Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_settings_activate_services_output_pane_disabled.mp4)    |
|  Show internal session in Services tool window  |  Shows the introspection and other internal sessions on the session list.  |

