Hello,
My name is Mihaly Fazekas.
Sorry, my english is not good.
I have a query:
telefon=# EXPLAIN SELECT * FROM ext.ext_unit_hi er WHERE now()::date BETWEEN used_from AND used_to;
QUERY PLAN
-------------------------------------------------------------------------
Seq Scan on ext_unit_hier (cost=0.00..242 .58 rows=5808 width=36)
Filter: (((now())::date >= used_from) AND ((now())::date <= used_to))
(2 rows)
One of :) index of the table:
"idx_ext_unit_h ier_used_from_t o" btree (used_from, used_to), tablespace "idx_space"
Number of records in this table at moment: 7343
This table is one element of a "big query".
Wha can i do? (How can SELECT use already presented index?)
My name is Mihaly Fazekas.
Sorry, my english is not good.
I have a query:
telefon=# EXPLAIN SELECT * FROM ext.ext_unit_hi er WHERE now()::date BETWEEN used_from AND used_to;
QUERY PLAN
-------------------------------------------------------------------------
Seq Scan on ext_unit_hier (cost=0.00..242 .58 rows=5808 width=36)
Filter: (((now())::date >= used_from) AND ((now())::date <= used_to))
(2 rows)
One of :) index of the table:
"idx_ext_unit_h ier_used_from_t o" btree (used_from, used_to), tablespace "idx_space"
Number of records in this table at moment: 7343
This table is one element of a "big query".
Wha can i do? (How can SELECT use already presented index?)
Comment