On Mar 28, 2013 9:07 PM, "kelphet xiong" <kelp...@gmail.com> 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