Re: [PATCH] Connection time for \conninfo
От | Rodrigo Ramírez Norambuena |
---|---|
Тема | Re: [PATCH] Connection time for \conninfo |
Дата | |
Msg-id | CAE9kuxMrQYbAfxB=8kNfkbLvfzuEGrNc2_7S-wk3kq+PDtiTRw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: [PATCH] Connection time for \conninfo (Michael Paquier <michael@paquier.xyz>) |
Ответы |
Re: [PATCH] Connection time for \conninfo
|
Список | 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 по дате отправления: