I'm doing some index analysis on our database to see if there are indexes we can remove. To do this I want to run
select pg_stat_reset(); to reset all stat counters back to zero, then just wait a week and see which indexes haven't been used.
pg_stat_reset() also reset row count statistics? Will this affect the query planner?
Is it recommended to rerun
Analyze public.#table# on all tables after you reset stats?