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"
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
