postgresql - Postgres casting field before applying index -
i have table ~10mln rpws querying date constraint. there's column dt
of type date
( format yyyy-mm-dd
). have created index on it: create index dt_dx on table table(dt)
. run explain analyze
on returned this:
index scan using dt_idx on entities (cost=0.56..74175.26 rows=218 width=64) (actual time=0.069..0.069 rows=0 loops=1) index cond: ((dt)::text = '2017-07-26'::text)
does mean postgres casting column's data text
before comparing values query parameters?
Comments
Post a Comment