Re: Inserts or Updates

From: Andy Colson <andy(at)squeakycode(dot)net>
To: Ofer Israeli <oferi(at)checkpoint(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, Olga Vingurt <olgavi(at)checkpoint(dot)com>, Netta Kabala <nettak(at)checkpoint(dot)com>
Subject: Re: Inserts or Updates
Date: 2012-02-07 19:43:13
Message-ID: 4F317ED1.6080907@squeakycode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Peter van Hardenberg 2012-02-08 00:59:58 random_page_cost = 2.0 on Heroku Postgres
Previous Message Kevin Grittner 2012-02-07 19:40:41 Re: Inserts or Updates