Are idx_scan statistics reset automatically (default)?
3
votes
2
answers
3528
views
I was looking at the tables (**pg_stat_user_indexes** and **pg_stat_user_tables**) and discovered many indices that are not being used.
But before I think about doing any operations to remove these indices, I need to understand what period was the analysis of this data (*idx_scan*), has it been since the database was created?
In the **pg_stat_database** (*stats_reset*) table is there a date that normally is today or up to 15 days ago, but does this process interfere with the tables I mentioned above?
* No command of% reset () was executed.
Do the% reset () commands clear the tables (**pg_stat_user_indexes** and **pg_stat_user_tables**)?
My goal is to understand the period of data collected so that I can make a decision.
Asked by Gabriel
(153 rep)
May 6, 2019, 02:33 PM
Last activity: Feb 5, 2021, 04:22 PM
Last activity: Feb 5, 2021, 04:22 PM