Re: log_duration and \timing times repeatably much higher - Mailing list pgsql-general

On Sat, Oct 11, 2003 at 11:22:36AM -0400, Bruce Momjian wrote:
> Martijn van Oosterhout wrote:
> -- Start of PGP signed section.
> > Planning time?
>
> Uh, I thought the actual number reported by EXPLAIN ANALYZE includes
> parse/plan times, but now that you mention it, if it is timing things
> inside the executor, it might be just executor times.
>
> Looking at explain.c, it is only timing the executor part in
> ExplainOnePlan().  The planner() call is outside that loop, so it must
> be parse/plan, though that seems like a lot of time spent in that area.

Could it be because of extremely large statistics settings for the
tables involved?

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Limítate a mirar... y algun día veras"