The index was created before the table was populated. There are 3 rows in the table for 3 different users. Now when I do a
postgresql will not use index scan for table with 3 rows in it. it is way faster to use seq scan on it.
depesz
--
http://www.depesz.com/ - nowy, lepszy depesz