agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedUnused Indexes
6+ messages / 5 participants
[nested] [flat]
* Unused Indexes
@ 2026-08-18 12:58 SASIKUMAR Devaraj <sashikumard@yahoo.com>
0 siblings, 2 replies; 6+ messages in thread
From: SASIKUMAR Devaraj @ 2026-08-18 12:58 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi All
How to find when indexes was last used?
Regards Sasi
Sent from Yahoo Mail for iPhone
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unused Indexes
@ 2026-08-18 13:10 Ian Lawrence Barwick <barwick@gmail.com>
parent: SASIKUMAR Devaraj <sashikumard@yahoo.com>
1 sibling, 0 replies; 6+ messages in thread
From: Ian Lawrence Barwick @ 2026-08-18 13:10 UTC (permalink / raw)
To: SASIKUMAR Devaraj <sashikumard@yahoo.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
2026年8月18日(火) 21:58 SASIKUMAR Devaraj <sashikumard@yahoo.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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unused Indexes
@ 2026-08-18 17:44 Thomas Carroll <tomfecarroll@yahoo.com>
parent: SASIKUMAR Devaraj <sashikumard@yahoo.com>
1 sibling, 1 reply; 6+ messages in thread
From: Thomas Carroll @ 2026-08-18 17:44 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>; SASIKUMAR Devaraj <sashikumard@yahoo.com>
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 Sasi
Sent from Yahoo Mail for iPhone
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unused Indexes
@ 2026-08-18 17:48 Alex Shapalov <shapalov@gmail.com>
parent: Thomas Carroll <tomfecarroll@yahoo.com>
0 siblings, 1 reply; 6+ messages in thread
From: Alex Shapalov @ 2026-08-18 17:48 UTC (permalink / raw)
To: Thomas Carroll <tomfecarroll@yahoo.com>; SASIKUMAR Devaraj <sashikumard@yahoo.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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@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
> Sasi
>
>
> Sent from Yahoo Mail for iPhone
> <https://mail.onelink.me/107872968?pid=nativeplacement&c=Global_Acquisition_YMktg_315_Internal_Em...;
>
Attachments:
[image/png] Screenshot 2026-08-18 at 10.47.09.png (238.1K, ../../CAPrb+QJPDZt=9vwvVwY9MD0eEi3OhzomgU5c75k5iJXdPahtTw@mail.gmail.com/3-Screenshot%202026-08-18%20at%2010.47.09.png)
download | view image
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unused Indexes
@ 2026-08-18 18:05 Gyanuba Gyanuba <gyanubagyanuba@gmail.com>
parent: Alex Shapalov <shapalov@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Gyanuba Gyanuba @ 2026-08-18 18:05 UTC (permalink / raw)
To: Alex Shapalov <shapalov@gmail.com>; +Cc: Thomas Carroll <tomfecarroll@yahoo.com>; SASIKUMAR Devaraj <sashikumard@yahoo.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
All details and design change tha design
On Tue, Aug 18, 2026, 11:18 PM Alex Shapalov <shapalov@gmail.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@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
>> Sasi
>>
>>
>> Sent from Yahoo Mail for iPhone
>> <https://mail.onelink.me/107872968?pid=nativeplacement&c=Global_Acquisition_YMktg_315_Internal_Em...;
>>
>
Attachments:
[image/png] Screenshot 2026-08-18 at 10.47.09.png (238.1K, ../../CAP7qGJ4Zf9N6VXVRnS0w=Z36kscg-JRmbbDh1cWN-FwavRdC6Q@mail.gmail.com/3-Screenshot%202026-08-18%20at%2010.47.09.png)
download | view image
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Unused Indexes
@ 2026-08-24 15:07 Gyanuba Gyanuba <gyanubagyanuba@gmail.com>
parent: Gyanuba Gyanuba <gyanubagyanuba@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Gyanuba Gyanuba @ 2026-08-24 15:07 UTC (permalink / raw)
To: Alex Shapalov <shapalov@gmail.com>; +Cc: Thomas Carroll <tomfecarroll@yahoo.com>; SASIKUMAR Devaraj <sashikumard@yahoo.com>; Pgsql-admin <pgsql-admin@lists.postgresql.org>
Use the any changes in business quality more comments people in business
quality
On Tue, Aug 18, 2026, 11:35 PM Gyanuba Gyanuba <gyanubagyanuba@gmail.com>
wrote:
> All details and design change tha design
>
> On Tue, Aug 18, 2026, 11:18 PM Alex Shapalov <shapalov@gmail.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@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
>>> Sasi
>>>
>>>
>>> Sent from Yahoo Mail for iPhone
>>> <https://mail.onelink.me/107872968?pid=nativeplacement&c=Global_Acquisition_YMktg_315_Internal_Em...;
>>>
>>
Attachments:
[image/png] Screenshot 2026-08-18 at 10.47.09.png (238.1K, ../../CAP7qGJ4fLGS2sMomKuBXoSsSGAfh6w7FZ3T4WO1hFBwzGJbpfg@mail.gmail.com/3-Screenshot%202026-08-18%20at%2010.47.09.png)
download | view image
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2026-08-24 15:07 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-08-18 12:58 Unused Indexes SASIKUMAR Devaraj <sashikumard@yahoo.com>
2026-08-18 13:10 ` Ian Lawrence Barwick <barwick@gmail.com>
2026-08-18 17:44 ` Thomas Carroll <tomfecarroll@yahoo.com>
2026-08-18 17:48 ` Alex Shapalov <shapalov@gmail.com>
2026-08-18 18:05 ` Gyanuba Gyanuba <gyanubagyanuba@gmail.com>
2026-08-24 15:07 ` Gyanuba Gyanuba <gyanubagyanuba@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox