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

Re: Problems with inconsistant query performance.

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Problems with inconsistant query performance.
Date: 2006-09-28 16:15:49
Message-ID: 20060928161549.GN34238@nasby.net (view raw or flat)
Thread:
Lists: pgsql-performance
On Thu, Sep 28, 2006 at 11:28:43AM -0400, Bill Moran wrote:
> In response to Matthew Schumacher <matt(dot)s(at)aptalaska(dot)net>:
> > 
> > What I really need is a way to profile my proc when it runs slow so that
> > I can resolve which of the queries is really slow.  Anyone with an idea
> > on how to do this?
> 
> You could turn on statement logging and duration logging.  This would
> give you a record of when things run and how long they take.  A little
> work analyzing should show you which queries are running when your
> favorite query slows down.

By default, that doesn't help you debug what's happening inside a
function, because you only get the call to the function. I don't know if
you can increase verbosity to combat that.

Something else to consider is that gettimeofday() on some platforms is
painfully slow, which could completely skew all your numbers.
-- 
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

In response to

Responses

pgsql-performance by date

Next:From: Carlo StonebanksDate: 2006-09-28 16:44:10
Subject: Performace Optimization for Dummies
Previous:From: Bill MoranDate: 2006-09-28 15:28:43
Subject: Re: Problems with inconsistant query performance.

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