On Mar 28, 2013 9:07 PM, "kelphet xiong" <kelphet@xxxxxxxxx> wrote:
> explain analyze select * from inventory;
> QUERY PLAN
>
> --------------------------------------------------------------------------------------------------------------
> ------------
> Seq Scan on inventory (cost=0.00..180937.00 rows=11745000 width=16) (actual time=0.005..1030.403 rows=117450
> 00 loops=1)
> Total runtime: 1750.889 ms
> (2 rows)
A large fraction of that time, if not most is due to timing overhead. You can try the same query without timing by using explain (analyze on, timing off) select * from inventory;
Regards,
Ants Aasma
