uni=# explain
uni=# select * from Students where stype='local';
QUERY PLAN
----------------------------------------------------
Seq Scan on students
(cost=0.00..556.10 rows=20073 width=9)
Filter: ((stype)::text = 'local'::text)
uni=# explain analyze
uni=# select * from Students where stype='local';
QUERY PLAN
----------------------------------------------------------
Seq Scan on students
(cost=0.00..556.10 rows=20073 width=9)
(actual time=0.027..4.529 rows=20048 loops=1)
Filter: ((stype)::text = 'local'::text)
Rows Removed by Filter: 11000
Total runtime: 5.4 ms
|