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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
