On Mon, Mar 31, 2008 at 12:59 PM, Raymond O'Donnell <rod@xxxxxx> wrote:
it says actual time is 0.161 seconds or milliseconds.. but the total run time is 11 seconds.. any ideas why this discrepancy?
> Index Scan using idx_uid on users (cost=0.00..8.46 rows=1 width=1073)On 31/03/2008 20:51, mark wrote:As I understand it, "cost" signifies the planner's estimate of how long
> can you explain what the numbers mean in the EXPLAIN ANALYZE?
> (cost=0.00..8.46 rows=1 width=1073) (actual time=0.094..0.161 rows=1
> loops=1)
the query will take, in terms of disk page fetches. The "actual time" is
in milliseconds.
it says actual time is 0.161 seconds or milliseconds.. but the total run time is 11 seconds.. any ideas why this discrepancy?
> (actual time=0.094..0.161 rows=1 loops=1)
> Index Cond: (uid = 738889333)
> Total runtime: 11479.053 ms
