On 17/01/2015 20:13, 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"?
Do this -
explain analyze (your query)
- to get the execution time.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie