Re: EXPLAIN omits schema?

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: EXPLAIN omits schema?
Дата
Msg-id 467002FD.5000802@postgresql.org
обсуждение исходный текст
Ответ на Re: EXPLAIN omits schema?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> As already noted, it'd usually be clutter in lines that are too long
> already.  Also, conditionally adding a schema name isn't very good
> because it makes life even more complicated for programs that are
> parsing EXPLAIN output (yes, there are some).

Well, yes - that's precisely what pgAdmin does, which is why I'd want to 
see the schema name all the time. Up until now though all we've done is 
graphically represent the plan, so the object names haven't really been 
an issue. To take that further and allow the user to drill down to 
further information, or to provide tools to help tune queries we need to 
know for certain what table we're dealing with.

Regards, Dave



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: EXPLAIN omits schema?
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: EXPLAIN omits schema?