On 04/09/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > --- Phoenix Kiula <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
