From: Willy-Bas Loos <willybas@gmail.com>
To: pgsql-performance@postgresql.org
To: pgsql-admin@postgresql.org
Subject: [PERFORM] since when has pg_stat_user_indexes.idx_scan been counting?
Date: Thu, 12 May 2011 17:39:50 +0200
Message-ID: <BANLkTikhNLPhCjE819=RFG-+CB6UV4GbUA@mail.gmail.com> (raw)
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 ?
Cheers,
WBL
--
"Patriotism is the conviction that your country is superior to all others
because you were born in it." -- George Bernard Shaw
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: willybas@gmail.com, pgsql-performance@postgresql.org
Subject: Re: [PERFORM] since when has pg_stat_user_indexes.idx_scan been counting?
In-Reply-To: <BANLkTikhNLPhCjE819=RFG-+CB6UV4GbUA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox