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.digregorio@dndg.it
Studio Associato Di Nunzio e Di Gregorio http://dndg.it
Quis custodiet ipsos custodes? -- Juvenal, Satires, VI, 347
