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

[Takuma Hoshiai]

Hi,

I have attached this patch to this email.

This patch is very simple. pgpool can display kind of query in process status
when the EXECUTE message is received from frontend.

In addition, this patch will fix that log_statement support extended query.
Currently, log_statement only support a simple query.

Comments and suggestions are welcome.


Best Regards,

Takuma Hoshiai

On Thu, 17 Oct 2019 13:52:18 +0900
Takuma Hoshiai <hoshiai at sraoss.co.jp> wrote:

> Hi,
> 
> The pgpool’s prosess status display kind of query what is executing. 
> 
> e.g.
>  pgpool: hoshiai test  SELECT
>  pgpool: hoshiai test  END;
>  pgpool: hoshiai test  UPDATE
>  pgpool: hoshiai test  idle in transaction
>  pgpool: hoshiai test  idle in transaction
> 
> But it is only supported simple query now. When extended query is executed, 
> prosess status is 'idle' or 'idle in transaction' even if query is executing.
>  
> This status is incorrect and user misread status. 
> So in pgpool 4.2, I think new other status must display during extended query.
> 
> 
> Best Regards,
> 
> -- 
> Takuma Hoshiai <hoshiai at sraoss.co.jp>
> 
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers
> 


-- 
Takuma Hoshiai <hoshiai at sraoss.co.jp>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: fix_process_status.patch
Type: application/octet-stream
Size: 1111 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-hackers/attachments/20200408/85f443aa/attachment.obj>