| From: | Cristiano Duarte <cunha17(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | EXPLAIN verbose? |
| Date: | 2006-05-10 00:04:24 |
| Message-ID: | e3rame$bhk$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Does anyone know how to discover the tables (with schemas or oid) involved
on a select statement?
I tried EXPLAIN but it only reports the table names, not schemas or oid.
I am developing a SNAPSHOT project for PostgreSQL called Pg::snapshots. It
can be found here:
http://cunha17.theicy.net/personal/postgresql/snapshots.en_us.php
Everything is working, except that at some point I need to figure out wich
tables are data sources on a query in order to test for snapshot logs for
fast refresh. Since I can't get the place (schema) where the table is, I
can't test for the snapshot log table (wich is placed on the same schema as
the master table).
Any help would be greatly appreciated.
Regards,
Cristiano Duarte
| From | Date | Subject | |
|---|---|---|---|
| Next Message | kris.shannon | 2006-05-10 04:00:12 | Re: Constraint Exclusion + Joins? |
| Previous Message | Cristiano Duarte | 2006-05-09 23:45:20 | Re: BUG #2429: Explain does not report object's schema |