Re: [GENERAL] Understanding pg_stat_user_indexes

2010-02-05 Thread Josh Kupershmidt
On Fri, Feb 5, 2010 at 7:32 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > Josh Kupershmidt wrote: > > On Fri, Feb 5, 2010 at 12:02 PM, Steve Crawford < > scrawf...@pinpointresearch.com> wrote: > >> What causes an increment to idx_scan in pg_stat_user_indexes? "Select" >> queries o

Re: [GENERAL] Understanding pg_stat_user_indexes

2010-02-05 Thread Steve Crawford
Josh Kupershmidt wrote: On Fri, Feb 5, 2010 at 12:02 PM, Steve Crawford > wrote: What causes an increment to idx_scan in pg_stat_user_indexes? "Select" queries only? When used to enforce column uniqueness? When used for foreign-key constraints?

Re: [GENERAL] Understanding pg_stat_user_indexes

2010-02-05 Thread Josh Kupershmidt
On Fri, Feb 5, 2010 at 12:02 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > What causes an increment to idx_scan in pg_stat_user_indexes? "Select" > queries only? When used to enforce column uniqueness? When used for > foreign-key constraints? > > The docs are a little sparse here:

[GENERAL] Understanding pg_stat_user_indexes

2010-02-05 Thread Steve Crawford
What causes an increment to idx_scan in pg_stat_user_indexes? "Select" queries only? When used to enforce column uniqueness? When used for foreign-key constraints? I see lots of indexes with an idx_scan-count of zero but which are not actually superfluous as they are required to enforce constr