Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Postgres 9.x table/index stats reset timestamp - Mailing list pgsql-general

From Dave Quello
Subject [GENERAL] Postgres 9.x table/index stats reset timestamp
Date
Msg-id CAAdcU1UR5bC-C57qOwDqLEnD6EGG3efCA8qeArFHziHJgGFnmQ@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Postgres 9.x table/index stats reset timestamp  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] pg_restore successful with warnings returns exit codeof non-zero
Next
From: scott ribe
Date:
Subject: [GENERAL] PG on SSD