Postgres Pro
Downloads
Home   >   mailing lists

pg_stat_all_indexes understand - Mailing list pgsql-performance

From Nicolas Paris
Subject pg_stat_all_indexes understand
Date
Msg-id CA+ssMOSO0Attq05RJmux8U0Sp3SQt9N=H2dDnbxCqzoMZ_jQCg@mail.gmail.com
Whole thread Raw
Responses Re: pg_stat_all_indexes understand
List pgsql-performance
Tree view
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.

pgsql-performance by date:

Previous
From: Andres Freund
Date:
Subject: Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?
Next
From: Merlin Moncure
Date:
Subject: Re: Hmmm... why does CPU-intensive pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?