Re: Unused Indexes

From: Thomas Carroll <tomfecarroll(at)yahoo(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>, SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com>
Subject: Re: Unused Indexes
Date: 2026-08-18 17:44:43
Message-ID: 1616319350.2504592.1787075083017@mail.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey Sasi!
Have a look at 
pg_stat_user_indexes.last_idx_scan.  
In the same family of tables:
pg_stat_sys_indexes
pg_stat_all_indexes
In general, the pg_stat* tables are a gold mine.
Tom
On Tuesday, August 18, 2026 at 08:58:27 AM EDT, SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com> wrote:

Hi All
How to find when indexes was last used?
Regards Sasi

Sent from Yahoo Mail for iPhone

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alex Shapalov 2026-08-18 17:48:24 Re: Unused Indexes
Previous Message Ian Lawrence Barwick 2026-08-18 13:10:22 Re: Unused Indexes