Online Documentation for SQL Manager for PostgreSQL

Viewing Logfile

The Connections tab of the Server Status viewer lists server log files, if configured in postgresql.conf (redirect_stderr = true, log_destination='stderr' and log_filename='postgresql-%Y-%m-%d_%H%M%S.log'). SQL Manager will also extract a time stamp from the logfile in a separate column, if the log_line_prefix is configured accordingly.

Note: This tab is only available for running PostgreSQL server version 8.1 or higher.

The list displays the log entries as a grid with the following columns: Time, Level, Entry. If more convenient, you can change the order of the columns by dragging their headers horizontally.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

Right-click an item within the list to call the context menu allowing you to refresh the list or rotate the selected log (i.e. start logging to a new log file).

Log management tools are also available through the Navigation bar of the Server Status viewer. Using the Navigation bar you can also set the Refresh Rate for the Logfile list, or filter the list by a time stamp using the Log Date drop-down list.

If necessary, you can configure Log Options using the corresponding item of the Navigation bar.

Select the Enable SQL logging parameter (log_statement) option and specify which SQL statements will be logged:

none (don't log SQL statements)

DDL (logs all data definition commands)

mod (logs all DDL and data-modifying statements: INSERT, UPDATE, DELETE, etc.)

all (logs all SQL statements)