Re: [HACKERS] mysterious log output

2005-03-01 Thread Bruce Momjian
Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: I keep seeing the following log output around every 5 minutes: 2005-02-28 23:25:05 [8646] LOG: 0: QUERY STATISTICS This has to be coming from exec_simple_query(): if (save_log_statement_stats)

Re: [HACKERS] mysterious log output

2005-03-01 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: Tom Lane wrote: This has to be coming from exec_simple_query(): I wonder if some statistics were turned on at postmaster start and even though it was turned off and 'pg_ctl reload' was done the checkpoint/bgwriter process isn't reloading for some

Re: [HACKERS] mysterious log output

2005-03-01 Thread Robert Treat
On Tuesday 01 March 2005 12:46, Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Tom Lane wrote: This has to be coming from exec_simple_query(): I wonder if some statistics were turned on at postmaster start and even though it was turned off and 'pg_ctl reload' was done the

[HACKERS] mysterious log output

2005-02-28 Thread Robert Treat
I keep seeing the following log output around every 5 minutes: 2005-02-28 23:25:05 [8646] LOG: 0: QUERY STATISTICS DETAIL: ! system usage stats: ! 0.005023 elapsed 0.00 user 0.00 system sec ! [537.13 user 44.86 sys total] ! 0/0 [0/0]

Re: [HACKERS] mysterious log output

2005-02-28 Thread Tom Lane
Robert Treat [EMAIL PROTECTED] writes: I keep seeing the following log output around every 5 minutes: 2005-02-28 23:25:05 [8646] LOG: 0: QUERY STATISTICS This has to be coming from exec_simple_query(): if (save_log_statement_stats) ShowUsage(QUERY STATISTICS); so