Postgres Pro
Downloads
Home   >   mailing lists

Re: when was pg_stat_reset() used in my server for the last time - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: when was pg_stat_reset() used in my server for the last time
Date
Msg-id CABRT9RCSToTJyQDfE1Eo-0k3BMz5CF5jQrodYs1sTew3y8eErQ@mail.gmail.com
Whole thread Raw
In response to when was pg_stat_reset() used in my server for the last time  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jay Levitt
Date:
Subject: Re: Controlling complexity in queries
Next
From: Chris Angelico
Date:
Subject: Re: Philosophical question