Re: Is the "x ms" info reliable?

On Mon, Jan 19, 2015 at 5:04 PM, Richard D Levine <
Richard_D_Levine(at)raytheon(dot)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_Levine(at)raytheon(dot)com>: > When I have pgAdmin,
>
> From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> To: Richard D Levine <Richard_D_Levine(at)raytheon(dot)com>
> Cc: Dave Page <dpage(at)pgadmin(dot)org>, hushthatbush(at)hushmail(dot)com, "
> pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org>,
> pgadmin-support-owner(at)postgresql(dot)org
> Date: 01/19/2015 11:36 AM
>
> Subject: Re: [pgadmin-support] Is the "x ms" info reliable?
> Sent by: pgadmin-support-owner(at)postgresql(dot)org
> ------------------------------
>
>
>
> 2015-01-19 16:26 GMT+01:00 Richard D Levine <
> *Richard_D_Levine(at)raytheon(dot)com* <Richard_D_Levine(at)raytheon(dot)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, <hushthatbush(at)hushmail(dot)com> w]Dave
> Page ---01/19/2015 03:58:07 AM---On Sat, Jan 17, 2015 at 8:13 PM, <
> *hushthatbush(at)hushmail(dot)com* <hushthatbush(at)hushmail(dot)com>> wrote: > In
> the query window's bottom-
>
> From: Dave Page <*dpage(at)pgadmin(dot)org* <dpage(at)pgadmin(dot)org>>
> To: *hushthatbush(at)hushmail(dot)com* <hushthatbush(at)hushmail(dot)com>
> Cc: "*pgadmin-support(at)postgresql(dot)org* <pgadmin-support(at)postgresql(dot)org>"
> <*pgadmin-support(at)postgresql(dot)org* <pgadmin-support(at)postgresql(dot)org>>
> Date: 01/19/2015 03:58 AM
> Subject: Re: [pgadmin-support] Is the "x ms" info reliable?
> Sent by: *pgadmin-support-owner(at)postgresql(dot)org*
> <pgadmin-support-owner(at)postgresql(dot)org>
> ------------------------------
>
>
>
>
> On Sat, Jan 17, 2015 at 8:13 PM, <*hushthatbush(at)hushmail(dot)com*
> <hushthatbush(at)hushmail(dot)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(at)postgresql(dot)org*
> <pgadmin-support(at)postgresql(dot)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