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
