[pgpool-hackers: 3590] Re: [Proposal] add the process status of pgpool for extended query

[Tatsuo Ishii]

> On Thu, 16 Apr 2020 14:52:34 +0900 (JST)
> Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> Hi,
>> 
>> I have tested this patch.
> 
> Thank you for your test with patch.
>  
>> 2020-04-16 14:48:50: pid 10024: LOG:  DB node id: 0 backend pid: 10061 statement: Parse: BEGIN
>> 2020-04-16 14:48:50: pid 10024: LOG:  DB node id: 0 backend pid: 10061 statement: B message
>> 2020-04-16 14:48:50: pid 10024: LOG:  DB node id: 0 backend pid: 10061 statement: Execute: BEGIN
>> 
>> Is it possible to show the statement (in the case above "BEGIN") with B message?
> 
> Yes, Does it mean like following this?
> 
> 2020-04-23 15:32:29: pid 11300: LOG:  DB node id: 0 backend pid: 11359 statement: Parse: BEGIN
> 2020-04-23 15:32:29: pid 11300: LOG:  DB node id: 1 backend pid: 11360 statement: Parse: BEGIN
> 2020-04-23 15:32:29: pid 11300: LOG:  DB node id: 0 backend pid: 11359 statement: Bind: BEGIN
> 2020-04-23 15:32:29: pid 11300: LOG:  DB node id: 1 backend pid: 11360 statement: Bind: BEGIN
> 2020-04-23 15:32:29: pid 11300: LOG:  DB node id: 0 backend pid: 11359 statement: Execute: BEGIN
> 2020-04-23 15:32:29: pid 11300: LOG:  DB node id: 1 backend pid: 11360 statement: Execute: BEGIN
> 2020-04-23 15:32:29: pid 11300: LOG:  DB node id: 0 backend pid: 11359 statement: C message
> 2020-04-23 15:32:29: pid 11300: LOG:  DB node id: 1 backend pid: 11360 statement: C message

Yes, exactly.

> I have attached a patch with fixed above.
> 
> By the way, this log is outputed by 'log_per_node_statement' parameter.

Patch looks good.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp