Server Output
Table of contents
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) orSET
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
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.