Re: Time measurement format - more human readable

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andres Freund <andres(at)2ndquadrant(dot)com>
Cc: Gregory Smith <gregsmithpgsql(at)gmail(dot)com>, Bogdan Pilch <bogdan(at)matfyz(dot)cz>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Time measurement format - more human readable
Date: 2014-09-29 05:16:23
Message-ID: 19072.1411967783@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Andres Freund <andres(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2014-09-29 06:51:45 Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Previous Message Andres Freund 2014-09-29 05:08:30 Re: Time measurement format - more human readable