Labeling join rule in EXPLAIN output

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Labeling join rule in EXPLAIN output
Дата
Msg-id 15125.1044897677@sss.pgh.pa.us
обсуждение исходный текст
Список pgsql-hackers
I've just added some code to explain.c to change the label of join nodes
when they are using special join rules (for outer joins or IN joins).
This wasn't all that interesting up through 7.3, because knowing the
query you could be quite sure which join rule was in effect at each
step.  But now that the planner knows some things about different ways
to implement IN and the possibility of reducing outer joins to plain
joins, I'm finding that it's important to be able to see the join rule
in EXPLAIN's output.

The alternatives I put in look like so:
"Nested Loop""Nested Loop Left Join""Nested Loop Full Join""Nested Loop Right Join""Nested Loop IN Join""Merge
Join""MergeLeft Join""Merge Full Join""Merge Right Join""Merge IN Join""Hash Join""Hash Left Join""Hash Full Join""Hash
RightJoin""Hash IN Join"
 

Although "Merge Left Join" seems to read well, I'm less happy with
"Nested Loop Left Join".  I'm tempted to relabel the nestloop cases
as
"Nestloop Join""Nestloop Left Join""Nestloop Full Join""Nestloop Right Join""Nestloop IN Join"

Is anyone particularly wedded to "Nested Loop"?  Or perhaps somebody
has some other, better idea?
        regards, tom lane


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

Предыдущее
От: "Frank Guan"
Дата:
Сообщение: descriptors in buffer manager?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Status report: regex replacement