Re: Is the "x ms" info reliable?
От | Richard D Levine |
---|---|
Тема | Re: Is the "x ms" info reliable? |
Дата | |
Msg-id | OFE53D762B.305CFCBF-ON86257DD2.0054A886-85257DD2.0054D356@mck.us.ray.com обсуждение исходный текст |
Ответ на | Re: Is the "x ms" info reliable? (Dave Page <dpage@pgadmin.org>) |
Ответы |
Re: Is the "x ms" info reliable?
(Guillaume Lelarge <guillaume@lelarge.info>)
|
Список | pgadmin-support |
<p><font face="sans-serif" size="2">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.<br /></font><br /><br /><img alt="Inactive hide details for Dave Page ---01/19/2015 03:58:07 AM---On Sat,Jan 17, 2015 at 8:13 PM, <hushthatbush@hushmail.com> w" border="0" height="16" src="cid:1__=09BBF741DFC72E168f9e8a93d@mck.us.ray.com"width="16" /><font color="#424282" face="sans-serif" size="2">DavePage ---01/19/2015 03:58:07 AM---On Sat, Jan 17, 2015 at 8:13 PM, <hushthatbush@hushmail.com> wrote:> In the query window's bottom-</font><br /><br /><font color="#5F5F5F" face="sans-serif" size="1">From: </font><fontface="sans-serif" size="1">Dave Page <dpage@pgadmin.org></font><br /><font color="#5F5F5F" face="sans-serif"size="1">To: </font><font face="sans-serif" size="1">hushthatbush@hushmail.com</font><br /><font color="#5F5F5F"face="sans-serif" size="1">Cc: </font><font face="sans-serif" size="1">"pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org></font><br/><font color="#5F5F5F" face="sans-serif" size="1">Date: </font><font face="sans-serif"size="1">01/19/2015 03:58 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 /><tt><font size="2">On Sat, Jan 17, 2015 at 8:13 PM, <hushthatbush@hushmail.com> wrote:<br/> > In the query window's bottom-right corner, after running a query, it says<br /> > how long it took. It'sambiguous how exactly this is is calculated. It seems<br /> > to not take into account the lag from the slow-ass SSHtunnel.<br /> ><br /> > Basically, I wanna know how fast the command *actually* is. Not how long it<br /> > tookto run and then get delivered to pgAdmin via the incredibly sluggish<br /> > SSH tunnel. The actual, in-app queryis run on the same machine, and should<br /> > be much, much faster.<br /> ><br /> > Is it possible to getthis "real time" rather than the "pointless time"?<br /><br /> It's not "pointless time", it's the time taken to executethe query<br /> and for libpq to tell pgAdmin it's done. That is typically what people<br /> want when developingqueries that are used in other apps - they need<br /> to see how fast PostgreSQL actually executed it, but notthe amount of<br /> time taken to transfer the data to the client which can vary wildly<br /> from client app to clientapp, especially if running through an SSH<br /> tunnel.<br /><br /> -- <br /> Dave Page<br /> Blog: </font></tt><tt><fontsize="2"><a href="http://pgsnake.blogspot.com">http://pgsnake.blogspot.com</a></font></tt><tt><fontsize="2"><br /> Twitter: @pgsnake<br/><br /> EnterpriseDB UK: </font></tt><tt><font size="2"><a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a></font></tt><tt><fontsize="2"><br /> The Enterprise PostgreSQLCompany<br /><br /><br /> -- <br /> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)<br />To make changes to your subscription:<br /></font></tt><tt><font size="2"><a href="http://www.postgresql.org/mailpref/pgadmin-support">http://www.postgresql.org/mailpref/pgadmin-support</a></font></tt><tt><font size="2"><br/></font></tt><br />
В списке pgadmin-support по дате отправления: