Thread: when was pg_stat_reset() used in my server for the last time

when was pg_stat_reset() used in my server for the last time

From

AI Rumman

Date:

14 December 2011, 05:39:10

Is it possible to find out, when was pg_stat_reset() used in my server for the last time?
I am using Postgresql 9.2 and I need to find out unused index.

Re: when was pg_stat_reset() used in my server for the last time

From

Marti Raudsepp

Date:

14 December 2011, 19:57:19

On Wed, Dec 14, 2011 at 08:38, AI Rumman <rummandba@gmail.com> wrote:
> Is it possible to find out, when was pg_stat_reset() used in my server for
> the last time?
> I am using Postgresql 9.2 and I need to find out unused index.

I assume you mean PostgreSQL 9.1.2

The pg_stat_database system view has a 'stats_reset' column, for each database.

There's also the pg_stat_get_db_stat_reset_time() function.

Regards,
Marti