|
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 > |
