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
>