From: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com> |
---|---|
To: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
Cc: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: \timing interval |
Date: | 2016-07-13 18:06:20 |
Message-ID: | CADkLM=eWXqyg9hMQU2BaND4RS+FG2=oNEjXq7bcG3qJSe4afmA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
Attachment | Content-Type | Size |
---|---|---|
0001-print-timing-verbose.diff | text/plain | 1.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2016-07-13 18:10:59 | Re: rethinking dense_alloc (HashJoin) as a memory context |
Previous Message | Tom Lane | 2016-07-13 17:56:00 | Re: rethinking dense_alloc (HashJoin) as a memory context |