Re: \timing interval

On Mon, Jul 11, 2016 at 8:35 AM, Peter Eisentraut <
peter(dot)eisentraut(at)2ndquadrant(dot)com> wrote:

> On 7/9/16 4:00 PM, Andrew Gierth wrote:
>
>> How about
>>
>> Time: 1234567.666 ms (20m 34.6s)
>>
>
> That's similar to what I had in mind, so I'd be happy with that.
>
>
> --
> Peter Eisentraut http://www.2ndQuadrant.com/
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
>

Ok, here's what I came up with (with time to test it).

If the query took less than a second, timing display is unchanged.
Otherwise, print the ms time, followed by a more human readable form
accurate to 0.001s.

# select 1; select pg_sleep(1); select pg_sleep(71); select pg_sleep
(3601); select pg_sleep(24*3601);
?column?
----------
1
(1 row)

Time: 1.575 ms
pg_sleep
----------

(1 row)

Time: 1002.568 ms (1.003s)
pg_sleep
----------

(1 row)

Time: 71041.022 ms (1m 11.041s)
pg_sleep
----------

(1 row)

Time: 3601083.544 ms (1h 0m 1.084s)
pg_sleep
----------

(1 row)

Time: 86424018.416 ms (1d 0h 0m 24.018s)

As-is, there isn't much that could be done for regression or documentation
changes, so I'll just leave this here.