How to get fully qualified names with EXPLAIN

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How to get fully qualified names with EXPLAIN
Date: 2013-06-27 21:25:28
Message-ID: CAD8_UcbUup_-w0h_1AoeTxwv0EdLT9hCcVBa0voyrTN+P-ugFA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2013-06-27 21:33:38 Re: How to get fully qualified names with EXPLAIN
Previous Message Sergey Konoplev 2013-06-27 20:54:49 Re: Triggers NOT running as table owner