How come index isn't being used when query by function return value?
От | Joseph Shraibman |
---|---|
Тема | How come index isn't being used when query by function return value? |
Дата | |
Msg-id | e96bql$blk$1@news.hub.org обсуждение исходный текст |
Ответы |
Re: How come index isn't being used when query by function return value?
|
Список | pgsql-general |
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)
В списке pgsql-general по дате отправления: