Index usage statistic for last X hours

From: otar shavadze <oshavadze(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Index usage statistic for last X hours
Date: 2021-08-10 14:01:49
Message-ID: CAG-jOyCfGC-RPDnrdmaSZUKzi1OWkk_wh2k-5w7dP4Eu+Q8pmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-admin by date

  From Date Subject
Next Message Bossart, Nathan 2021-08-11 23:23:52 Re: Estimating HugePages Requirements?
Previous Message Andres Freund 2021-08-10 03:42:05 Re: Estimating HugePages Requirements?