On Wed, Dec 14, 2011 at 08:38, AI Rumman <rumman...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
