Is there a way to know write statistics on an individual index

From: higherone <higherone(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Is there a way to know write statistics on an individual index
Date: 2022-12-08 06:58:36
Message-ID: CAPgEv8cFisnZ5mtuETw0TPf=qwDo8VhecKD2rSS5BvM+1Jdu8A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I know there's a pg_stats_user_indexes that gives statistics about the
index scans/fetches, but I don't find any information about how many
writes(insert/update/delete) happen on this individual index.
Is there some tool that could achieve this?

Thanks,
Alun

Responses

Browse pgsql-general by date

  From Date Subject
Next Message G Chandrasekar 2022-12-08 07:13:01 Reading from replication slot fails if publication is dropped and created.
Previous Message vignesh C 2022-12-08 05:07:15 Re: Support logical replication of DDLs