How to get fully qualified names with EXPLAIN

[Bartosz Dmytrak <bdmytrak@xxxxxxxxx>]

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