Skip site navigation (1) Skip section navigation (2)

total execution time as reported by auto_explain

From: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: total execution time as reported by auto_explain
Date: 2009-11-11 06:08:28
Message-ID: 3073cc9b0911102208q76afb447k4ffae74b3df80c24@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

I was using auto_explain to log plans (with analyze option on) from
queries that take more than 500ms, something i found i little odd is
that the duration says 779ms but actual time says 269ms (almost 3
times lower), maybe some kind of instrumentation cleanup can explain
this?

2009-11-10 10:32:41 GMTLOG:  duration: 779.938 ms  plan:
	Sort  (cost=1943.99..1967.38 rows=9355 width=466) (actual
time=235.655..269.061 rows=4997 loops=1)

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

Attachment: explain_no_entendible.txt
Description: text/plain (1.5 KB)

Responses

pgsql-hackers by date

Next:From: Greg SmithDate: 2009-11-11 06:40:31
Subject: Re: next CommitFest
Previous:From: Bruce MomjianDate: 2009-11-11 05:06:22
Subject: Patch committers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group