Query Manager
Table of contents
Overview
Query Manager is a view that shows the history of all SQL queries that DBeaver has executed during the current session.
Note: DBeaver saves query history after restarting only in Lite, Enterprise, Ultimate and Team editions.**
To open the Query Manager, do one of the following:
Click the arrow next to the Transaction Log button in the toolbar and then click Query Manager on the dropdown menu:
On the Window menu, click Show View -> Query Manager:
The Query Manager logs all queries together with their execution statistics (execution time, duration, number of fetched/updated rows, errors, etc.):
You can modify the look of the Query Manager by filtering queries and setting the number of entries displayed per page, as well as specifying some storage settings. See the ‘Query Manager Properties’ section below.
To erase all entries from the Query Manager, click the Clear query manager log button () in the view`s toolbar. In DBeaver PRO versions, you can also open Help —> Clear History in the main menu and select Query log history option. The query history will disappear after the restart.
Query Manager Properties
To manage the look of the Query Manager, filter the entries, and modify the storage settings, click the Set query manager filter button () in the view`s toolbar. The Properties for Query Manager window opens:
- Select or clear the checkboxes in the Object Types section to filter entries by object type. To filter entries by query type, select clear the checkboxes in the Query Types section.
- To change the max number of entries displayed, enter the new number in the Max number of records to show field.
- To set DBeaver to save the query log in a file, select the Save log to file(s) checkbox and then specify the file location in the Log files folder field.
After you make all necessary changes to the settings, click Apply to apply the changes and keep the window open or click Apply and Close to apply the changes and close the window. To discard all changes and return to the previous state, click Restore Defaults.