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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Russ Neufeld | 2012-05-01 21:30:59 | Re: Strange slowness |
Previous Message | Daniele Varrazzo | 2012-04-30 21:46:36 | Re: Strange slowness |