Re: ? in explain query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ? in explain query
Дата
Msg-id 19798.1067634797@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ? in explain query  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Список pgsql-admin
Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> In the explain below are the references
> "outer"."?column2?" = "inner"."?column2?"
> Ok?

Yeah, those are variables that don't have any name because they don't
correspond exactly to table columns.  It looks like the plan is
merge-joining (main.id)::text to (groups_1.instance)::text.  At the
level of the scans it's possible to see the expressions involved, but
at the level of the join those are just Var references to the outputs
of the lower plan steps.

We could possibly alter EXPLAIN to print the referred-to expression
instead of faking up a name for the Var node, but this would make the
printout look like the expression was being recomputed at the upper
level, which it isn't.

            regards, tom lane

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

Предыдущее
От: Brian Ristuccia
Дата:
Сообщение: Re: dumping tables from badly damaged db
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: fishing out LOG: duration lines from the logfile.