Re: How to get fully qualified names with EXPLAIN

Works like a charm :)

thanks a lot.

Regards,
Bartek

2013/6/27 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>

> Hello
>
>
> 2013/6/27 Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>:
> > 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?
>
> pls, try EXPLAIN VERBOSE
>
> postgres=# explain select * from xx.omega;
> QUERY PLAN
> ─────────────────────────────────────────────────────────
> Seq Scan on omega (cost=0.00..34.00 rows=2400 width=4)
> (1 row)
>
> postgres=# explain verbose select * from xx.omega;
> QUERY PLAN
> ────────────────────────────────────────────────────────────
> Seq Scan on xx.omega (cost=0.00..34.00 rows=2400 width=4)
> Output: a
> (2 rows)
>
> Regards
>
> Pavel Stehule
>
> >
> >
> > regards,
> > Bartek
>