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