Re: explain analyze query execution time

On 22/11/11 10:26, Kevin Grittner wrote:
> Rudyar  wrote:
>
>> what tool you recommend for measure the query "real" query
>> execution time?
>
> The -hackers list is for discussion to coordinate development of the
> PostgreSQL database product.  For user questions like this, please
> pick a more appropriate list based on the descriptions here:
>
> http://www.postgresql.org/community/lists/
>
> While any further follow-up should be on another list, I'll briefly
> answer here.  EXPLAIN ANALYZE is great for seeing how a query is
> being executed, but for accurate timing of how long the query runs
> without generating all that extra information, you can measure it on
> the client side, or turn on logging of statements running long than
> some particular time.  In psql you can use "\timing on", in Java you
> can run System.currentTimeInMillis() before and after running the
> query, etc.
>
> -Kevin
>
>
Thanks Kevin ;)