Re: \timing interval - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: \timing interval
Date
Msg-id 871t327feo.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: \timing interval  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: \timing interval  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: \timing interval  (Corey Huinker <corey.huinker@gmail.com>)
Re: \timing interval  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: \timing interval  (Gavin Flower <GavinFlower@archidevsys.co.nz>)
Re: \timing interval  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
> Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:>> I'm not quite sure what you mean by wanting to do
arithmeticon the >> numbers.  My phrasing of the problem is that after a long query, you >> might get output like
this:>>Time: 1234567.666 ms>> which is pretty useless.
 
Tom> What I mean by that is that not infrequently, I'll run the sameTom> query several times and then want to average
theresults.  That'sTom> easy with awk or similar scripts as long as the numbers are inTom> straight decimal.
 
Tom> I don't mind if we provide a way to print in Babylonian-inspiredTom> notation(s) as well, but I'm going to be
seriouslyannoyed ifTom> that's the only way to get the output.
 

How about

Time: 1234567.666 ms (20m 34.6s)

?

-- 
Andrew (irc:RhodiumToad)



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: \timing interval
Next
From: Tom Lane
Date:
Subject: Re: \timing interval