On Wed, Aug 7, 2024 at 1:06 PM Dirschel, Steve <
steve.dirsc...@thomsonreuters.com> wrote:

> I’ve found multiple postings out there saying you can query
> pg_stat_all_indexes and look at idx_scan to know if an index has been used
> by queries.  I want to be 100% sure I can rely on that table/column to know
> if an index has never been used.
>

Also make sure you check pg_stat_all_indexes on your replicas as well. Each
has their own independent idx_scan counters. So while your primary is not
using a particular index, one or more of your replicas might be.

Cheers,
Greg

Reply via email to