Re: Unused Indexes

Поиск
Список
Период
Сортировка
Искать

Re: Unused Indexes

От:
Alex Shapalov <shapalov@gmail.com>
Дата:
Вложения:
Hi, also you can use pgbot  (www.pgbot.dev)

pgbot inspect --full





--
best,

Alex Shapalov





On Tue, Aug 18, 2026 at 10:45 AM Thomas Carroll <tomfecarroll@yahoo.com> wrote:
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@yahoo.com> wrote:


Hi All

How to find when indexes was last used?

Regards 
FAQ