Output and Results

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 and Output tab controls.

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.

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

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