How to get fully qualified names with EXPLAIN

Поиск
Список
Период
Сортировка
От Bartosz Dmytrak
Тема How to get fully qualified names with EXPLAIN
Дата
Msg-id CAD8_UcbUup_-w0h_1AoeTxwv0EdLT9hCcVBa0voyrTN+P-ugFA@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to get fully qualified names with EXPLAIN
Список pgsql-general
Дерево обсуждения
Hi All
Let's assume I've got 3 tables:
  • "OrgStructure"."tblUnits", 
  • "OrgStructure"."tblUnitStructure", 
  • "Dictionary"."tblUnits"
I would like to do the EXPLAIN:
EXPLAIN
SELECT * FROM "OrgStructure"."tblUnits", "OrgStructure"."tblUnitStructure", "Dictionary"."tblUnits"
(Of course its cartesian product - doesn't matter) 

I've got result:
Nested Loop  (cost=0.00..971583.90 rows=77571000 width=482)
  ->  Nested Loop  (cost=0.00..1930.03 rows=152100 width=354)
        ->  Seq Scan on "tblUnits"  (cost=0.00..13.90 rows=390 width=177)
        ->  Materialize  (cost=0.00..15.85 rows=390 width=177)
              ->  Seq Scan on "tblUnits"  (cost=0.00..13.90 rows=390 width=177)
  ->  Materialize  (cost=0.00..17.65 rows=510 width=128)
        ->  Seq Scan on "tblUnitStructure"  (cost=0.00..15.10 rows=510 width=128)

My question is:
Which tblUnits is which one?
There are no fully qualified names in EXPLAIN output, so it looks impossible to determine information for particular table.

Is there any workaround, maybe I miss something?
any ideas, clues?


regards,
Bartek

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