Hi,
Function pg_stat_reset_single_table_counters() resets stats for a single table/index that you typically query through pg_stat_user_tables or pg_stat_user_indexes, but there is no apparent way to retrieve the timestamp of the reset. All stats in the db can be reset using pg_stat_reset() and the last reset date can be retrieved from pg_stat_database, but I’d prefer not to reset ALL stats when the focus is on a particular table/index.
Are individual table/index reset timestamps stored? If so, can they be retrieved?
Thanks,
Dave