Re: pg_stat_all_indexes - Mailing list pgsql-admin

From Tom Lane
Subject Re: pg_stat_all_indexes
Date
Msg-id 29832.1194017210@sss.pgh.pa.us
Whole thread Raw
In response to pg_stat_all_indexes  ("Campbell, Lance" <lance@uiuc.edu>)
List pgsql-admin
"Campbell, Lance" <lance@uiuc.edu> writes:
> select * from pg_stat_all_indexes;
> My hope was to see if my indexes are being used.  The values I got were
> all 0's for the columns: idx_scan, idx_tup_read, and idx_tup_fetch.

You aren't collecting these stats:

> #stats_block_level = off
> #stats_row_level = off

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: jumpstart - pgsql.v824
Next
From: "Campbell, Lance"
Date:
Subject: Re: How do I identify the privileges a role has?