age of statistics

From: colin roald <zmook(at)gungeralv(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: age of statistics
Date: 2003-09-05 01:14:49
Message-ID: 20030905011449.GI2571@moonbase.hopto.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Is there a way to query the database to find out how old the current
table statistics are? That is, when the ANALYZE command was last run
on a given table? It seems like there ought to be a table somewhere
in pg_catalog I can't find it in the PostgreSQL Administrator
documentation, nor by searching google.

Thanks,

--
colin | perfection is reached, not when there is no longer anything to add,
roald | but when there is no longer anything to take away.
(antoine de saint-exupery)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message colin roald 2003-09-05 01:27:53 Re: age of statistics
Previous Message Bruce Momjian 2003-09-05 00:32:38 Re: Seeking information about backup/recovery