Sample Header Ad - 728x90

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