Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes:
> Well, finally got this system upgraded to 8.1.8, but unfortunately, that did
> not resolve this. Is there any reasonable way to see where this function is
> spending it's time?
I've grown enamored of oprofile lately --- if you're on a recent Linux
system, try that. Solaris' DTrace is said to have equivalent
capability. On other systems you could consider plain 'ol gprof.
Any of these will require a certain amount of man-page-reading :-(
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: sufian khan||Date: 2007-04-24 07:08:28|
|Subject: Help me to decrypt password|
|Previous:||From: Jeff Frost||Date: 2007-04-24 06:18:20|
|Subject: Re: pl/pgsql function spikes CPU 100% |