Re: \timing interval

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: \timing interval
Дата
Msg-id 871t327feo.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: \timing interval  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: \timing interval
Следующее
От: Tom Lane
Дата:
Сообщение: Re: \timing interval