Re: Time measurement format - more human readable - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Time measurement format - more human readable
Date
Msg-id 19072.1411967783@sss.pgh.pa.us
Whole thread Raw
In response to Re: Time measurement format - more human readable  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: Time measurement format - more human readable  (Bogdan Pilch <bogdan@matfyz.cz>)
List pgsql-hackers
Andres Freund <andres@2ndquadrant.com> writes:
> On 2014-09-28 20:32:30 -0400, Gregory Smith wrote:
>> On 9/28/14, 7:49 AM, Bogdan Pilch wrote:
>>> I have created a small patch to postgres source (in particular the
>>> psql part of it) that modifies the way time spent executing the SQL
>>> commands is printed out.

>> There are already a wide range of human readable time interval output
>> formats available in the database; see the list at
http://www.postgresql.org/docs/current/static/datatype-datetime.html#INTERVAL-STYLE-OUTPUT-TABLE

> He's talking about psql's \timing...

Indeed.  Still, it seems like this has more downside than upside.
It seems likely to break some peoples' scripts, and where exactly
is the groundswell of complaint that the existing format is
unreadable?  TBH, I've not heard even one complaint about that
before today.  On the other hand, the number of complaints we will
get if we change the format is likely to be more than zero.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Time measurement format - more human readable
Next
From: Heikki Linnakangas
Date:
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}