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

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 can

Re: [GENERAL] logging statements in PostgreSQL

2013-09-25 Thread Amit Langote
On Wed, Sep 25, 2013 at 12:18 PM, Jayadevan M maymala.jayade...@gmail.com 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

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,

[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