Re: application for postgres Log

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Arvind Singh *EXTERN*" <arvindps(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: application for postgres Log
Date: 2012-09-21 10:17:51
Message-ID: D960CB61B694CF459DCFB4B0128514C20874B5B8@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arvind Singh wrote:
> 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",""

You get that if log_statement='all'

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

You get that if log_duration=on or log_min_duration_statement=0

> 2011-11-11 12:41:31.484
IST,"agent1","pem",524,"localhost:2141",4ebccaa2.20c,756,"INSERT",2011-1
1-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",""

You get that if log_statement_stats=on

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

Yes, as indicated above, during this session these options must have
been enabled.

I wouldn't worry about it.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-09-21 10:25:09 Re: Why csvlog logs contexts without leading tab?
Previous Message hubert depesz lubaczewski 2012-09-21 09:56:28 Re: Why csvlog logs contexts without leading tab?