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

Re: Strange slowness

From: Federico Di Gregorio <fog(at)dndg(dot)it>
To: psycopg(at)postgresql(dot)org
Subject: Re: Strange slowness
Date: 2012-05-01 09:54:20
Message-ID: 4F9FB2CC.2090600@dndg.it (view raw or flat)
Thread:
Lists: psycopg
On 30/04/12 23:29, Russ Neufeld wrote:
> Hi all,
> 
> I'm investigating some occasional slowness in our API servers, and I've
> hit upon some strange behavior that I can't explain.  I'm hoping someone
> on this list can help.

Hi Russ,

you may want to configure PostgreSQL to log connections and queries,
with execution times. Then cross-check PostgreSQL, Django and pgbouncer
logs to understand exactly where that 6 seconds are spent. I bet on
pgbouncer connecting to PostgreSQL (SSL?) but we don't have enough data
to do a proper analysis here.

federico

-- 
Federico Di Gregorio                         federico(dot)digregorio(at)dndg(dot)it
Studio Associato Di Nunzio e Di Gregorio                  http://dndg.it
             Quis custodiet ipsos custodes? -- Juvenal, Satires, VI, 347

In response to

Responses

psycopg by date

Next:From: Russ NeufeldDate: 2012-05-01 21:30:59
Subject: Re: Strange slowness
Previous:From: Daniele VarrazzoDate: 2012-04-30 21:46:36
Subject: Re: Strange slowness

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