Re: application for postgres Log

thanx Laurenz,

But

Our CSV Log contains lot of statements like the following THREE lines. They appear exactly one after the other.

And they number in thousands for a Session (more than ten thousand)


2011-11-11 12:41:31.484 IST,"agent1","pem",524,"localhost:2141",4ebccaa2.20c,754,"idle",2011-11-11 12:41:30 IST,2/308,0,LOG,00000,"statement: INSERT INTO pemdata.settings (""name"", ""setting"", ""unit"", ""server_id"") VALUES ('xmlbinary', 'base64', NULL, '1')",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:900",""

2011-11-11 12:41:31.484 IST,"agent1","pem",524,"localhost:2141",4ebccaa2.20c,755,"INSERT",2011-11-11 12:41:30 IST,2/0,0,LOG,00000,"duration: 0.000 ms",,,,,,,,"exec_simple_query, .\src\backend\tcop\postgres.c:1128",""

2011-11-11 12:41:31.484 IST,"agent1","pem",524,"localhost:2141",4ebccaa2.20c,756,"INSERT",2011-11-11 12:41:30 IST,2/0,0,LOG,00000,"QUERY STATISTICS","! system usage stats:
! 0.000000 elapsed 0.000000 user 0.000000 system sec
! [0.250000 user 0.156250 sys total]",,,,,"INSERT INTO pemdata.settings (""name"", ""setting"", ""unit"", ""server_id"") VALUES ('xmlbinary', 'base64', NULL, '1')",,"ShowUsage, .\src\backend\tcop\postgres.c:4305",""

Is there anything that we enabled, because they dont appear after that particular session.

The log file is uploaded at http://dl.dropbox.com/u/71964910/pg_log_with_lot_of_session.zip

arvind ps

> It would indeed be divine intervention if fifty thousand had
> five zeros.
>
> Other than that, I don't see anything special about that.
> A session can last pretty long.
> Maybe you can solve your mystery by looking at the log entries.
> They should tell you what was going on.
>
> > Although it never reoccurs and luckily we had csv option on during
> that period.
> >
> > Where should i report such findings
>
> I don't think there is anything wrong.
> At least nothing database related.
>
> > I have uploaded that Part of Log at
> http://dl.dropbox.com/u/71964910/pg_log_with_lot_of_session.zip
>
> That looks like somebody turned on "log_statement_stats" for a spell.
>
> Yours,
> Laurenz Albe
>