Re: [PERFORM] pg_stat_all_indexes understand

2015-09-09 Thread Bruce Momjian
On Thu, Jul 9, 2015 at 09:45:25AM -0700, Jeff Janes wrote: > > On Thu, Jul 9, 2015 at 5:20 AM, Nicolas Paris wrote: > > 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 i

Re: [PERFORM] pg_stat_all_indexes understand

2015-07-09 Thread Jeff Janes
On Thu, Jul 9, 2015 at 5:20 AM, Nicolas Paris wrote: > 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. > When the planner considers using a merge join on a i

[PERFORM] pg_stat_all_indexes understand

2015-07-09 Thread Nicolas Paris
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 ?