uni=# explain analyze
uni=# select * from Students where stype='local';
QUERY PLAN
----------------------------------------------------------
Seq Scan on students
(cost=0.00..562.01 rows=23544 width=9)
(actual time=0.052..5.792 rows=23551 loops=1)
Filter: ((stype)::text = 'local'::text)
Rows Removed by Filter: 7810
Planning time: 0.075 ms
Execution time: 6.978 ms
|