Re: [PATCH] Connection time for \conninfo

Hi Rodrigo,

On 2/27/20 4:21 AM, Peter Eisentraut wrote:
> My opinion is that this is not particularly useful and not appropriate
> to piggy-back onto \conninfo.  Connection information including host,
> port, database, user name is a well-established concept in PostgreSQL
> programs and tools and it contains a delimited set of information.
> Knowing what server and what database you are connected to also seems
> kind of important.  Moreover, this is information that is under control
> of the client, so it must be tracked on the client side.
>
> Knowing how long you've been connected on the other hand seems kind of
> fundamentally unimportant.  If we add that, what's to stop us from
> adding other statistics of minor interest such as how many commands
> you've run, how many errors there were, etc.  The connection time is
> already available, and perhaps we should indeed make it a bit easier to
> get, but it doesn't need to be a psql command.

The consensus from the committers (with the exception of Álvaro) seems
to be that this is not a feature we want. FWIW, I agree with the majority.

I'll mark this as rejected on MAR-16 unless Álvaro makes an argument for
committing it.

Regards,
--
-David
david(at)pgmasters(dot)net