What causes an increment to idx_scan in pg_stat_user_indexes? "Select"
queries only? When used to enforce column uniqueness? When used for
foreign-key constraints?
I see lots of indexes with an idx_scan-count of zero but which are not
actually superfluous as they are required to enforce constraints.
Ultimately, I'm trying to come up with a better way to search for truly
useless indexes.
Cheers,
Steve