Re: application for postgres Log - Mailing list pgsql-general

From Albe Laurenz
Subject Re: application for postgres Log
Date
Msg-id D960CB61B694CF459DCFB4B0128514C20874B5B8@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: application for postgres Log  (Arvind Singh <arvindps@hotmail.com>)
List 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


pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Why csvlog logs contexts without leading tab?
Next
From: "Albe Laurenz"
Date:
Subject: Re: Why csvlog logs contexts without leading tab?