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

Re: total execution time as reported by auto_explain

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: total execution time as reported by auto_explain
Date: 2009-11-11 14:47:30
Message-ID: 5609.1257950850@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Jaime Casanova <jcasanov(at)systemguards(dot)com(dot)ec> writes:
> 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?

Client slow about absorbing the rows, perhaps?  The actual data output
process isn't counted as part of the plan tree's runtime ... but it
would be included in the total elapsed time.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2009-11-11 15:05:58
Subject: Re: Deadlock on the same object?
Previous:From: Tom LaneDate: 2009-11-11 14:42:19
Subject: Re: PostgreSQL 8.3.8 on AIX5.3 : compilation failed

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