Re: Slow Query Help

Clients are technically our pgbouncer which is on the same machine. The explain analyze was local through psql direct to postgresql.

On Wednesday, February 6, 2013 at 11:22 AM, Kevin Grittner wrote:

> Will Platnick <wplatnick(at)gmail(dot)com (mailto:wplatnick(at)gmail(dot)com)> wrote:
> > Will Platnick <wplatnick(at)gmail(dot)com (mailto:wplatnick(at)gmail(dot)com)> wrote:
>
>
> > > The only thing that stands out is: on your production server I see
> > > "Total runtime: 7.515 ms", but the top node in EXPLAIN ANAYZE shows
> > > actual time as 0.179 ms. Not sure where that additional time is being
> > > spent though. It could be ExecutorStart/End, but have no idea why they
> > > should take so long.
> > >
> >
>
>
> > Any ideas on how to troubleshoot this delay?
>
> Is the client which is running the query on the same machine as the
> server? If not, what's the ping time between them?
>
> -Kevin