Bruce Momjian <br...@momjian.us> writes:

> On Sat, May 27, 2023 at 09:34:37PM -0400, Bruce Momjian wrote:
>> > > This is controlled by auto_explain.log_parameter_max_length, and by
>> > > default query parameters will be logged with no length
>> > > restriction. SHOULD THIS BE MORE CLEARLY IDENTIFIED AS CONTROLLING THE
>> > > EXECUTION OF PREPARED STATEMENTS?
>> > 
>> > This is wrong, the logging applies to all query parameters, not just for
>> > prepared statements (and has nothing to do with controlling the
>> > execution thereof).  That was just the only way to test it when it was
>> > written, because psql's \bind command exist yet then.
>> 
>> I see your point.  How is this?
>> 
>>      Allow auto_explain to log query parameters used by parameterized
>>      statements (Dagfinn Ilmari Mannsåker)
>> 
>>      This affects queries using server-side PRAPARE/EXECUTE
>>      and client-side parse/bind.  Logging is controlled by
>>      auto_explain.log_parameter_max_length;  by default query
>>      parameters will be logged with no length restriction.
>
> Done, attached patch applied.

That works for me. Thanks!

- ilmari


Reply via email to