Re: [GENERAL] logging statements in PostgreSQL

2013-10-01 Thread Jayadevan M
Hi, I was looking for options to make sure SQLs executed as part of functions also get logged. Since this is a production system, I wanted to do it without the EXPLAIN also written to the logs. May be that is not possible? Regards, Jayadevan On Mon, Sep 30, 2013 at 5:08 PM, Albe Laurenz wrote: >

Re: [GENERAL] logging statements in PostgreSQL

2013-09-30 Thread Albe Laurenz
Jayadevan M wrote: > Thanks for the pointer. I do not really want to log the plans of queries, > just the queries, execution > time and a couple of other details (database,user). If I use the auto-explain > module, it will end up > printing the plan for all query execution in the log files? You

Re: [GENERAL] logging statements in PostgreSQL

2013-09-25 Thread Jayadevan M
Thanks for the pointer. I do not really want to log the plans of queries, just the queries, execution time and a couple of other details (database,user). If I use the auto-explain module, it will end up printing the plan for all query execution in the log files? On Wed, Sep 25, 2013 at 1:43 PM, A

Re: [GENERAL] logging statements in PostgreSQL

2013-09-25 Thread Amit Langote
On Wed, Sep 25, 2013 at 12:18 PM, Jayadevan M wrote: > Hi all, > I am planning to use pgbadger for analyzing queries. Documentation for > pgbadger says "Do not enable log_statement as their log format will not be > parsed by pgBadger. " > I have > log_min_duration_statement = 0 > I do see quite a

[GENERAL] logging statements in PostgreSQL

2013-09-24 Thread Jayadevan M
Hi all, I am planning to use pgbadger for analyzing queries. Documentation for pgbadger says "Do not enable log_statement as their log format will not be parsed by pgBadger. " I have log_min_duration_statement = 0 I do see quite a few SELECTs, INSERTS etc in the log files, function calls too, for e