Statistics on index usage

From: François Battail <francois(dot)battail(at)sipibox(dot)fr>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Statistics on index usage
Date: 2016-11-01 14:43:41
Message-ID: 8e8454ba-1988-fce3-c61a-37a778a8b241@sipibox.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 missing something.

Best regards.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2016-11-01 14:51:12 Re: Statistics on index usage
Previous Message Scott Marlowe 2016-11-01 13:55:03 Re: Turning slave into a master - PostgreSQL 9.2