Lists: | pgsql-hackers |
---|
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 |
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: | "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: EXPLAIN verbose? |
Date: | 2006-05-12 06:53:27 |
Message-ID: | e41bdh$do0$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-hackers |
"Cristiano Duarte" <cunha17(at)gmail(dot)com> wrote
> 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.
>
In general, this is a pretty difficult problem - thinking you may do a
selection on a function which involves some other tables. By EXPLAIN,
you can only see a function scan node.
Regards,
Qingqing