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?
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 configure it so that only statements exceeding a certain duration will be logged.