Simple Query not using Primary Key Index

From: "Podrigal, Aron" <aronp(at)guaranteedplus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Simple Query not using Primary Key Index
Date: 2017-02-06 23:16:19
Message-ID: CANJp-ygBnTfynretdNwdAoyVJHa=etwVTLBHcz3YRV39GobG6w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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?

--

-
Aron Podrigal

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2017-02-06 23:23:37 Re: Simple Query not using Primary Key Index
Previous Message Igal @ Lucee.org 2017-02-06 21:16:40 Re: BST Time Zone Discrepancy