[pgpool-hackers: 2824] Re: Proposal: Add last state change timestamp to "show pool_nodes"

[Bo Peng]

Hi Ishii-san,

I think this will be useful to show the last state change timestamp.

On Mon, 11 Jun 2018 16:23:12 +0900 (JST)
Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> Hi,
> 
> I would like to propose to enhance "show pool_nodes" so that it shows
> the last state change time. Here "state change" means
> unused/connect_wait/up/down/quarantine.
> 
> When pgpool-II starts, the timestamp is set to time the startup
> time. After that whenever the status is changed, time timestamp is
> recorded and shown.
> 
> This is particularly useful when failover happens and need to find out
> the cause in the pgpool log since now we can use the timestamp of down
> status in show pool_nodes.
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> _______________________________________________
> pgpool-hackers mailing list
> pgpool-hackers at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-hackers
> 


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan