Server Output
Overview
The Server output log lets you view messages generated by database scripts and procedures directly in the SQL Editor. This feature helps debug queries, monitor script execution, and track informational or warning messages from the server.
Open server output log
Before executing scripts, enable the Server output log:
-
In the SQL Editor toolbar, click Show server output button (
).
-
Run your SQL queries or procedural scripts.
Tip
Scripts typically use statements like RAISE
(PostgreSQL) or PRINT
(SQL Server) to send these messages
to the output log. Adjust message visibility by configuring log levels with statements like SET
to show more detailed
information. For details about log message types, see your database systemās documentation.
View log messages
After executing the scripts, switch to the Output tab.
Search log messages
To quickly find a specific log type your search text into the search field at the top of the Output tab. Matching logs appear instantly.
Tip
Clear the search field to see all logs again.
Filter log messages
To simplify viewing specific message types, filter logs:
- In the Output tab toolbar, click Filter button (
).
- Select the log message types you want to display:
- Debug
- Log
- Info
- Notice
- Warning
- Error
Info
Filtering only affects displayed logs - it doesn't change what's stored or generated by your database scripts.
Wrap log messages
To wrap long log messages in the Output tab:
- In the Output tab toolbar, click the settings button (
).
- Select the Wrap mode checkbox.