Date: Wed, 6 Feb 2013 11:24:34 -0500
From: Will Platnick <wplatnick@gmail.com>
To: "=?utf-8?Q?pgsql-performance=40postgresql.org?="
	<pgsql-performance@postgresql.org>
Message-ID: <8E8E8399C0114A19A3DB3AF966635A23@gmail.com>
In-Reply-To: <1360167760.44825.YahooMailNeo@web162901.mail.bf1.yahoo.com>
References: <ED51F03F1D2C469EB2F7FF91C677AD4F@gmail.com>
	<CABOikdPdsqgiXgq7efNCyQv6HkdFHktWAMYM0QFj8xxtBMj0Mw@mail.gmail.com>
	<2CB5B53971DB42238A7640E6EFAE8D19@gmail.com>
	<1360167760.44825.YahooMailNeo@web162901.mail.bf1.yahoo.com>
Subject: Re: Slow Query Help
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="511283c2_189a769b_1c95"
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

--511283c2_189a769b_1c95
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@gmail.com (mailto:wplatnick@gmail.com)> wrote:
> > Will Platnick <wplatnick@gmail.com (mailto:wplatnick@gmail.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 


--511283c2_189a769b_1c95
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline


                <div>Clients are technically our pgbouncer which is on th=
e same machine. The explain analyze was local through psql direct to post=
gresql.</div><div><br></div>
                =20
                <p style=3D=22color: =23A0A0A8;=22>On Wednesday, =46ebrua=
ry 6, 2013 at 11:22 AM, Kevin Grittner wrote:</p>
                <blockquote type=3D=22cite=22 style=3D=22border-left-styl=
e:solid;border-width:1px;margin-left:0px;padding-left:10px;=22>
                    <span><div><div><div>Will Platnick &lt;<a href=3D=22m=
ailto:wplatnick=40gmail.com=22>wplatnick=40gmail.com</a>&gt; wrote:</div>=
<blockquote type=3D=22cite=22><div>Will Platnick &lt;<a href=3D=22mailto:=
wplatnick=40gmail.com=22>wplatnick=40gmail.com</a>&gt; wrote:</div></bloc=
kquote><div><br></div><blockquote type=3D=22cite=22><blockquote type=3D=22=
cite=22><div><div>The only thing that stands out is: on your production s=
erver I see</div><div>=22Total runtime: 7.515 ms=22, but the top node in =
EXPLAIN ANAYZE shows</div><div>actual time as 0.179 ms. Not sure where th=
at additional time is being</div><div>spent though. It could be ExecutorS=
tart/End, but have no idea why they</div><div>should take so long.</div><=
/div></blockquote></blockquote><div><br></div><blockquote type=3D=22cite=22=
><div>Any ideas on how to troubleshoot this delay=3F</div></blockquote><d=
iv><br></div><div>Is the client which is running the query on the same ma=
chine as the</div><div>server=3F&nbsp; If not, what's the ping time betwe=
en them=3F</div><div><br></div><div>-Kevin</div></div></div></span>
                =20
                =20
                =20
                =20
                </blockquote>
                =20
                <div>
                    <br>
                </div>
            
--511283c2_189a769b_1c95--