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
signature.asc
Description: PGP signature
