Re: Unused Indexes

From: Ian Lawrence Barwick <barwick(at)gmail(dot)com>
To: SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Unused Indexes
Date: 2026-08-18 13:10:22
Message-ID: CAB8KJ=hDwOk_FtSX00bA=Li3P5h-NBpHeVbxBbmg4_ftqQtQ2g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

2026年8月18日(火) 21:58 SASIKUMAR Devaraj <sashikumard(at)yahoo(dot)com>:
>
> Hi All
>
> How to find when indexes was last used?

Assuming you are using PostgreSQL 16 or later, pg_stat_all_indexes and relatives
contain the "last_idx_scan" column.

https://www.postgresql.org/docs/current/monitoring-stats.html#PG-STAT-ALL-INDEXES-VIEW

Regards

Ian Barwick

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Carroll 2026-08-18 17:44:43 Re: Unused Indexes
Previous Message SASIKUMAR Devaraj 2026-08-18 12:58:02 Unused Indexes