On Thu, May 12, 2011 at 9:09 PM, Willy-Bas Loos <willy...@gmail.com> wrote:
> Hi, > > We have some indexes that don't seem to be used at all. > I'd like to know since when they have not been used. > That is, the time when postgres started counting to reach the number that > is in pg_stat_user_indexes.idx_scan > > Is there a way to retrieve that from the database ? > "Analyze" activity will update the statistics of each catalog table. pg_postmaster_start_time --> Retrieves the Postmaster [ PostgreSQL Instance] start time postgres=# select pg_postmaster_start_time(); --Raghu Ram
