Why schema of table is removed from explain?
| От | hubert depesz lubaczewski |
|---|---|
| Тема | Why schema of table is removed from explain? |
| Дата | |
| Msg-id | 20110901180822.GA18044@depesz.com обсуждение исходный текст |
| Ответы |
Re: Why schema of table is removed from explain?
Re: Why schema of table is removed from explain? |
| Список | 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 по дате отправления: