Re: profiling connection overhead

On Wed, Nov 24, 2010 at 01:20:36PM -0500, Robert Haas wrote:
> On Wed, Nov 24, 2010 at 1:06 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Robert Haas <robertmhaas@gmail.com> writes:
> >> OK, patch attached.
> >
> > Two comments:
>
> Revised patch attached.
>
> I tried configuring oprofile with --callgraph=10 and then running
> oprofile with -c, but it gives kooky looking output I can't interpret.
>  For example:
>
>   6        42.8571  postgres                 record_in
>   8        57.1429  postgres                 pg_perm_setlocale
> 17035     5.7219  libc-2.11.2.so           memcpy
>   17035    100.000  libc-2.11.2.so           memcpy [self]
>
> Not that helpful.  :-(

Have a look at the wiki:
http://wiki.postgresql.org/wiki/Profiling_with_OProfile#Additional_analysis

> Robert Haas

Regards, Gerhard Heift