Why schema of table is removed from explain? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Why schema of table is removed from explain?
Date
Msg-id 20110901180822.GA18044@depesz.com
Whole thread Raw
Responses Re: Why schema of table is removed from explain?
Re: Why schema of table is removed from explain?
List pgsql-general
example:
$ create schema x;
CREATE SCHEMA

$ create table x.y as select * from pg_class;
SELECT 294

$ explain select * from x.y limit 1;
                         QUERY PLAN
------------------------------------------------------------
 Limit  (cost=0.00..0.04 rows=1 width=189)
   ->  Seq Scan on y  (cost=0.00..13.70 rows=370 width=189)
(2 rows)

Why it doesn't show "Seq Scan on x.y" ? it makes certain plans virtually
useless, when you can't know which schema was used?!

Best regards,

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
                                                             http://depesz.com/

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: md5 of table
Next
From: "David Johnston"
Date:
Subject: How to get around this limitation (ALTER DATABASE db SET search_path = ...)