Thread: Is the "x ms" info reliable?
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
Folk Alley - All Folk - 24 Hours a day
www.folkalley.com
From: "hushthatbush@hushmail.com" <hushthatbush@hushmail.com>
To: "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>
Sent: Saturday, January 17, 2015 3:13 PM
Subject: [pgadmin-support] Is the "x ms" info reliable?
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"?
PS: I hate the command-line psql tool and I don't want anything to do with it.
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.
Dave Page ---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-
From: Dave Page <dpage@pgadmin.org>
To: hushthatbush@hushmail.com
Cc: "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-owner@postgresql.org
On Sat, Jan 17, 2015 at 8:13 PM, <hushthatbush@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
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
--
Attachment
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.
Guillaume Lelarge ---01/19/2015 11:36:44 AM---2015-01-19 16:26 GMT+01:00 Richard D Levine <Richard_D_Levine@raytheon.com>: > When I have pgAdmin,
From: Guillaume Lelarge <guillaume@lelarge.info>
To: Richard D Levine <Richard_D_Levine@raytheon.com>
Cc: Dave Page <dpage@pgadmin.org>, hushthatbush@hushmail.com, "pgadmin-support@postgresql.org" <pgadmin-support@postgresql.org>, pgadmin-support-owner@postgresql.org
Date: 01/19/2015 11:36 AM
Subject: Re: [pgadmin-support] Is the "x ms" info reliable?
Sent by: pgadmin-support-owner@postgresql.org
2015-01-19 16:26 GMT+01:00 Richard D Levine <Richard_D_Levine@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.
From: Dave Page <dpage@pgadmin.org>
To: hushthatbush@hushmail.com
Cc: "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-owner@postgresql.org
On Sat, Jan 17, 2015 at 8:13 PM, <hushthatbush@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
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
