Search Postgresql Archives

How come index isn't being used when query by function return value?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



db:db=>explain select * from elog where id = eds('2006-01-01');
                                        QUERY PLAN
-------------------------------------------------------------------------------------------
 Seq Scan on elog  (cost=0.00..1894975.10 rows=1 width=204)
   Filter: (id = eds('2006-01-01 00:00:00'::timestamp without time zone))
(2 rows)

db:db=>explain select * from elog, (select eds('2006-01-01') as trg) aa where id = trg;
                                      QUERY PLAN
--------------------------------------------------------------------------------------
 Nested Loop  (cost=0.00..4.36 rows=1 width=208)
   ->  Subquery Scan aa  (cost=0.00..0.02 rows=1 width=4)
         ->  Result  (cost=0.00..0.01 rows=1 width=0)
-> Index Scan using elog_pkey on elog (cost=0.00..4.33 rows=1 width=204)
         Index Cond: (elog.id = "outer".trg)
(5 rows)

Time: 0.978 ms
db:db=>select version();
                                                 version
----------------------------------------------------------------------------------------------------------
PostgreSQL 8.0.8 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.4 20050721 (Red Hat 3.4.4-2)
(1 row)



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux