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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
