If you need to monitor the result set of a certain SQL statement that you run regularly, use a virtual view. Virtual view lets you have the result set available in the Database tool window, and that data will not be stored in the database.
For a virtual view, apart from SELECT queries, you can also use statements like
show processlist for MySQL or
exec sp_who2 for Microsoft SQL Server.
For example, to have a list of current database connections for a PostgreSQL database, create a virtual view with the following query:
The virtual view with the result set of your query will be available in the Database tool window as a virtual object.
Create a virtual view
In the Database tool window ( ) , expand the data source tree until the nodes of schemas.
Right-click the schema node and select.
In the dialog that opens, enter the name of your virtual view in the Name field.
Type your SQL statement in the Query field.
The statement is saved in external-data.xml. You can select another name for the XML file and other place to store this file. To change or see the path to the XML document, open data source settings by pressing Command I, click the Options tab and see the Virtual objects and attributes field.