On 04/09/07, Richard Broersma Jr <rabroersma@yahoo.com> wrote:
> --- Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> > LOG: duration: 93473.282 ms statement: select t_info, dstats, id
> > from trades where t_alias = '17huv' and status = 'Y'
> >
> > -----------------------
> >
> > Index Scan using trades_unique_t_alias on trades (cost=0.00..3.41
>
> > Time: 2.990 ms
>
>
> Thats odd, I wonder why the EXPLAIN ANALYZE time id some much less that the logged select
> statement times?
>
Because the statement has been executed and is in the cache.