agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Thomas Carroll <tomfecarroll@yahoo.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
To: SASIKUMAR Devaraj <sashikumard@yahoo.com>
Subject: Re: Unused Indexes
Date: Tue, 18 Aug 2026 17:44:43 +0000 (UTC)
Message-ID: <1616319350.2504592.1787075083017@mail.yahoo.com> (raw)
In-Reply-To: <1670451420.834851.1787057882154@mail.yahoo.com>
References: <1670451420.834851.1787057882154.ref@mail.yahoo.com>
<1670451420.834851.1787057882154@mail.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
view thread (6+ messages) latest in thread
Message-ID: <1616319350.2504592.1787075083017@mail.yahoo.com>
Permalink: ../1616319350.2504592.1787075083017@mail.yahoo.com/
Also on: postgresql.org/message-id/1616319350.2504592.1787075083017@mail.yahoo.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tomfecarroll@yahoo.com, pgsql-admin@lists.postgresql.org, sashikumard@yahoo.com
Subject: Re: Unused Indexes
In-Reply-To: <1616319350.2504592.1787075083017@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox