Re: [HACKERS] Time measurement format - more human readable

2014-10-02 Thread Bogdan Pilch
> On 9/29/14, 1:08 AM, Andres Freund wrote: > >On 2014-09-28 20:32:30 -0400, Gregory Smith wrote: > >>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.htm

Re: [HACKERS] Time measurement format - more human readable

2014-10-01 Thread Gregory Smith
On 9/29/14, 1:08 AM, Andres Freund wrote: On 2014-09-28 20:32:30 -0400, Gregory Smith wrote: 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-STY

Re: [HACKERS] Time measurement format - more human readable

2014-09-30 Thread Gavin Flower
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?

Re: [HACKERS] Time measurement format - more human readable

2014-09-30 Thread Bogdan Pilch
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 writes: > > On 2014-09-28 20:32:30 -0400, Gregory Smith wrote: > >> On 9/28/14, 7:49 AM, Bogdan Pilch wrote: > >>>

Re: [HACKERS] Time measurement format - more human readable

2014-09-28 Thread Tom Lane
Andres Freund 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. >> The

Re: [HACKERS] Time measurement format - more human readable

2014-09-28 Thread Andres Freund
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. > > > >The idea is to have a human r

Re: [HACKERS] Time measurement format - more human readable

2014-09-28 Thread Gregory Smith
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. The idea is to have a human readable time printed There are already a wide range of human rea

Re: [HACKERS] Time measurement format - more human readable

2014-09-28 Thread Gavin Flower
On 29/09/14 00:49, Bogdan Pilch wrote: Hi, 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. The idea is to have a human readable time printed, e.g.: Time: 1:32:15.45 m:s:ms Time: 2_10:1