Hello, I wonder how understanding pg_stat_all_indexes working
When I run an explain, some index are not used, but pg_stat_all_indexes.idx_scan is incremented for those indexes. Does this mean idx_scan is incremented each time the planner check if an index could be use whenever it won't use it ? Is there a better way to check which index could be delete ? Thanks by advance.
