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(at)frontwire(dot)com