On Tue, Sep 3, 2019 at 11:06 PM Michael Paquier <michael@paquier.xyz> wrote:
>
> 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.
Hi Michael,
Thanks you for paying attention, I appreciate this.
What are you say seams little trick to what I propose in this patch
because you'll need filter what is your connection, and if the
connection is through the connection pooler could be more.
The main goal this is only getting information from the client side
(psql) as frontend.
Regards!
--
Rodrigo Ramírez Norambuena
http://www.rodrigoramirez.com/