Re: Understanding EXPLAIN ANALYZE output

On Wednesday February 9 2005 3:13, Martijn van Oosterhout wrote:
>
> In general, the EXPLAIN ANALYZE output follows the planner
> output as close as possible. If you look at the original query
> posted, it showed an Index Scan costing 4.63..4.63 which means
> the index scan is taking (on average) 4.63ms to return 1 row!
> If it displayed as 4000 or something it would be a lot less
> clear what was going on.
>
> Hope this helps,

Both replies help very much, thanks.  Regarding 4.63ms to return
a row, I know I/O speeds vary widely depending on conditions and
hardware, but what would you say is a "red flag" value for the
actual time to retrieve a row.  I see that for most of the other
times in this example, 0.01ms to 0.10ms is not unusual.

Ed