Re: profiling connection overhead

From: Gerhard Heift <ml-postgresql-20081012-3518(at)gheift(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: profiling connection overhead
Date: 2010-11-24 18:47:13
Message-ID: 20101124184713.GA1698@gheift
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > Robert Haas <robertmhaas(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-11-24 19:30:47 Re: profiling connection overhead
Previous Message Maciek Sakrejda 2010-11-24 18:25:27 Re: [JDBC] JDBC and Binary protocol error, for some statements