Re: Time measurement format - more human readable

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: Bogdan Pilch <bogdan(at)matfyz(dot)cz>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, Gregory Smith <gregsmithpgsql(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Time measurement format - more human readable
Date: 2014-09-30 20:38:54
Message-ID: 542B14DE.7070208@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Please don't top post, initial context is important, especially Tom's! :-)
(see my reply below)

On 01/10/14 03:52, Bogdan Pilch wrote:
> How about, the format of psql duration can be set via some ...
> backslash command or commdn line switch? And the default of course
> remains the current behavior?
>
> bogdan
>> 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
>
As a user, your suggestion is fine by me.

Cheers,
Gavin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Geoghegan 2014-09-30 20:42:11 Re: libpq-dev: pg_config_manual.h redefines CACHE_LINE_SIZE
Previous Message Christoph Berg 2014-09-30 19:57:56 libpq-dev: pg_config_manual.h redefines CACHE_LINE_SIZE