Postgres Pro
Downloads
Home   >   mailing lists

Thread: more detailed timing ?

more detailed timing ?

From
Oleg Bartunov
Date:
Hi there,

is't possible to get timings separately for index anf heap processing,
like we get separate stats for io ?
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Re: more detailed timing ?

From
Tom Lane
Date:
Oleg Bartunov <oleg@sai.msu.su> writes:
> is't possible to get timings separately for index anf heap processing,
> like we get separate stats for io ?

gprof?
        regards, tom lane

Re: more detailed timing ?

From
Oleg Bartunov
Date:
On Wed, 23 Mar 2005, Tom Lane wrote:

> Oleg Bartunov <oleg@sai.msu.su> writes:
>> is't possible to get timings separately for index anf heap processing,
>> like we get separate stats for io ?
>
> gprof?

oh, no. I need 2 numbers only :) What's \timing in psql does ?
Or it's just a wrapper to system 'time' ?

>
>             regards, tom lane
>
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Re: more detailed timing ?

From
Neil Conway
Date:
Oleg Bartunov wrote:
> oh, no. I need 2 numbers only :) What's \timing in psql does ?
> Or it's just a wrapper to system 'time' ?

It computes wall-clock time via gettimeofday(), and is entirely 
implemented on the client-side.

-Neil