Re: [GENERAL] Statistics on index usage

2016-11-01 Thread Melvin Davidson
On Tue, Nov 1, 2016 at 10:43 AM, François Battail < francois.batt...@sipibox.fr> wrote: > Dear List, > > does pgsql maintains statistics on index usage? I mean just a counter > for each index in the database, incremented each time time it is used. > It would be useful to help cleaning almost unuse

Re: [GENERAL] Statistics on index usage

2016-11-01 Thread Scott Marlowe
On Tue, Nov 1, 2016 at 8:43 AM, François Battail wrote: > Dear List, > > does pgsql maintains statistics on index usage? I mean just a counter > for each index in the database, incremented each time time it is used. > It would be useful to help cleaning almost unused index and to avoid > poisoning

[GENERAL] Statistics on index usage

2016-11-01 Thread François Battail
Dear List, does pgsql maintains statistics on index usage? I mean just a counter for each index in the database, incremented each time time it is used. It would be useful to help cleaning almost unused index and to avoid poisoning the global cache. I've found nothing so far but may be I've been m