Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a way to check which indexes are being used - Mailing list pgsql-general

From Vivek Khera
Subject Re: Is there a way to check which indexes are being used
Date
Msg-id C4AE8B16-F8AF-4059-9950-A8A2D7F4537B@khera.org
Whole thread Raw
In response to Re: Is there a way to check which indexes are being used  (Ragnar <gnari@hive.is>)
Responses Re: Is there a way to check which indexes are being used
List pgsql-general
Tree view 
On Feb 23, 2006, at 8:47 AM, Ragnar wrote:

> select * from pg_stat_user_indexes ;

which level of stats do I need to enable this? block level or row
level or both?

thanks.

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: SQL TYPE MAP such as SQL_CHAR, SQL_NUMERIC , etc
Next
From: Vivek Khera
Date:
Subject: Re: upgrade PostgreSQL 8.x on production FreeBSD