Re: Re: query logging of prepared statements - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: Re: query logging of prepared statements
Date
Msg-id 20190320132833.GB2952@telsasoft.com
Whole thread Raw
In response to Re: Re: query logging of prepared statements  (David Steele <david@pgmasters.net>)
List pgsql-hackers
Hi,

On Wed, Mar 20, 2019 at 02:46:00PM +0400, David Steele wrote:
> >I perfectly understand your use case. I agree, it is duplicated. But I
> >think some people may want to see it at every EXECUTE, if they don't want
> >to grep for the prepared statement body which was logged earlier.
> >
> >I think it would be good to give possibility to configure this behavior.
> >At first version of your patch you relied on log_error_verbosity GUC. I'm
> >not sure that this variables is suitable for configuring visibility of
> >prepared statement body in logs, because it sets more general behavior.
> >Maybe it would be better to introduce some new GUC variable if the
> >community don't mind.
>
> Thoughts on this?

I'm happy to make the behavior configurable, but I'm having trouble believing
many people would want a GUC added for this.  But I'd be interested to hear
input on whether it should be configurable, or whether the original "verbose"
logging is desirable to anyone.

This is mostly tangential, but since writing the original patch, I considered
the possibility of a logging GUC which is scales better than log_* booleans:
https://www.postgresql.org/message-id/20190316122422.GR6030%40telsasoft.com
If that idea were desirable, there could be a logging_bit to enable verbose
logging of prepared statements.

Justin


pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Add exclusive backup deprecation notes to documentation
Next
From: Magnus Hagander
Date:
Subject: Re: Add exclusive backup deprecation notes to documentation