I have a table that's had
CONSTRAINT table_pkey PRIMARY KEY (id) since setup.
However, I recently found that I have around 100 duplicate rows (I ran
select count(*) from (select count(*) from table group by id having count(*) > 1) as t1 as per this old stack post. However, I'm running Postgres 10.6, which should be far after that bug.