Re: Is the "x ms" info reliable?

<p><font face="sans-serif" size="2">Is there an echo in here?</font><br /><br /><font face="sans-serif" size="2">To be
fair,Dave's point is that times from a client's perspective will necessarily be longer than those from inside the
server. That doesn't account for an order of magnitude's difference though, especially when the connection is local.  I
toothink that pgAdmin is counting the time to traverse the result set, but that's purely speculation.<br /></font><br
/><br/><img alt="Inactive hide details for Guillaume Lelarge ---01/19/2015 11:36:44 AM---2015-01-19 16:26 GMT+01:00
RichardD Levine <Richard_D_" border="0" height="16" src="cid:1__=09BBF741DFCEDF6A8f9e8a93d@mck.us.ray.com"
width="16"/><font color="#424282" face="sans-serif" size="2">Guillaume Lelarge ---01/19/2015 11:36:44 AM---2015-01-19
16:26GMT+01:00 Richard D Levine <Richard_D_Levine@raytheon.com>: > When I have pgAdmin,</font><br /><br
/><fontcolor="#5F5F5F" face="sans-serif" size="1">From: </font><font face="sans-serif" size="1">Guillaume Lelarge
<guillaume@lelarge.info></font><br/><font color="#5F5F5F" face="sans-serif" size="1">To: </font><font
face="sans-serif"size="1">Richard D Levine <Richard_D_Levine@raytheon.com></font><br /><font color="#5F5F5F"
face="sans-serif"size="1">Cc: </font><font face="sans-serif" size="1">Dave Page <dpage@pgadmin.org>,
hushthatbush@hushmail.com,"pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>,
pgadmin-support-owner@postgresql.org</font><br/><font color="#5F5F5F" face="sans-serif" size="1">Date: </font><font
face="sans-serif"size="1">01/19/2015 11:36 AM</font><br /><font color="#5F5F5F" face="sans-serif" size="1">Subject:
</font><fontface="sans-serif" size="1">Re: [pgadmin-support] Is the "x ms" info reliable?</font><br /><font
color="#5F5F5F"face="sans-serif" size="1">Sent by: </font><font face="sans-serif"
size="1">pgadmin-support-owner@postgresql.org</font><br/><hr align="left" noshade size="2" style="color:#8091A5; "
width="100%"/><br /><br /><br /><font face="serif" size="3">2015-01-19 16:26 GMT+01:00 Richard D Levine <</font><a
href="mailto:Richard_D_Levine@raytheon.com"target="_blank"><font color="#0000FF" face="serif"
size="3"><u>Richard_D_Levine@raytheon.com</u></font></a><fontface="serif" size="3">>:</font><ul style="padding-left:
9pt"><fontface="sans-serif" size="3">When I have pgAdmin, my app, and PG all running on the same machine, pgAdmin
reportedquery times are one or two orders of magnitude slower than times for the same query reported by turning on
statementlogging.</font><font face="serif" size="3"><br /></font></ul><br /><br /><font face="serif" size="3">Yeah, I
agreewith the OP. I'm pretty sure the time the query tool reports includes the display time. I didn't check in the
code,but that was always my view of the time. Doesn't mean it is useless, but pretty much like it.<br /></font><ul
style="padding-left:9pt"><font face="serif" size="3"><br /></font><img alt="Inactive hide details for Dave Page
---01/19/201503:58:07 AM---On Sat, Jan 17, 2015 at 8:13 PM,  <hushthatbush@hushmail.com> w" height="16"
src="cid:1__=09BBF741DFCEDF6A8f9e8a93d@mck.us.ray.com"width="16" /><font color="#424282" face="sans-serif"
size="3">DavePage ---01/19/2015 03:58:07 AM---On Sat, Jan 17, 2015 at 8:13 PM,  <</font><a
href="mailto:hushthatbush@hushmail.com"target="_blank"><font color="#0000FF" face="sans-serif"
size="3"><u>hushthatbush@hushmail.com</u></font></a><fontcolor="#424282" face="sans-serif" size="3">> wrote: > In
thequery window's bottom-</font><font face="serif" size="3"><br /></font><font color="#5F5F5F" face="sans-serif"
size="1"><br/> From: </font><font face="sans-serif" size="1">Dave Page <</font><a href="mailto:dpage@pgadmin.org"
target="_blank"><fontcolor="#0000FF" face="sans-serif" size="1"><u>dpage@pgadmin.org</u></font></a><font
face="sans-serif"size="1">></font><font color="#5F5F5F" face="sans-serif" size="1"><br /> To: </font><a
href="mailto:hushthatbush@hushmail.com"target="_blank"><font color="#0000FF" face="sans-serif"
size="1"><u>hushthatbush@hushmail.com</u></font></a><fontcolor="#5F5F5F" face="sans-serif" size="1"><br /> Cc:
</font><fontface="sans-serif" size="1">"</font><a href="mailto:pgadmin-support@postgresql.org" target="_blank"><font
color="#0000FF"face="sans-serif" size="1"><u>pgadmin-support@postgresql.org</u></font></a><font face="sans-serif"
size="1">"<</font><a href="mailto:pgadmin-support@postgresql.org" target="_blank"><font color="#0000FF"
face="sans-serif"size="1"><u>pgadmin-support@postgresql.org</u></font></a><font face="sans-serif"
size="1">></font><fontcolor="#5F5F5F" face="sans-serif" size="1"><br /> Date: </font><font face="sans-serif"
size="1">01/19/201503:58 AM</font><font color="#5F5F5F" face="sans-serif" size="1"><br /> Subject: </font><font
face="sans-serif"size="1">Re: [pgadmin-support] Is the "x ms" info reliable?</font><font color="#5F5F5F"
face="sans-serif"size="1"><br /> Sent by: </font><a href="mailto:pgadmin-support-owner@postgresql.org"
target="_blank"><fontcolor="#0000FF" face="sans-serif"
size="1"><u>pgadmin-support-owner@postgresql.org</u></font></a><br/><hr align="left" noshade size="2" width="100%"
/><br/><font face="serif" size="3"><br /><br /></font><tt><font size="3"><br /> On Sat, Jan 17, 2015 at 8:13 PM,
 <</font></tt><ahref="mailto:hushthatbush@hushmail.com" target="_blank"><tt><font color="#0000FF"
size="3"><u>hushthatbush@hushmail.com</u></font></tt></a><tt><fontsize="3">> wrote:<br /> > In the query window's
bottom-rightcorner, after running a query, it says<br /> > how long it took. It's ambiguous how exactly this is is
calculated.It seems<br /> > to not take into account the lag from the slow-ass SSH tunnel.<br /> ><br /> >
Basically,I wanna know how fast the command *actually* is. Not how long it<br /> > took to run and then get
deliveredto pgAdmin via the incredibly sluggish<br /> > SSH tunnel. The actual, in-app query is run on the same
machine,and should<br /> > be much, much faster.<br /> ><br /> > Is it possible to get this "real time" rather
thanthe "pointless time"?<br /><br /> It's not "pointless time", it's the time taken to execute the query<br /> and for
libpqto tell pgAdmin it's done. That is typically what people<br /> want when developing queries that are used in other
apps- they need<br /> to see how fast PostgreSQL actually executed it, but not the amount of<br /> time taken to
transferthe data to the client which can vary wildly<br /> from client app to client app, especially if running through
anSSH<br /> tunnel.<br /><br /> -- <br /> Dave Page<br /> Blog: </font></tt><a href="http://pgsnake.blogspot.com/"
target="_blank"><tt><fontcolor="#0000FF" size="3"><u>http://pgsnake.blogspot.com</u></font></tt></a><tt><font
size="3"><br/> Twitter: @pgsnake<br /><br /> EnterpriseDB UK: </font></tt><a href="http://www.enterprisedb.com/"
target="_blank"><tt><fontcolor="#0000FF" size="3"><u>http://www.enterprisedb.com</u></font></tt></a><tt><font
size="3"><br/> The Enterprise PostgreSQL Company<br /><br /><br /> -- <br /> Sent via pgadmin-support mailing list
(</font></tt><ahref="mailto:pgadmin-support@postgresql.org" target="_blank"><tt><font color="#0000FF"
size="3"><u>pgadmin-support@postgresql.org</u></font></tt></a><tt><fontsize="3">)<br /> To make changes to your
subscription:</font></tt><tt><fontcolor="#0000FF" size="3"><u><br /></u></font></tt><a
href="http://www.postgresql.org/mailpref/pgadmin-support"target="_blank"><tt><font color="#0000FF"
size="3"><u>http://www.postgresql.org/mailpref/pgadmin-support</u></font></tt></a><fontface="serif" size="3"><br
/></font></ul><br/><font face="serif" size="3"><br /><br /><br /> -- </font><br /><font face="serif"
size="3">Guillaume.</font><br/><font face="serif" size="3">  </font><a href="http://blog.guillaume.lelarge.info/"
target="_blank"><fontcolor="#0000FF" face="serif" size="3"><u>http://blog.guillaume.lelarge.info</u></font></a><br
/><fontface="serif" size="3">  </font><a href="http://www.dalibo.com/" target="_blank"><font color="#0000FF"
face="serif"size="3"><u>http://www.dalibo.com</u></font></a><br />