Re: Unused Indexes

Use the any changes in business quality more comments people in business
quality

On Tue, Aug 18, 2026, 11:35 PM Gyanuba Gyanuba <gyanubagyanuba(at)gmail(dot)com>
wrote:

> 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>
>>>
>>