Re: profiling plpgsql functions..

Yep timeofday returns text , but is there anything else
that equivalant that can be differenced inside plpgsql
so that i can print the not of secs/millisecs connsumed?

hmm shud i cast timeofday to timestamp and use timestamp
arithmatic ?

regds
mallah.

> Rajesh Kumar Mallah <mallah(at)trade-india(dot)com> writes:
>> Is printing timeofday() at various points a good idea
>> of profiling plpgsql functions?
>
> Sure.
>
>> also is anything wrong with following fragment ?
>> RAISE INFO '' % , message here ... '' , timeofday() ;
>
> IIRC, RAISE is pretty slovenly implemented :-( ... it will only take plain variable references
> as additional arguments. So you'll have to do
>
> var := timeofday();
> RAISE INFO ''... '', var;
>
> I believe timeofday() produces TEXT, so declare the var that way.
>
> regards, tom lane

-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/