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?