Re: simple update queries take a long time - postgres 8.3.1

[mark <markkicks(at)gmail(dot)com>]

On Mon, Mar 31, 2008 at 12:59 PM, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:

On 31/03/2008 20:51, mark wrote:

> 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)

As I understand it, "cost" signifies the planner's estimate of how long
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?

>  Index Scan using idx_uid on users  (cost=0.00..8.46 rows=1 width=1073)

> (actual time=0.094..0.161 rows=1 loops=1)
>    Index Cond: (uid = 738889333)
>  Total runtime: 11479.053 ms