subject:"\[GENERAL\] How to trace index to table\?"

Re: [GENERAL] How to trace index to table?

2006-10-02 Thread Ardian Xharra

If you look on pg_indexes you find the index and the table. - Original Message - From: Chris Hoover To: pgsql-general@postgresql.org Sent: Monday, October 02, 2006 9:19 AM Subject: [GENERAL] How to trace index to table? I'm trying to build some qu

[GENERAL] How to trace index to table?

2006-10-02 Thread Chris Hoover

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