Re: Is the "x ms" info reliable?

On 17/01/2015 20:13, 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"?

Do this -

explain analyze (your query)

- to get the execution time.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie