How to trace index to table?

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to trace index to table?
Date: 2006-10-02 13:19:32
Message-ID: 1d219a6f0610020619t685d974aif097d90d90749628@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to build some queries to gather metrics on my PG database. When
looking at pg_class and pulling a row that is an index, how do I use sql to
pull the table the index belongs to?

Thanks,

Chris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ardian Xharra 2006-10-02 13:38:30 Re: How to trace index to table?
Previous Message Ray Stell 2006-10-02 12:23:31 Re: Major Performance decrease after some hours