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
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 |