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@pgmasters.net