Re: Unused Indexes

All details and design change tha design

On Tue, Aug 18, 2026, 11:18 PM Alex Shapalov <shapalov(at)gmail(dot)com> wrote:

> Hi, also you can use pgbot (www.pgbot.dev)
>
> *pgbot inspect --full*
>
> [image: Screenshot 2026-08-18 at 10.47.09.png]
>
>
>
> --
> best,
>
> Alex Shapalov
>
>
>
>
>
> On Tue, Aug 18, 2026 at 10:45 AM Thomas Carroll <tomfecarroll(at)yahoo(dot)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(at)yahoo(dot)com> wrote:
>>
>>
>> Hi All
>>
>> How to find when indexes was last used?
>>
>> Regards
>> Sasi
>>
>>
>> Sent from Yahoo Mail for iPhone
>> <https://mail.onelink.me/107872968?pid=nativeplacement&c=Global_Acquisition_YMktg_315_Internal_EmailSignature&af_sub1=Acquisition&af_sub2=Global_YMktg&af_sub3=&af_sub4=100000604&af_sub5=EmailSignature__Static_&af_ios_store_cpp=9d3a686e-218d-4849-8298-b480188dc8ac&af_android_url=https%3A%2F%2Fplay.google.com%2Fstore%2Fapps%2Fdetails%3Fid%3Dcom.yahoo.mobile.client.android.mail%26listing%3Demail_signature>
>>
>