| From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | [PERFORM] since when has pg_stat_user_indexes.idx_scan been counting? |
| Date: | 2011-05-12 15:39:50 |
| Message-ID: | BANLkTikhNLPhCjE819=RFG-+CB6UV4GbUA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2011-05-12 18:18:05 | Re: since when has pg_stat_user_indexes.idx_scan been counting? |
| Previous Message | Nathan M. Davalos | 2011-05-12 14:05:48 | Re: Permission Denied for 'pg_stat_tmp/pgstat.tmp' on Windows server 2003 - postgresql 8.4.6 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shaun Thomas | 2011-05-12 15:48:55 | Re: Postgres refusing to use >1 core |
| Previous Message | Tom Lane | 2011-05-12 14:51:42 | Re: Postgres refusing to use >1 core |