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