Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Re: explain analyze query execution time
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
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.