On Feb 2, 2008 5:37 PM, Scott Marlowe <[EMAIL PROTECTED]> wrote: > On Feb 2, 2008 5:51 AM, Rubén Rubio <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > Im trying to disable query statistics from log, and I am unable to do > it. > > Cannot find the correct option. I have been cheking google, postgres > > documentation, i didn't found how to do it so ... I am writting here: > > > > I have my logs full of this info: > > > > [...] > > DETAIL: ! system usage stats: > > ! 0.001546 elapsed 0.001000 user 0.000000 system sec > > ! [0.097985 user 0.008998 sys total] > > ! 0/0 [0/0] filesystem blocks in/out > > ! 0/93 [0/3920] page faults/reclaims, 0 [0] swaps > > ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent > > ! 0/0 [5/11] voluntary/involuntary context switches > > ! buffer usage stats: > > ! Shared blocks: 0 read, 0 written, > buffer > > hit rate = 100.00% > > ! Local blocks: 0 read, 0 written, > buffer > > hit rate = 0.00% > > ! Direct blocks: 0 read, 0 written > > LOG: QUERY STATISTICS > > DETAIL: ! system usage stats: > > ! 0.000610 elapsed 0.000999 user 0.000000 system sec > > ! [0.098984 user 0.008998 sys total] > > ! 0/0 [0/0] filesystem blocks in/out > > ! 0/22 [0/3942] page faults/reclaims, 0 [0] swaps > > ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent > > ! 0/0 [5/12] voluntary/involuntary context switches > > ! buffer usage stats: > > ! Shared blocks: 0 read, 0 written, > buffer > > hit rate = 100.00% > > ! Local blocks: 0 read, 0 written, > buffer > > hit rate = 0.00% > > ! Direct blocks: 0 read, 0 written > > LOG: QUERY STATISTICS > > [...] > > > > How to disable this output ? Im using postgres 8.2.4 > > > > Thanks in advance! > > -- > > Ignore Linux at your own risk > > In your postgresql.conf file you've got one of these turned on: > > # - Statistics Monitoring - > > #log_parser_stats = off > #log_planner_stats = off > #log_executor_stats = off > #log_statement_stats = off > > just set it to off and reload. >
I already tried it: r3systems:~# grep log_ /home/postgres/data/postgresql.conf | grep stats log_parser_stats = off log_planner_stats = off log_executor_stats = off log_statement_stats = off and that thinks still loggin in r3systems:~# tail -n20 /home/postgres/logs/2008/02/2008-02-12_server.log ! 0/37 [0/4228] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 0/0 [3/8] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 0 read, 0 written, buffer hit rate = 100.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written LOG: QUERY STATISTICS DETAIL: ! system usage stats: ! 0.012938 elapsed 0.010998 user 0.001000 system sec ! [0.033994 user 0.018997 sys total] ! 0/0 [0/0] filesystem blocks in/out ! 0/526 [0/4754] page faults/reclaims, 0 [0] swaps ! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent ! 0/2 [4/10] voluntary/involuntary context switches ! buffer usage stats: ! Shared blocks: 0 read, 0 written, buffer hit rate = 100.00% ! Local blocks: 0 read, 0 written, buffer hit rate = 0.00% ! Direct blocks: 0 read, 0 written Any other ideas ? -- Ignore Linux at your own risk -- Ignore Linux at your own risk