Postgres Pro
Downloads
Home   >   mailing lists

Re: How to trace index to table? - Mailing list pgsql-general

From Ardian Xharra
Subject Re: How to trace index to table?
Date
Msg-id 016e01c6e628$0c2b9160$0f01a8c0@Boxxo
Whole thread Raw
In response to How to trace index to table?  ("Chris Hoover" <revoohc@gmail.com>)
List pgsql-general
Tree view
If you look on pg_indexes you find the index and the table.
 
----- Original Message -----
Sent: Monday, October 02, 2006 9:19 AM
Subject: [GENERAL] How to trace index to table?

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

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.407 / Virus Database: 268.12.11/460 - Release Date: 01/10/2006

pgsql-general by date:

Previous
From: "Chris Hoover"
Date:
Subject: How to trace index to table?
Next
From: Tom Lane
Date:
Subject: Re: Major Performance decrease after some hours