PostgreSQL - Removing Unused Index on Check Constraint column I used the script from this blog to identify the unused index on my database. It returns an index which is on a column called result where I have a check constraint on that column.
So removing this index will impact the check constraint performance?
will removing this index impact the check constraint performance?

No, it will not.
Check constraints only operate on the columns of a single row, not on multiple rows. So it is completely unaffected by the existence (or absence) of an index.