Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group