I noticed when I do a simple SELECT id FROM mytable WHERE id = 'cb81d070-4213-465f-b32e-b8db43b83a25'::UUID Postgres does not use the primary key index and opts for a Seq Scan.
I of course did VACUUM ANALYZE and I have reset statistics But no sign. Is there any particular thing I should be looking at?