On Mon, Jan 19, 2015 at 5:04 PM, Richard D Levine < richard_d_lev...@raytheon.com> wrote:
> Is there an echo in here? > > 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 too think that pgAdmin is counting the time to > traverse the result set, but that's purely speculation. > It doesn't traverse the resultset - it demand-renders the grid control, requesting the data from libpq only when it needs it. > > > [image: Inactive hide details for Guillaume Lelarge ---01/19/2015 11:36:44 > AM---2015-01-19 16:26 GMT+01:00 Richard D Levine <Richard_D_]Guillaume > Lelarge ---01/19/2015 11:36:44 AM---2015-01-19 16:26 GMT+01:00 Richard D > Levine <richard_d_lev...@raytheon.com>: > When I have pgAdmin, > > From: Guillaume Lelarge <guilla...@lelarge.info> > To: Richard D Levine <richard_d_lev...@raytheon.com> > Cc: Dave Page <dp...@pgadmin.org>, hushthatb...@hushmail.com, " > pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>, > pgadmin-support-ow...@postgresql.org > Date: 01/19/2015 11:36 AM > > Subject: Re: [pgadmin-support] Is the "x ms" info reliable? > Sent by: pgadmin-support-ow...@postgresql.org > ------------------------------ > > > > 2015-01-19 16:26 GMT+01:00 Richard D Levine < > *richard_d_lev...@raytheon.com* <richard_d_lev...@raytheon.com>>: > > When I have pgAdmin, my app, and PG all running on the same machine, > pgAdmin reported query times are one or two orders of magnitude slower than > times for the same query reported by turning on statement logging. > > > > Yeah, I agree with 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. > > > [image: Inactive hide details for Dave Page ---01/19/2015 03:58:07 > AM---On Sat, Jan 17, 2015 at 8:13 PM, <hushthatb...@hushmail.com> w]Dave > Page ---01/19/2015 03:58:07 AM---On Sat, Jan 17, 2015 at 8:13 PM, < > *hushthatb...@hushmail.com* <hushthatb...@hushmail.com>> wrote: > In > the query window's bottom- > > From: Dave Page <*dp...@pgadmin.org* <dp...@pgadmin.org>> > To: *hushthatb...@hushmail.com* <hushthatb...@hushmail.com> > Cc: "*pgadmin-support@postgresql.org* <pgadmin-support@postgresql.org>" > <*pgadmin-support@postgresql.org* <pgadmin-support@postgresql.org>> > Date: 01/19/2015 03:58 AM > Subject: Re: [pgadmin-support] Is the "x ms" info reliable? > Sent by: *pgadmin-support-ow...@postgresql.org* > <pgadmin-support-ow...@postgresql.org> > ------------------------------ > > > > > On Sat, Jan 17, 2015 at 8:13 PM, <*hushthatb...@hushmail.com* > <hushthatb...@hushmail.com>> wrote: > > In the query window's bottom-right corner, after running a query, it > says > > how long it took. It's ambiguous how exactly this is is calculated. > It seems > > to not take into account the lag from the slow-ass SSH tunnel. > > > > Basically, I wanna know how fast the command *actually* is. Not how > long it > > took to run and then get delivered to pgAdmin via the incredibly > sluggish > > SSH tunnel. The actual, in-app query is run on the same machine, and > should > > be much, much faster. > > > > Is it possible to get this "real time" rather than the "pointless > time"? > > It's not "pointless time", it's the time taken to execute the query > and for libpq to tell pgAdmin it's done. That is typically what people > want when developing queries that are used in other apps - they need > to see how fast PostgreSQL actually executed it, but not the amount of > time taken to transfer the data to the client which can vary wildly > from client app to client app, especially if running through an SSH > tunnel. > > -- > Dave Page > Blog: *http://pgsnake.blogspot.com* <http://pgsnake.blogspot.com/> > Twitter: @pgsnake > > EnterpriseDB UK: *http://www.enterprisedb.com* > <http://www.enterprisedb.com/> > The Enterprise PostgreSQL Company > > > -- > Sent via pgadmin-support mailing list (*pgadmin-support@postgresql.org* > <pgadmin-support@postgresql.org>) > To make changes to your subscription: > *http://www.postgresql.org/mailpref/pgadmin-support* > <http://www.postgresql.org/mailpref/pgadmin-support> > > > > > > -- > Guillaume. > *http://blog.guillaume.lelarge.info* > <http://blog.guillaume.lelarge.info/> > *http://www.dalibo.com* <http://www.dalibo.com/> > > -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
