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@trade-india.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/