日志格式说明

• 复制
  复制成功

2017-10-11 16:23:55.178 CST,"pgxz","postgres",11499,"127.0.0.1:2329",59ddd50c.2ceb,1,"idle",2017-10-11 16:23:40 CST,3/26053,0,LOG,00000,"statement: select * from pg_class limit 1;",,,,,,,,,"psql"
执行时间               | 2017-10-11 16:23:55.178
用户名              | pgxz
数据库          | postgres
进程id             | 11499
客户端id        | 127.0.0.1:2329
会话 ID             | 59ddd50c.2ceb
每个会话的行号       | 1
命令标签            | idle
登录时间     | 2017-10-11 16:23:40
虚拟事务 ID| 3/26053
普通事务 ID、         | 0
级别         | LOG
SQLSTATE 代码         | 00000
执行信息                | statement: select * from pg_class limit 1;
详情                 | 
提示                   | 
导致错误的内部查询         | 
错误位置所在的字符计数              | 
错误上下文                | 
导致错误的用户查询（如果有且被log_min_error_statement启用）                 | 
错误位置所在的字符计数              | 
在 PostgreSQL 源代码中错误的位置（如果log_error_verbosity被设置为verbose）               | 
应用名       | psql
错误日志解释
2017-10-11 16:24:10.233 CST,"pgxz","postgres",11499,"127.0.0.1:2329",59ddd50c.2ceb,2,"idle",2017-10-11 16:23:40 CST,3/26054,0,LOG,00000,"statement: select * from pgxc_nodes limit 1;",,,,,,,,,"psql"
2017-10-11 16:24:10.233 CST,"pgxz","postgres",11499,"127.0.0.1:2329",59ddd50c.2ceb,3,"SELECT",2017-10-11 16:23:40 CST,3/26054,0,ERROR,42P01,"relation ""pgxc_nodes"" does not exist",,,,,,,,,"psql"