Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id A67D412B652F
	for <pgsql-performance@postgresql.org>;
	Tue,  7 Feb 2012 15:43:21 -0400 (AST)
Received: from li339-205.members.linode.com ([96.126.114.205]
	helo=squeakycode.net) by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <andy@squeakycode.net>) id 1Ruqwj-0001YZ-HN
	for pgsql-performance@postgresql.org; Tue, 07 Feb 2012 19:43:21 +0000
Received: from [192.168.10.84] (97-64-237-59.client.mchsi.com [97.64.237.59])
	(using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits))
	(No client certificate requested) (Authenticated sender: andy)
	by squeakycode.net (Postfix) with ESMTPSA id CC58F16830;
	Tue,  7 Feb 2012 13:43:08 -0600 (CST)
Message-ID: <4F317ED1.6080907@squeakycode.net>
Date: Tue, 07 Feb 2012 13:43:13 -0600
From: Andy Colson <andy@squeakycode.net>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:10.0) Gecko/20120129 Thunderbird/10.0
MIME-Version: 1.0
To: Ofer Israeli <oferi@checkpoint.com>
CC: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>,
	Olga Vingurt <olgavi@checkpoint.com>, Netta Kabala <nettak@checkpoint.com>
Subject: Re: Inserts or Updates
References: 
 <217DDBC2BB1E394CA9E7446337CBDEF20102C056BD4F@il-ex01.ad.checkpoint.com>
	<4F31397A.5090304@squeakycode.net>
	<217DDBC2BB1E394CA9E7446337CBDEF20102C056BE6F@il-ex01.ad.checkpoint.com>
	<4F317BBE.4020508@squeakycode.net>
In-Reply-To: <4F317BBE.4020508@squeakycode.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201202/45
X-Sequence-Number: 46217

Oh, I knew I'd seen index usage stats someplace.

give this a run:

select * from pg_stat_user_indexes where relname = 'SuperBigTable';

http://www.postgresql.org/docs/current/static/monitoring-stats.html

-Andy