Bruce Momjian <bruce@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