Query planner isn't using my indices

To cut a long story short, my largish development database was running the
query I was tinkering with very slowly.

Looking a little deeper, I found that it was always doing a full table
scan.

Which is odd, seeing as we're selecting on a uniquely indexed field...

frontwire=# \d stakeholder_pk
Index "stakeholder_pk"
 Attribute |  Type
-----------+--------
 id        | bigint
unique btree

frontwire=# explain select * from stakeholder where id = 1;
NOTICE:  QUERY PLAN:

Seq Scan on stakeholder  (cost=0.00..602.81 rows=1 width=336)

EXPLAIN
frontwire=# select count(*) from stakeholder;
 count
-------
  9170
(1 row)

...why is this happening? It... shouldn't!

ABS

--
Alaric B. Snell, Developer
abs@frontwire.com