| From: | "Ardian Xharra" <axharra(at)boxxo(dot)info> |
|---|---|
| To: | "Chris Hoover" <revoohc(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to trace index to table? |
| Date: | 2006-10-02 13:38:30 |
| Message-ID: | 016e01c6e628$0c2b9160$0f01a8c0@Boxxo |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
If you look on pg_indexes you find the index and the table.
----- Original Message -----
From: Chris Hoover
To: pgsql-general(at)postgresql(dot)org
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joey Adams | 2006-10-02 14:48:37 | FlushRelationBuffers Error |
| Previous Message | Chris Hoover | 2006-10-02 13:19:32 | How to trace index to table? |