pg_stat_all_indexes understand

From: Nicolas Paris <niparisco(at)gmail(dot)com>
To: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: pg_stat_all_indexes understand
Date: 2015-07-09 12:20:04
Message-ID: CA+ssMOSO0Attq05RJmux8U0Sp3SQt9N=H2dDnbxCqzoMZ_jQCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

I wonder how understanding pg_stat_all_indexes working

When I run an explain, some index are not used, but
pg_stat_all_indexes.idx_scan is incremented for those indexes.

Does this mean idx_scan is incremented each time the planner check if an
index could be use whenever it won't use it ?

Is there a better way to check which index could be delete ?

Thanks by advance.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2015-07-09 12:56:47 Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Previous Message Andres Freund 2015-07-09 10:33:46 Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?