[prev] 48 [next]

EXPLAIN Examples

Example: Select on non-indexed attribute

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