The log viewer shows the server log lines sotred in repository. This allows you to narrow down or search logs for specific events easily on GUI.
Search Options
This section determines how to restrict log lines fetched from repository. The fetched lines are shown in the Log Table below.
ELEVEL: Error message level
USERNAME: User name
DATABASE: Database name
MESSAGE: Error message (POSIX regexps for ~ operators of PostgreSQL)
The Log Table
Each row in this table shows one log line. The first row in this table is quick filter fields, which will cleared by the Filter Reset button. You can select columns to show by the "Column" button. The following is the list of all available columns.
timestamp: Timestamp
username: User name
database: Database name
pid: Process ID
client_addr: Client IP address
session_id: Session ID
session_line_num: Number of the log line for each session or process
ps_display: Command tag
session_start: Process start time stamp
vxid: Virtual transaction ID
xid: Transaction ID
elevel: Error severity
sqlstate: SQLSTATE code
message: Error message
detail: error message detail
hint: Hint
query: Internal query that led to the error
query_pos: Character count of the error position therein
context: Error context
user_query: User query that led to the error
user_query_pos: Character count of the error position therein
location: Location of the error in the PostgreSQL source code
