Re: Why schema of table is removed from explain?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why schema of table is removed from explain?
Date: 2011-09-01 20:35:14
Message-ID: 20110901203514.GA20328@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Sep 01, 2011 at 04:24:59PM -0400, Tom Lane wrote:
> hubert depesz lubaczewski <depesz(at)depesz(dot)com> writes:
> > $ explain select * from x.y limit 1;
> > QUERY PLAN
> > ------------------------------------------------------------
> > Limit (cost=0.00..0.04 rows=1 width=189)
> > -> Seq Scan on y (cost=0.00..13.70 rows=370 width=189)
> > (2 rows)
>
> > Why it doesn't show "Seq Scan on x.y" ?
>
> The non-plain-text output formats provide that sort of detail, if you
> need it.

Which is great, but why can't we have it in plain text too?

depesz

--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-09-01 20:39:06 Re: Why schema of table is removed from explain?
Previous Message Tom Lane 2011-09-01 20:24:59 Re: Why schema of table is removed from explain?