more detailed timing ?

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

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

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