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