Date: Tue, 18 Aug 2026 17:44:43 +0000 (UTC)
From: Thomas Carroll <tomfecarroll@yahoo.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>,
	SASIKUMAR Devaraj <sashikumard@yahoo.com>
Message-ID: <1616319350.2504592.1787075083017@mail.yahoo.com>
In-Reply-To: <1670451420.834851.1787057882154@mail.yahoo.com>
References: <1670451420.834851.1787057882154.ref@mail.yahoo.com>
 <1670451420.834851.1787057882154@mail.yahoo.com>
Subject: Re: Unused Indexes
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2504591_2055717762.1787075083016"
Content-Length: 3136
Archived-At: 
 <https://www.postgresql.org/message-id/1616319350.2504592.1787075083017%40mail.yahoo.com>
Precedence: bulk

------=_Part_2504591_2055717762.1787075083016
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 Hey Sasi!
Have a look at=C2=A0
pg_stat_user_indexes.last_idx_scan.=C2=A0=C2=A0
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 <sash=
ikumard@yahoo.com> wrote: =20
=20
 Hi All
How to find when indexes was last used?
Regards=C2=A0Sasi


Sent from Yahoo Mail for iPhone
 =20
------=_Part_2504591_2055717762.1787075083016
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html><head></head><body><div class="ydpd8373043yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div></div>
        <div dir="ltr" data-setdir="false">Hey Sasi!</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Have a look at&nbsp;</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">pg_stat_user_indexes.<span>last_idx_scan.&nbsp;&nbsp;</span></div><div dir="ltr" data-setdir="false"><span><br></span></div><div dir="ltr" data-setdir="false"><span>In the same family of tables:</span></div><div dir="ltr" data-setdir="false"><div><br></div><div>pg_stat_sys_indexes<br>pg_stat_all_indexes</div><br></div><div dir="ltr" data-setdir="false">In general, the pg_stat* tables are a gold mine.</div><div dir="ltr" data-setdir="false"><br></div><div dir="ltr" data-setdir="false">Tom</div><div><br></div>
        
        </div><div id="yahoo_quoted_7239926139" class="yahoo_quoted">
            <div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
                
                <div>
                        On Tuesday, August 18, 2026 at 08:58:27 AM EDT, SASIKUMAR Devaraj &lt;sashikumard@yahoo.com&gt; wrote:
                    </div>
                    <div><br></div>
                    <div><br></div>
                
                
                <div><div id="yiv5262166712"><!--[if gte mso 9]><xml><o:OfficeDocumentSettings><o:AllowPNG/><o:PixelsPerInch>96</o:PixelsPerInch></o:OfficeDocumentSettings></xml><![endif]--><div>
Hi All<div><br></div><div>How to find when indexes was last used?</div><div><br></div><div>Regards&nbsp;</div><div>Sasi<br><br><br><div class="yiv5262166712yahoo-signature"><a rel="nofollow noopener noreferrer" style="font-size:12px;" target="_blank" href="https://mail.onelink.me/107872968?pid=nativeplacement&amp;c=Global_Acquisition_YMktg_315_Internal_EmailSignature&amp;af_sub1=Acquisition&amp;af_sub2=Global_YMktg&amp;af_sub3=&amp;af_sub4=100000604&amp;af_sub5=EmailSignature__Static_&amp;af_ios_store_cpp=9d3a686e-218d-4849-8298-b480188dc8ac&amp;af_android_url=https%3A%2F%2Fplay.google.com%2Fstore%2Fapps%2Fdetails%3Fid%3Dcom.yahoo.mobile.client.android.mail%26listing%3Demail_signature">Sent from Yahoo Mail for iPhone</a><br></div></div>
</div></div></div>
            </div>
        </div></body></html>
------=_Part_2504591_2055717762.1787075083016--