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

From Rodrigo Ramírez Norambuena
Subject Re: [PATCH] Connection time for \conninfo
Date
Msg-id CAE9kuxMrQYbAfxB=8kNfkbLvfzuEGrNc2_7S-wk3kq+PDtiTRw@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Connection time for \conninfo  (Michael Paquier <michael@paquier.xyz>)
Responses Re: [PATCH] Connection time for \conninfo
List pgsql-hackers
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/



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: range_agg
Next
From: Rodrigo Ramírez Norambuena
Date:
Subject: Re: [PATCH] Connection time for \conninfo