Re: [PATCH] Connection time for \conninfo - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [PATCH] Connection time for \conninfo
Date
Msg-id 20190904030604.GA2170@paquier.xyz
Whole thread Raw
In response to [PATCH] Connection time for \conninfo  (Rodrigo Ramírez Norambuena <decipher.hk@gmail.com>)
Responses Re: [PATCH] Connection time for \conninfo
Re: [PATCH] Connection time for \conninfo
List pgsql-hackers
On Tue, Sep 03, 2019 at 10:13:57PM -0400, Rodrigo Ramírez Norambuena wrote:
> I've work in the a little patch to add into the \conninfo of psql
> command the connection time  against a server backend
>
> Maybe could add after, the precheck to if the connection is alive.
> I've take first look to the pqPacketSend, my idea is send a ECHO
> packet over to the database connection. If someone has a better idea
> it would be great to know.

You can do basically the same thing by looking at
pg_stat_activity.backend_start and compare it with the clock
timestamp.  Doing it at SQL level the way you want has also the
advantage to offer you a modular format output.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Rodrigo Ramírez Norambuena
Date:
Subject: [PATCH] Connection time for \conninfo
Next
From: Masahiko Sawada
Date:
Subject: Re: [HACKERS] Transactions involving multiple postgres foreignservers, take 2