Log Viewer
| timestamp |
username |
database |
pid |
client_addr |
session_id |
session_line_num |
ps_display |
session_start |
vxid |
xid |
elevel |
sqlstate |
message |
detail |
hint |
query |
query_pos |
context |
user_query |
user_query_pos |
location |
application_name |
How to use Search Option.
To narrow down the log, enter the search criteria and click "Search" button.
- ELEVEL : error severity
- USERNAME : user name
- DATABASE : database name
- MESSAGE : error message (POSIX Regular Expressions)
How to see a Log table.
- timestamp : timestamp with milliseconds
- username : user name
- database : database name
- pid : process ID
- client_addr : client host:port number
- session_id : session ID
- session_line_num : per-session line number
- ps_display : command tag
- session_start : session start time
- vxid : virtual transaction ID
- xid : regular 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
- application_name : application name
