Re: [PATCH] Connection time for \conninfo

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Rodrigo Ramírez Norambuena <decipher(dot)hk(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [PATCH] Connection time for \conninfo
Date: 2020-02-27 09:21:52
Message-ID: 73183667-45ae-31b4-c973-9885a29177c0@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2020-02-27 09:43:50 Re: [Proposal] Level4 Warnings show many shadow vars
Previous Message Peter Eisentraut 2020-02-27 09:10:57 Re: vacuum verbose detail logs are unclear; log at *start* of each stage