Horton

Re: profiling connection overhead

Gerhard Heift <ml-postgresql-20081012-3518@gheift.de>

View thread
From: Gerhard Heift <ml-postgresql-20081012-3518@gheift.de>
To: pgsql-hackers@postgresql.org
Date: 2010-11-24T18:47:13Z
Lists: pgsql-hackers 
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