On Thu, May 12, 2011 at 9:09 PM, Willy-Bas Loos <willybas@xxxxxxxxx> 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
