On 17/01/2015 20:13, 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"?
Do this - explain analyze (your query) - to get the execution time. Ray. -- Raymond O'Donnell :: Galway :: Ireland r...@iol.ie -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
