We've been running the stats collector for about a week now on a
heavily used production database (with all the various row/block level
gathering options enabled too). This database, in terms of number of
tables and indexes is rather large. About 100 tables, and many many
more indexes.
What we've found is that pg_stats_user_indexes shows a number indexes
that appear to be used at all (ie, zero's for idx_scan, x_tup_read, and
idx_tup_fetch columns).
Could pg_stats_user_indexes be lying? Could I be misinterpreting the
data?
I realize the real question is "why aren't these indexes being used",
but that's something I need to figure out for myself.
thanks!
eric