On Sat, Jan 17, 2015 at 8:13 PM, <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 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
