On 22/11/11 02:58, Kevin Grittner wrote:
Rudyar wrote:
I try to get the execution time of a query workload. I try using
explain analyze but this time is allways higher than the execution
time of a query across a client like pgadmin3
what is the reason about that difference?
It's the "observer effect" -- there is a cost to the timing,
counting, measuring, and reporting which is done by EXPLAIN ANALYZE,
which distorts what is being measured. It's just about impossible to
avoid entirely.
-Kevin
Thanks kevin,
what tool you recommend for measure the query "real" query execution time?
--
Rudyar Cortés.
Estudiante de Ingeniería Civil Informática
Universidad Técnica Federico Santa María.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
