# postgresql日志中出现system usage stats信息的解决

猪猪侠|ZZXia

已于 2023-06-08 21:21:13 修改

阅读量220

点赞数

分类专栏： IT 文章标签： postgresql 数据库

于 2023-01-13 14:43:35 首次发布

本文链接：https://blog.youkuaiyun.com/zhf_sy/article/details/128674066

版权

IT 专栏收录该内容

71 篇文章

订阅专栏

文章讲述了在PostgreSQL数据库日志中出现systemusagestats信息的现象，这些信息是由于log_statement_stats配置开启导致的系统性能统计。解决方案是关闭postgresql.conf配置文件中的log_statement_stats选项，或者同时确保log_parser_stats、log_planner_stats、log_executor_stats均为off状态。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

postgresql日志中出现system usage stats信息的解决

文章目录

postgresql日志中出现system usage stats信息的解决

1 现象

日志内容如下：

2023-01-13 08:27:00.133 +07,"policy","policy",18883,"192.168.11.74:59936",63c0b21d.49c3,2637,"BIND",2023-01-13 08:21:33 +07,112/29583,0,LOG,00000,"BIND MESSAGE STATISTICS","! system usage stats:
!       0.000000 s user, 0.000049 s system, 0.000081 s elapsed
!       [1.071016 s user, 0.084978 s system total]
!       29060 kB max resident size
!       0/0 [0/0] filesystem blocks in/out
!       0/0 [0/7396] page faults/reclaims, 0 [0] swaps
!       0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
!       0/1 [660/892] voluntary/involuntary context switches",,,,,"select ""public"".""policy"".""policy_id"", ""public"".""policy"".""policy_no"", ""public"".""policy"".""apply_id"", ""public"".""policy"".""apply_no"", ""public"".""policy"".""accept_branch_id"", ""public"".""policy"".""sales_branch_id"",  ""public"".""policy"".""contract_end_date"" from ""public"".""policy"" where ""public"".""policy"".""policy_id"" = $1",,,"PostgreSQL JDBC Driver","client backend",,0
2023-01-13 08:27:00.133 +07,"policy","policy",18883,"192.168.11.74:59936",63c0b21d.49c3,2638,"SELECT",2023-01-13 08:21:33 +07,112/29583,0,LOG,00000,"duration: 0.057 ms",,,,,,,,,"PostgreSQL JDBC Driver","client backend",,0
2023-01-13 08:27:00.133 +07,"policy","policy",18883,"192.168.11.74:59936",63c0b21d.49c3,2639,"SELECT",2023-01-13 08:21:33 +07,112/29583,0,LOG,00000,"EXECUTE MESSAGE STATISTICS","! system usage stats:
!       0.000065 s user, 0.000006 s system, 0.000096 s elapsed
!       [1.071081 s user, 0.085038 s system total]
!       29060 kB max resident size
!       0/0 [0/0] filesystem blocks in/out
!       0/0 [0/7396] page faults/reclaims, 0 [0] swaps
!       0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
!       0/1 [660/894] voluntary/involuntary context switches",,,,,"select ""public"".""policy"".""policy_id"", ""public"".""policy"".""policy_no"", ""public"".""policy"".""apply_id"", ""public"".""policy"".""apply_no"", ""public"".""policy"".""accept_branch_id"", ""public"".""policy"".""sales_branch_id"",  ""public"".""policy"".""contract_end_date"" from ""public"".""policy"" where ""public"".""policy"".""policy_id"" = $1",,,"PostgreSQL JDBC Driver","client backend",,0

这种东西一般没啥用，不想看见他

2 原因与解决办法

显示上面的日志是因为在postgresql.conf中开启了以下选项中的一项或几项：

#log_parser_stats = off
#log_planner_stats = off
#log_executor_stats = off
#log_statement_stats = off       # 向日志中写入系统性能统计信息（system usage stats及context switches的SQL语句）。此参数on时，这些参数（log_parser_stats 、log_planner_stats、log_executor_stats）必须设置为off