Index usage statistic for last X hours - Mailing list pgsql-admin

From otar shavadze
Subject Index usage statistic for last X hours
Date
Msg-id CAG-jOyCfGC-RPDnrdmaSZUKzi1OWkk_wh2k-5w7dP4Eu+Q8pmw@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hello
I need to measure  usage of an indexes in the last X hours.
One way I think, is to use pg_cron (or some similar tool) and periodically(hourly) save data from "pg_stat_all_indexes" view some custom table, and then measure usage between hours.

Is there some better solution for this?

pgsql-admin by date:

Previous
From: Mukesh Rajpurohit
Date:
Subject: Re: Oracle error log table equivalent in postgresql
Next
From: Shrikant Bhende
Date:
Subject: Join for the parent table will not leverage the index scan